DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_SPECIFICATIONS_B

Line 107: GMD_SPECIFICATIONS_B s,

103: v.last_updated_by ,
104: s.inventory_item_id,
105: v.subinventory, v.locator_id
106: FROM GMD_INVENTORY_SPEC_VRS v ,
107: GMD_SPECIFICATIONS_B s,
108: GMD_QC_STATUS_TL p,
109: GMD_QC_STATUS_TL t
110: WHERE V.SPEC_ID = S.SPEC_ID
111: AND s.spec_status = p.status_code

Line 132: GMD_SPECIFICATIONS_B S,

128: v.last_updated_by ,
129: s.inventory_item_id,
130: NULL subinventory, NULL locator_id
131: FROM GMD_WIP_SPEC_VRS V ,
132: GMD_SPECIFICATIONS_B S,
133: GMD_QC_STATUS_TL p,
134: GMD_QC_STATUS_TL t
135: WHERE V.SPEC_ID = S.SPEC_ID
136: AND s.spec_status = p.status_code

Line 157: GMD_SPECIFICATIONS_B S,

153: v.last_updated_by ,
154: s.inventory_item_id,
155: NULL subinventory, NULL locator_id
156: FROM GMD_CUSTOMER_SPEC_VRS V ,
157: GMD_SPECIFICATIONS_B S,
158: GMD_QC_STATUS_TL p,
159: GMD_QC_STATUS_TL t
160: WHERE V.SPEC_ID = S.SPEC_ID
161: AND s.spec_status = p.status_code

Line 182: GMD_SPECIFICATIONS_B S,

178: v.last_updated_by ,
179: s.inventory_item_id,
180: NULL subinventory, NULL locator_id
181: FROM GMD_SUPPLIER_SPEC_VRS V ,
182: GMD_SPECIFICATIONS_B S,
183: GMD_QC_STATUS_TL p,
184: GMD_QC_STATUS_TL t
185: WHERE V.SPEC_ID = S.SPEC_ID
186: AND s.spec_status = p.status_code

Line 207: GMD_SPECIFICATIONS_B S,

203: v.last_updated_by ,
204: TO_NUMBER(NULL),
205: v.subinventory, v.locator_id
206: FROM GMD_MONITORING_SPEC_VRS V ,
207: GMD_SPECIFICATIONS_B S,
208: GMD_QC_STATUS_TL p,
209: GMD_QC_STATUS_TL t
210: WHERE V.SPEC_ID = S.SPEC_ID
211: AND s.spec_status = p.status_code

Line 232: GMD_SPECIFICATIONS_B S,

228: v.last_updated_by ,
229: TO_NUMBER(NULL),
230: NULL subinventory, NULL locator_id
231: FROM GMD_STABILITY_SPEC_VRS V ,
232: GMD_SPECIFICATIONS_B S,
233: GMD_QC_STATUS_TL p,
234: GMD_QC_STATUS_TL t
235: WHERE V.SPEC_ID = S.SPEC_ID
236: AND s.spec_status = p.status_code

Line 305: GMD_SPECIFICATIONS_B S,

301: locations.concatenated_segments LOC,
302: a.organization_code,
303: hou.name organization_name
304: FROM GMD_MONITORING_SPEC_VRS V ,
305: GMD_SPECIFICATIONS_B S,
306: GMD_QC_STATUS_TL p,
307: GMD_QC_STATUS_TL t,
308: GEM_LOOKUPS src_type ,
309: MTL_ITEM_LOCATIONS_KFV locations,