DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2794: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi

2790: END IF;
2791:
2792: SELECT msi.*
2793: INTO p_sub
2794: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi
2795: WHERE msi.secondary_inventory_name = p_sub.secondary_inventory_name
2796: AND msi.organization_id = p_org.organization_id
2797: AND NVL(MSI.DISABLE_DATE,SYSDATE) >= SYSDATE
2798: AND msi.organization_id = misi.organization_id