APPS.GMD_SAMPLES_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

Line 112: select spec_vr_id, sample_inv_trans_ind from gmd_supplier_spec_vrs

108: select spec_vr_id, sample_inv_trans_ind from gmd_wip_spec_vrs
109: union all
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

Line 133: FROM gmd_supplier_spec_vrs

129: FROM gmd_wip_spec_vrs
130: WHERE spec_vr_id = p_spec_vr_id ;
131: ELSIF p_spec_type = 'S' THEN
132: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
133: FROM gmd_supplier_spec_vrs
134: WHERE spec_vr_id = p_spec_vr_id ;
135: END IF;
136:
137: END IF; -- IF p_spec_type IS NULL

Line 230: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs

226: select spec_vr_id, sampling_plan_id from gmd_wip_spec_vrs
227: union all
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

Line 271: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_supplier_spec_vrs

267: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_wip_spec_vrs
268: union all
269: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_customer_spec_vrs
270: union all
271: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_supplier_spec_vrs
272: )
273: WHERE spec_vr_id = p_spec_vr_id;
274:
275: -- 7027149