DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on MTL_SECONDARY_LOCATORS

Line 1554: FROM MTL_SECONDARY_LOCATORS

1550: l_wip_locator_error := TRUE;
1551: ELSIF cr.RESTRICT_LOCATORS_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' THEN
1552: BEGIN
1553: SELECT 'x' INTO temp
1554: FROM MTL_SECONDARY_LOCATORS
1555: WHERE INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
1556: AND ORGANIZATION_ID = cr.ORGANIZATION_ID
1557: AND SECONDARY_LOCATOR = cr.WIP_SUPPLY_LOCATOR_ID
1558: AND SUBINVENTORY_CODE = cr.WIP_SUPPLY_SUBINVENTORY;