DBA Data[Home] [Help]

APPS.INVPVDR7 dependencies on MTL_ITEM_LOCATIONS

Line 863: from MTL_ITEM_LOCATIONS

859: end;
860: elsif NVL(cr.RESTRICT_LOCATORS_CODE,2) = 2 THEN
861: begin
862: select 'x' INTO l_temp
863: from MTL_ITEM_LOCATIONS
864: where INVENTORY_LOCATION_ID = cr.PROCESS_SUPPLY_LOCATOR_ID
865: and SUBINVENTORY_CODE = cr.PROCESS_SUPPLY_SUBINVENTORY
866: and ORGANIZATION_ID = cr.ORGANIZATION_ID
867: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/

Line 1040: from MTL_ITEM_LOCATIONS

1036: end;
1037: elsif NVL(cr.RESTRICT_LOCATORS_CODE,2) = 2 THEN
1038: begin
1039: select 'x' INTO l_temp
1040: from MTL_ITEM_LOCATIONS
1041: where INVENTORY_LOCATION_ID = cr.PROCESS_YIELD_LOCATOR_ID
1042: and SUBINVENTORY_CODE = cr.PROCESS_YIELD_SUBINVENTORY
1043: and ORGANIZATION_ID = cr.ORGANIZATION_ID
1044: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/