DBA Data[Home] [Help]

APPS.INV_MOVE_ORDER_PUB dependencies on MTL_ITEM_SUB_INVENTORIES

Line 518: FROM mtl_item_sub_inventories

514: INTO l_result
515: FROM DUAL
516: WHERE exists (
517: SELECT secondary_inventory
518: FROM mtl_item_sub_inventories
519: WHERE organization_id = x_trolin_tbl(l_index).organization_id
520: AND secondary_inventory = x_trolin_tbl(l_index).to_subinventory_code
521: AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);
522: EXCEPTION

Line 562: FROM mtl_item_sub_inventories

558: INTO l_result
559: FROM DUAL
560: WHERE exists (
561: SELECT secondary_inventory
562: FROM mtl_item_sub_inventories
563: WHERE organization_id = x_trolin_tbl(l_index).organization_id
564: AND secondary_inventory = x_trolin_tbl(l_index).from_subinventory_code
565: AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);
566: EXCEPTION