APPS.GMD_QC_MIG12 dependencies on GMD_EVENT_SPEC_DISP

Line 4087: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4083: =======================================*/
4084:
4085: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS
4086: SELECT DISTINCT gse.orgn_code, gse.organization_id
4087: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4088: gmd_inventory_spec_vrs gisv
4089: WHERE gse.sampling_event_id = gesd.sampling_event_id
4090: AND gesd.spec_vr_id = gisv.spec_vr_id
4091: AND gisv.spec_vr_id = v_spec_id;

Line 4118: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4114: =======================================*/
4115:
4116: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4117: SELECT DISTINCT gse.orgn_code, gse.organization_id
4118: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4119: gmd_wip_spec_vrs gwsv
4120: WHERE gse.sampling_event_id = gesd.sampling_event_id
4121: AND gesd.spec_vr_id = gwsv.spec_vr_id
4122: AND gwsv.spec_vr_id = v_spec_id;

Line 4197: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4193: =======================================*/
4194:
4195: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4196: SELECT DISTINCT gse.orgn_code, gse.organization_id
4197: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4198: gmd_customer_spec_vrs gcsv
4199: WHERE gse.sampling_event_id = gesd.sampling_event_id
4200: AND gesd.spec_vr_id = gcsv.spec_vr_id
4201: AND gcsv.spec_vr_id = v_spec_id;

Line 4259: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4255: =======================================*/
4256:
4257: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4258: SELECT DISTINCT gse.orgn_code, gse.organization_id
4259: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4260: gmd_supplier_spec_vrs gssv
4261: WHERE gse.sampling_event_id = gesd.sampling_event_id
4262: AND gesd.spec_vr_id = gssv.spec_vr_id
4263: AND gssv.spec_vr_id = v_spec_id;

Line 4319: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4315: ==========================================*/
4316:
4317: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4318: SELECT DISTINCT gse.orgn_code, gse.organization_id
4319: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4320: gmd_monitoring_spec_vrs gmsv
4321: WHERE gse.sampling_event_id = gesd.sampling_event_id
4322: AND gesd.spec_vr_id = gmsv.spec_vr_id
4323: AND gmsv.spec_vr_id = v_spec_id;