APPS.GMD_SAMPLES_PUB dependencies on GMD_WIP_SPEC_VRS

Line 47: * 18-OCT-2005 Susan Feinstein Bug 4640143 Added material detail id to gmd_wip_spec_vrs table

43: * validations for receipt information
44: * in 'VALIDATE_SUPP_SAMPLE' procedure
45: *
46: * 20-MAY-2005 Susan Feinstein Bug 4165704 Inventory Convergence
47: * 18-OCT-2005 Susan Feinstein Bug 4640143 Added material detail id to gmd_wip_spec_vrs table
48: * 05-JAN-2006 Joe DiIorio Bug#4691545 Removed profile reference to
49: * NVL(fnd_profile.value('QC$EXACTSPECMATCH'),'N');
50: * and replaced with call to gmd_quality_config.
51: * Added FUNCTION GET_CONF_MATCH_VALUE as

Line 101: select spec_vr_id, sample_inv_trans_ind from gmd_wip_spec_vrs

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
104: union all
105: select spec_vr_id, sample_inv_trans_ind from gmd_supplier_spec_vrs

Line 122: FROM gmd_wip_spec_vrs

118: FROM gmd_customer_spec_vrs
119: WHERE spec_vr_id = p_spec_vr_id ;
120: ELSIF p_spec_type = 'W' THEN
121: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind
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

Line 216: select spec_vr_id, sampling_plan_id from gmd_wip_spec_vrs

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
219: union all
220: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs

Line 257: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_wip_spec_vrs

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
260: union all
261: select spec_vr_id, LOT_OPTIONAL_ON_SAMPLE from gmd_supplier_spec_vrs