APPS.INVPVDR5 dependencies on MTL_ITEM_LOCATIONS

Line 1566: FROM MTL_ITEM_LOCATIONS

1562: END;
1563: ELSIF NVL(cr.RESTRICT_LOCATORS_CODE,2) = 2 THEN
1564: BEGIN
1565: SELECT 'x' INTO temp
1566: FROM MTL_ITEM_LOCATIONS
1567: WHERE INVENTORY_LOCATION_ID = cr.WIP_SUPPLY_LOCATOR_ID
1568: AND SUBINVENTORY_CODE = cr.WIP_SUPPLY_SUBINVENTORY
1569: AND ORGANIZATION_ID = cr.ORGANIZATION_ID
1570: AND SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/