DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2660: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi

2656: END IF;
2657:
2658: SELECT msi.*
2659: INTO p_sub
2660: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi
2661: WHERE msi.secondary_inventory_name = p_sub.secondary_inventory_name
2662: AND msi.organization_id = p_org.organization_id
2663: AND NVL(MSI.DISABLE_DATE,SYSDATE) >= SYSDATE
2664: AND msi.organization_id = misi.organization_id