APPS.GMD_QMSMC dependencies on MTL_PARAMETERS

Line 175: mtl_parameters mp

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
177: AND M.organization_id = B.organization_id
178: AND mp.organization_id = B.organization_id
179: AND M.inventory_item_id = B.inventory_item_id

Line 215: --FROM mtl_lot_numbers A, mtl_system_items_b_kfv B, mtl_parameters mp --RLNAGARA B4905645

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
219: AND mp.organization_id = A.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 267: mtl_parameters so,

263: rt.TRANSACTION_ID, -- 9509656
264: rt.last_updated_by --Bug#6276012 added
265: FROM rcv_transactions rt,
266: mtl_system_items_kfv im,
267: mtl_parameters so,
268: rcv_shipment_lines sl,
269: po_headers_all po,
270: rcv_shipment_headers sh,
271: hr_operating_units hou --RLNAGARA B5018797

Line 318: mtl_parameters so,

314: rt.MOBILE_TXN, -- 9509656
315: rt.TRANSACTION_ID -- 9509656
316: FROM rcv_transactions rt,
317: mtl_system_items_kfv im,
318: mtl_parameters so,
319: rcv_shipment_lines sl,
320: po_headers_all po,
321: rcv_shipment_headers sh,
322: hr_operating_units hou --RLNAGARA B5018797

Line 393: mtl_parameters so,

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,
397: rcv_lot_transactions tran,

Line 523: FROM po_vendors a, mtl_parameters m

519: --RLNAGARA B5018797 org_id is there in the po_headers_all table and hence getting from there.
520: -- Here we are getting vendor name instead of vendor_site_code.
521: CURSOR get_vendor_no IS /* 4576699*/
522: SELECT a.segment1
523: FROM po_vendors a, mtl_parameters m
524: WHERE a.vendor_id = l_vendor_id
525: AND m.organization_id = l_organization_id
526: AND m.process_enabled_flag = 'Y';
527:

Line 2337: MTL_PARAMETERS P,

2333: GMD_RECIPE_VALIDITY_RULES b,
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

Line 2386: MTL_PARAMETERS P,

2382: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
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