APPS.GMD_QC_MIG12 dependencies on GMD_EVENT_SPEC_DISP

Line 3818: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3814: =======================================*/
3815:
3816: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS
3817: SELECT DISTINCT gse.orgn_code, gse.organization_id
3818: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3819: gmd_inventory_spec_vrs gisv
3820: WHERE gse.sampling_event_id = gesd.sampling_event_id
3821: AND gesd.spec_vr_id = gisv.spec_vr_id
3822: AND gisv.spec_vr_id = v_spec_id;

Line 3849: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3845: =======================================*/
3846:
3847: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3848: SELECT DISTINCT gse.orgn_code, gse.organization_id
3849: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3850: gmd_wip_spec_vrs gwsv
3851: WHERE gse.sampling_event_id = gesd.sampling_event_id
3852: AND gesd.spec_vr_id = gwsv.spec_vr_id
3853: AND gwsv.spec_vr_id = v_spec_id;

Line 3928: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3924: =======================================*/
3925:
3926: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3927: SELECT DISTINCT gse.orgn_code, gse.organization_id
3928: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3929: gmd_customer_spec_vrs gcsv
3930: WHERE gse.sampling_event_id = gesd.sampling_event_id
3931: AND gesd.spec_vr_id = gcsv.spec_vr_id
3932: AND gcsv.spec_vr_id = v_spec_id;

Line 3990: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

3986: =======================================*/
3987:
3988: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3989: SELECT DISTINCT gse.orgn_code, gse.organization_id
3990: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3991: gmd_supplier_spec_vrs gssv
3992: WHERE gse.sampling_event_id = gesd.sampling_event_id
3993: AND gesd.spec_vr_id = gssv.spec_vr_id
3994: AND gssv.spec_vr_id = v_spec_id;

Line 4050: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4046: ==========================================*/
4047:
4048: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4049: SELECT DISTINCT gse.orgn_code, gse.organization_id
4050: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4051: gmd_monitoring_spec_vrs gmsv
4052: WHERE gse.sampling_event_id = gesd.sampling_event_id
4053: AND gesd.spec_vr_id = gmsv.spec_vr_id
4054: AND gmsv.spec_vr_id = v_spec_id;