APPS.PMI_PRODUCTION_SUM dependencies on GMD_EVENT_SPEC_DISP

Line 329: GMD_EVENT_SPEC_DISP EVT_SPEC_DISP,

325: return PKG_VAR_NO_OF_SMPL_CMPLT_V;
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'

Line 353: GMD_EVENT_SPEC_DISP EVT_SPEC_DISP,

349: return PKG_VAR_PASSED_SAMPLES_V;
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'