APPS.GMD_SAMPLES_PUB dependencies on GMD_INVENTORY_SPEC_VRS

Line 106: FROM (select spec_vr_id, sample_inv_trans_ind from gmd_inventory_spec_vrs

102: /*SELECT s.sample_inv_trans_ind INTO l_sample_inv_trans_ind
103: FROM gmd_all_spec_vrs WHERE spec_vr_id = p_spec_vr_id ;*/
104: --Query rewritten as part of bug# 4916871
105: select s.sample_inv_trans_ind INTO l_sample_inv_trans_ind
106: FROM (select spec_vr_id, sample_inv_trans_ind from gmd_inventory_spec_vrs
107: union all
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

Line 121: FROM gmd_inventory_spec_vrs

117: WHERE s.spec_vr_id = p_spec_vr_id ;
118: ELSE
119: IF p_spec_type = 'I' THEN
120: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
121: FROM gmd_inventory_spec_vrs
122: WHERE spec_vr_id = p_spec_vr_id ;
123: ELSIF p_spec_type = 'C' THEN
124: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
125: FROM gmd_customer_spec_vrs

Line 224: (select spec_vr_id, sampling_plan_id from gmd_inventory_spec_vrs

220: CURSOR c_get_sample_cnt (p_spec_vr_id NUMBER)
221: IS
222: SELECT b.sample_cnt_req
223: FROM
224: (select spec_vr_id, sampling_plan_id from gmd_inventory_spec_vrs
225: union all
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

Line 265: (select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_inventory_spec_vrs

261: CURSOR c_get_lot_optional (p_spec_vr_id NUMBER)
262: IS
263: SELECT LOT_OPTIONAL_ON_SAMPLE
264: FROM
265: (select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_inventory_spec_vrs
266: union all
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