APPS.GMD_QMSMC dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 158: FROM MTL_SYSTEM_ITEMS_B_KFV B,

154: M.ORGANIZATION_ID,
155: mp.organization_code,
156: M.SUBINVENTORY_code,
157: M.LOCATOR_ID
158: FROM MTL_SYSTEM_ITEMS_B_KFV B,
159: MTL_MATERIAL_TRANSACTIONS M,
160: MTL_TRANSACTION_TYPES T,
161: mtl_parameters mp
162: WHERE M.transaction_id = l_event_key

Line 201: mtl_system_items_b_kfv B,

197: B.primary_uom_code,
198: A.expiration_date,
199: A.Retest_Date
200: FROM mtl_lot_numbers A,
201: mtl_system_items_b_kfv B,
202: mtl_parameters mp --RLNAGARA B4905645
203: WHERE
204: A.inventory_item_id = B.inventory_item_id AND
205: A.organization_id = B.organization_id AND

Line 294: mtl_system_items_b_kfv im,

290: sum(tran.quantity) lot_primary,
291: sum(tran.secondary_quantity) lot_secondary,
292: rt.vendor_lot_num --Bug#6145310
293: FROM rcv_transactions rt,
294: mtl_system_items_b_kfv im,
295: mtl_parameters so,
296: rcv_shipment_lines sl,
297: po_headers_all po ,
298: rcv_shipment_headers sh ,

Line 2082: MTL_SYSTEM_ITEMS_B_KFV I

2078: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
2079: GME_MATERIAL_DETAILS F,
2080: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2081: MTL_PARAMETERS P,
2082: MTL_SYSTEM_ITEMS_B_KFV I
2083: WHERE
2084: A.BATCH_ID = x_batch_id AND
2085: A.BATCH_ID = F.BATCH_ID AND
2086: A.RECIPE_VALIDITY_RULE_ID = B.RECIPE_VALIDITY_RULE_ID AND

Line 2126: MTL_SYSTEM_ITEMS_B_KFV I

2122: GME_BATCH_STEPS D,
2123: GME_MATERIAL_DETAILS F,
2124: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2125: MTL_PARAMETERS P,
2126: MTL_SYSTEM_ITEMS_B_KFV I
2127: WHERE
2128: A.BATCH_ID =x_batch_id AND
2129: A.BATCH_ID =F.BATCH_ID AND
2130: A.BATCH_ID =D.BATCH_ID AND