Inspection Processing Search

Yahoo Archive
1
yes, this is it! Thank you very much : -D

Michael

--- In vantage@yahoogroups.com, "Jean" <jbillet@...> wrote:
>
> try using the RcvDtl table instead...
>
> RcvDtl.InspectionReq = true AND RcvDtl.InspectionPending = true
>
>
>
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I need to construct a query that will show the same results as per the Inspection Processing Search - Production Management\QA\Gen Ops\Inspec Processing
> >
> > Does anyone know where to start. I've found the values in the Part Tran table, narrowed for Tran Type = PUR-INS but that returns all records - how do I just show the ones that are currently sitting in inspection?
> >
> > Regards,
> >
> > Michael
> > Vantage
> >
>
2
Hello,

I need to construct a query that will show the same results as per the Inspection Processing Search - Production Management\QA\Gen Ops\Inspec Processing

Does anyone know where to start. I've found the values in the Part Tran table, narrowed for Tran Type = PUR-INS but that returns all records - how do I just show the ones that are currently sitting in inspection?

Regards,

Michael
Vantage
3
try using the RcvDtl table instead...

RcvDtl.InspectionReq = true AND RcvDtl.InspectionPending = true




--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I need to construct a query that will show the same results as per the Inspection Processing Search - Production Management\QA\Gen Ops\Inspec Processing
>
> Does anyone know where to start. I've found the values in the Part Tran table, narrowed for Tran Type = PUR-INS but that returns all records - how do I just show the ones that are currently sitting in inspection?
>
> Regards,
>
> Michael
> Vantage
>