APPS.INVPVDR5 dependencies on MTL_ITEM_LOCATIONS

Line 1595: FROM MTL_ITEM_LOCATIONS

1591: END;
1592: ELSIF NVL(cr.RESTRICT_LOCATORS_CODE,2) = 2 THEN
1593: BEGIN
1594: SELECT 'x' INTO temp
1595: FROM MTL_ITEM_LOCATIONS
1596: WHERE INVENTORY_LOCATION_ID = cr.WIP_SUPPLY_LOCATOR_ID
1597: AND SUBINVENTORY_CODE = cr.WIP_SUPPLY_SUBINVENTORY
1598: AND ORGANIZATION_ID = cr.ORGANIZATION_ID
1599: AND SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/