APPS.GMD_SAMPLES_PUB dependencies on GMD_INVENTORY_SPEC_VRS

Line 99: FROM (select spec_vr_id, sample_inv_trans_ind from gmd_inventory_spec_vrs

95: /*SELECT s.sample_inv_trans_ind INTO l_sample_inv_trans_ind
96: FROM gmd_all_spec_vrs WHERE spec_vr_id = p_spec_vr_id ;*/
97: --Query rewritten as part of bug# 4916871
98: select s.sample_inv_trans_ind INTO l_sample_inv_trans_ind
99: FROM (select spec_vr_id, sample_inv_trans_ind from gmd_inventory_spec_vrs
100: union all
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

Line 114: FROM gmd_inventory_spec_vrs

110: WHERE s.spec_vr_id = p_spec_vr_id ;
111: ELSE
112: IF p_spec_type = 'I' THEN
113: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
114: FROM gmd_inventory_spec_vrs
115: WHERE spec_vr_id = p_spec_vr_id ;
116: ELSIF p_spec_type = 'C' THEN
117: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
118: FROM gmd_customer_spec_vrs

Line 214: (select spec_vr_id, sampling_plan_id from gmd_inventory_spec_vrs

210: CURSOR c_get_sample_cnt (p_spec_vr_id NUMBER)
211: IS
212: SELECT b.sample_cnt_req
213: FROM
214: (select spec_vr_id, sampling_plan_id from gmd_inventory_spec_vrs
215: union all
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

Line 255: (select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_inventory_spec_vrs

251: CURSOR c_get_lot_optional (p_spec_vr_id NUMBER)
252: IS
253: SELECT LOT_OPTIONAL_ON_SAMPLE
254: FROM
255: (select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_inventory_spec_vrs
256: union all
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