APPS.GMD_SAMPLES_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

Line 105: select spec_vr_id, sample_inv_trans_ind from gmd_supplier_spec_vrs

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

Line 126: FROM gmd_supplier_spec_vrs

122: FROM gmd_wip_spec_vrs
123: WHERE spec_vr_id = p_spec_vr_id ;
124: ELSIF p_spec_type = 'S' THEN
125: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
126: FROM gmd_supplier_spec_vrs
127: WHERE spec_vr_id = p_spec_vr_id ;
128: END IF;
129:
130: END IF; -- IF p_spec_type IS NULL

Line 220: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs

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

Line 261: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_supplier_spec_vrs

257: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_wip_spec_vrs
258: union all
259: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_customer_spec_vrs
260: union all
261: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_supplier_spec_vrs
262: )
263: WHERE spec_vr_id = p_spec_vr_id;
264:
265: BEGIN