APPS.GMD_SAMPLES_PUB dependencies on GMD_MONITORING_SPEC_VRS

Line 114: select spec_vr_id, NULL sample_inv_trans_ind from gmd_monitoring_spec_vrs

110: select spec_vr_id, sample_inv_trans_ind from gmd_customer_spec_vrs
111: union all
112: select spec_vr_id, sample_inv_trans_ind from gmd_supplier_spec_vrs
113: union all
114: select spec_vr_id, NULL sample_inv_trans_ind from gmd_monitoring_spec_vrs
115: union all
116: select spec_vr_id, NULL sample_inv_trans_ind from gmd_stability_spec_vrs) s
117: WHERE s.spec_vr_id = p_spec_vr_id ;
118: ELSE

Line 232: select spec_vr_id, sampling_plan_id from gmd_monitoring_spec_vrs

228: select spec_vr_id, sampling_plan_id from gmd_customer_spec_vrs
229: union all
230: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs
231: union all
232: select spec_vr_id, sampling_plan_id from gmd_monitoring_spec_vrs
233: union all
234: select spec_vr_id, sampling_plan_id from gmd_stability_spec_vrs) s, gmd_sampling_plans b
235: WHERE s.spec_vr_id = p_spec_vr_id
236: AND s.sampling_plan_id = b.sampling_plan_id;