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.FLM_KANBAN_CONSOLIDATION dependencies on MTL_SECONDARY_INVENTORIES

Line 254: from mtl_secondary_inventories

250: and inventory_item_id = l_Kanban_Card_Rec_Tbl(l_order_count).inventory_item_id;
251:
252: select locator_type
253: into l_from_sub_locator_type
254: from mtl_secondary_inventories
255: where organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id
256: and secondary_inventory_name = l_Kanban_Card_Rec_Tbl(l_order_count).source_subinventory;
257:
258: select locator_type

Line 260: from mtl_secondary_inventories

256: and secondary_inventory_name = l_Kanban_Card_Rec_Tbl(l_order_count).source_subinventory;
257:
258: select locator_type
259: into l_to_sub_locator_type
260: from mtl_secondary_inventories
261: where organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id
262: and secondary_inventory_name = l_Kanban_Card_Rec_Tbl(l_order_count).subinventory_name;
263:
264: select stock_locator_control_code

Line 500: mtl_secondary_inventories mss

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
503: And org.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_Id
504: And mss.Organization_id = l_kanban_card_Rec_Tbl(1).Organization_id