DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 2236: from mtl_secondary_inventories

2232: and inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id;
2233:
2234: select locator_type
2235: into l_from_sub_locator_type
2236: from mtl_secondary_inventories
2237: where organization_id = p_kanban_card_rec_tbl(1).organization_id
2238: and secondary_inventory_name = p_kanban_card_rec_tbl(1).source_subinventory;
2239:
2240: select locator_type

Line 2242: from mtl_secondary_inventories

2238: and secondary_inventory_name = p_kanban_card_rec_tbl(1).source_subinventory;
2239:
2240: select locator_type
2241: into l_to_sub_locator_type
2242: from mtl_secondary_inventories
2243: where organization_id = p_kanban_card_rec_tbl(1).organization_id
2244: and secondary_inventory_name = p_kanban_card_rec_tbl(1).subinventory_name;
2245:
2246: select stock_locator_control_code

Line 3467: mtl_secondary_inventories mss

3463: l_PostProcess_lead_Time,
3464: l_Revision_qty_control_code
3465: From Mtl_System_Items msi,
3466: mtl_Parameters org,
3467: mtl_secondary_inventories mss
3468: Where Msi.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_id
3469: And Msi.Inventory_Item_Id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
3470: And org.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_Id
3471: And mss.Organization_id = l_kanban_card_Rec_Tbl(1).Organization_id