APPS.FLM_KANBAN_CONSOLIDATION dependencies on MTL_SYSTEM_ITEMS

Line 248: from mtl_system_items

244: For l_order_count in 1..l_Kanban_Card_Rec_Tbl.Count Loop
245: fnd_file.put_line(fnd_file.log,'inside loop');
246: select location_control_code,secondary_uom_code
247: into l_item_locator_control_code,l_secondary_uom_code
248: from mtl_system_items
249: where organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id
250: and inventory_item_id = l_Kanban_Card_Rec_Tbl(l_order_count).inventory_item_id;
251:
252: select locator_type

Line 498: From Mtl_System_Items msi,

494: l_PreProcess_lead_Time,
495: l_Process_lead_Time,
496: l_PostProcess_lead_Time,
497: l_Revision_qty_control_code
498: From Mtl_System_Items msi,
499: mtl_Parameters org,
500: mtl_secondary_inventories mss
501: Where Msi.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_id
502: And Msi.Inventory_Item_Id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id