eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_QC_STATUS_TL

Line 108: GMD_QC_STATUS_TL p,

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
112: AND p.entity_type = 'S'

Line 109: GMD_QC_STATUS_TL t

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
112: AND p.entity_type = 'S'
113: AND p.language = USERENV('LANG')

Line 133: GMD_QC_STATUS_TL p,

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
137: AND p.entity_type = 'S'

Line 134: GMD_QC_STATUS_TL t

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
137: AND p.entity_type = 'S'
138: AND p.language = USERENV('LANG')

Line 158: GMD_QC_STATUS_TL p,

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
162: AND p.entity_type = 'S'

Line 159: GMD_QC_STATUS_TL t

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
162: AND p.entity_type = 'S'
163: AND p.language = USERENV('LANG')

Line 183: GMD_QC_STATUS_TL p,

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
187: AND p.entity_type = 'S'

Line 184: GMD_QC_STATUS_TL t

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
187: AND p.entity_type = 'S'
188: AND p.language = USERENV('LANG')

Line 208: GMD_QC_STATUS_TL p,

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
212: AND p.entity_type = 'S'

Line 209: GMD_QC_STATUS_TL t

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
212: AND p.entity_type = 'S'
213: AND p.language = USERENV('LANG')

Line 233: GMD_QC_STATUS_TL p,

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
237: AND p.entity_type = 'S'

Line 234: GMD_QC_STATUS_TL t

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
237: AND p.entity_type = 'S'
238: AND p.language = USERENV('LANG')

Line 306: GMD_QC_STATUS_TL p,

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,
310: MTL_PARAMETERS a,

Line 307: GMD_QC_STATUS_TL t,

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,
310: MTL_PARAMETERS a,
311: HR_ALL_ORGANIZATION_UNITS hou