DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1937: from mtl_secondary_inventories

1933: and inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id;
1934:
1935: select locator_type
1936: into l_from_sub_locator_type
1937: from mtl_secondary_inventories
1938: where organization_id = p_kanban_card_rec_tbl(1).organization_id
1939: and secondary_inventory_name = p_kanban_card_rec_tbl(1).source_subinventory;
1940:
1941: select locator_type

Line 1943: from mtl_secondary_inventories

1939: and secondary_inventory_name = p_kanban_card_rec_tbl(1).source_subinventory;
1940:
1941: select locator_type
1942: into l_to_sub_locator_type
1943: from mtl_secondary_inventories
1944: where organization_id = p_kanban_card_rec_tbl(1).organization_id
1945: and secondary_inventory_name = p_kanban_card_rec_tbl(1).subinventory_name;
1946:
1947: select stock_locator_control_code

Line 3068: mtl_secondary_inventories mss

3064: l_PostProcess_lead_Time,
3065: l_Revision_qty_control_code
3066: From Mtl_System_Items msi,
3067: mtl_Parameters org,
3068: mtl_secondary_inventories mss
3069: Where Msi.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_id
3070: And Msi.Inventory_Item_Id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
3071: And org.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_Id
3072: And mss.Organization_id = l_kanban_card_Rec_Tbl(1).Organization_id