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.GMD_QMSMC dependencies on MTL_SYSTEM_ITEMS_VL

Line 170: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS

166: M.LOCATOR_ID,
167: M.transaction_source_type_id, -- 9756188 added
168: M.transaction_action_id, -- 9756188 added
169: M.last_updated_by -- 6276012 added
170: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS
171: --FROM MTL_SYSTEM_ITEMS_B_KFV B,
172: FROM MTL_SYSTEM_ITEMS_VL B,
173: MTL_MATERIAL_TRANSACTIONS M,
174: MTL_TRANSACTION_TYPES T,

Line 172: FROM MTL_SYSTEM_ITEMS_VL B,

168: M.transaction_action_id, -- 9756188 added
169: M.last_updated_by -- 6276012 added
170: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS
171: --FROM MTL_SYSTEM_ITEMS_B_KFV B,
172: FROM MTL_SYSTEM_ITEMS_VL B,
173: MTL_MATERIAL_TRANSACTIONS M,
174: MTL_TRANSACTION_TYPES T,
175: mtl_parameters mp
176: WHERE M.transaction_id = l_trans_id -- replace l_event_key by l_trans_id -- 9756188

Line 214: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS

210: B.primary_uom_code,
211: A.expiration_date,
212: A.Retest_Date,
213: A.last_updated_by --Bug#6276012 added
214: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS
215: --FROM mtl_lot_numbers A, mtl_system_items_b_kfv B, mtl_parameters mp --RLNAGARA B4905645
216: FROM mtl_lot_numbers A, mtl_system_items_vl B, mtl_parameters mp --RLNAGARA B4905645
217: WHERE A.inventory_item_id = B.inventory_item_id
218: AND A.organization_id = B.organization_id

Line 216: FROM mtl_lot_numbers A, mtl_system_items_vl B, mtl_parameters mp --RLNAGARA B4905645

212: A.Retest_Date,
213: A.last_updated_by --Bug#6276012 added
214: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS
215: --FROM mtl_lot_numbers A, mtl_system_items_b_kfv B, mtl_parameters mp --RLNAGARA B4905645
216: FROM mtl_lot_numbers A, mtl_system_items_vl B, mtl_parameters mp --RLNAGARA B4905645
217: WHERE A.inventory_item_id = B.inventory_item_id
218: AND A.organization_id = B.organization_id
219: AND mp.organization_id = A.organization_id
220: AND --RLNAGARA B4905645

Line 390: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS

386: rt.vendor_lot_num ,--Bug#6145310
387: lot.grade_code, -- 10044459
388: tran.last_updated_by --Bug#6276012 added
389: FROM rcv_transactions rt,
390: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
391: --mtl_system_items_b_kfv im,
392: mtl_system_items_vl im,
393: mtl_parameters so,
394: rcv_shipment_lines sl,

Line 392: mtl_system_items_vl im,

388: tran.last_updated_by --Bug#6276012 added
389: FROM rcv_transactions rt,
390: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
391: --mtl_system_items_b_kfv im,
392: mtl_system_items_vl im,
393: mtl_parameters so,
394: rcv_shipment_lines sl,
395: po_headers_all po,
396: rcv_shipment_headers sh,

Line 2338: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS

2334: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
2335: GME_MATERIAL_DETAILS F,
2336: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2337: MTL_PARAMETERS P,
2338: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
2339: --MTL_SYSTEM_ITEMS_B_KFV I
2340: MTL_SYSTEM_ITEMS_VL I
2341: WHERE A.BATCH_ID = x_batch_id
2342: AND A.BATCH_ID = F.BATCH_ID

Line 2340: MTL_SYSTEM_ITEMS_VL I

2336: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2337: MTL_PARAMETERS P,
2338: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
2339: --MTL_SYSTEM_ITEMS_B_KFV I
2340: MTL_SYSTEM_ITEMS_VL I
2341: WHERE A.BATCH_ID = x_batch_id
2342: AND A.BATCH_ID = F.BATCH_ID
2343: AND A.RECIPE_VALIDITY_RULE_ID = B.RECIPE_VALIDITY_RULE_ID
2344: AND B.RECIPE_ID = C.RECIPE_ID

Line 2387: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS

2383: GME_BATCH_STEPS D,
2384: GME_MATERIAL_DETAILS F,
2385: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2386: MTL_PARAMETERS P,
2387: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
2388: --MTL_SYSTEM_ITEMS_B_KFV I
2389: MTL_SYSTEM_ITEMS_VL I
2390: WHERE A.BATCH_ID = x_batch_id
2391: AND A.BATCH_ID = F.BATCH_ID

Line 2389: MTL_SYSTEM_ITEMS_VL I

2385: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2386: MTL_PARAMETERS P,
2387: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
2388: --MTL_SYSTEM_ITEMS_B_KFV I
2389: MTL_SYSTEM_ITEMS_VL I
2390: WHERE A.BATCH_ID = x_batch_id
2391: AND A.BATCH_ID = F.BATCH_ID
2392: AND A.BATCH_ID = D.BATCH_ID
2393: AND A.RECIPE_VALIDITY_RULE_ID = B.RECIPE_VALIDITY_RULE_ID