APPS.GMD_SAMPLES_PUB dependencies on GMD_MONITORING_SPEC_VRS

Line 107: select spec_vr_id, NULL sample_inv_trans_ind from gmd_monitoring_spec_vrs

103: select spec_vr_id, sample_inv_trans_ind from gmd_customer_spec_vrs
104: union all
105: select spec_vr_id, sample_inv_trans_ind from gmd_supplier_spec_vrs
106: union all
107: select spec_vr_id, NULL sample_inv_trans_ind from gmd_monitoring_spec_vrs
108: union all
109: select spec_vr_id, NULL sample_inv_trans_ind from gmd_stability_spec_vrs) s
110: WHERE s.spec_vr_id = p_spec_vr_id ;
111: ELSE

Line 222: select spec_vr_id, sampling_plan_id from gmd_monitoring_spec_vrs

218: select spec_vr_id, sampling_plan_id from gmd_customer_spec_vrs
219: union all
220: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs
221: union all
222: select spec_vr_id, sampling_plan_id from gmd_monitoring_spec_vrs
223: union all
224: select spec_vr_id, sampling_plan_id from gmd_stability_spec_vrs) s, gmd_sampling_plans b
225: WHERE s.spec_vr_id = p_spec_vr_id
226: AND s.sampling_plan_id = b.sampling_plan_id;