APPS.PMI_PRODUCTION_SUM dependencies on GMD_SAMPLE_SPEC_DISP

Line 330: GMD_SAMPLE_SPEC_DISP SMP_SPEC_DISP

326: end if;
327: Select count(*) into COMPLET_SAMPLES_v
328: from GMD_SAMPLES Smp,
329: GMD_EVENT_SPEC_DISP EVT_SPEC_DISP,
330: GMD_SAMPLE_SPEC_DISP SMP_SPEC_DISP
331: WHERE SMP.SAMPLING_EVENT_ID = EVT_SPEC_DISP.SAMPLING_EVENT_ID
332: AND EVT_SPEC_DISP.EVENT_SPEC_DISP_ID = SMP_SPEC_DISP.EVENT_SPEC_DISP_ID
333: AND EVT_SPEC_DISP.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
334: AND SMP_SPEC_DISP.DISPOSITION IN ('4A','5AV','6RJ')

Line 354: GMD_SAMPLE_SPEC_DISP SMP_SPEC_DISP

350: end if;
351: Select count(*) into PASSED_SAMPLES_V
352: from GMD_SAMPLES Smp,
353: GMD_EVENT_SPEC_DISP EVT_SPEC_DISP,
354: GMD_SAMPLE_SPEC_DISP SMP_SPEC_DISP
355: WHERE SMP.SAMPLING_EVENT_ID = EVT_SPEC_DISP.SAMPLING_EVENT_ID
356: AND EVT_SPEC_DISP.EVENT_SPEC_DISP_ID = SMP_SPEC_DISP.EVENT_SPEC_DISP_ID
357: AND EVT_SPEC_DISP.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
358: AND SMP_SPEC_DISP.DISPOSITION IN ('4A','5AV')