DBA Data[Home] [Help]

APPS.INVPVDR7 dependencies on MTL_SECONDARY_LOCATORS

Line 850: from MTL_SECONDARY_LOCATORS

846: l_process_locator_error := TRUE;
847: elsif cr.RESTRICT_LOCATORS_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' then
848: BEGIN
849: select 'x' INTO l_temp
850: from MTL_SECONDARY_LOCATORS
851: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
852: and ORGANIZATION_ID = cr.ORGANIZATION_ID
853: and SECONDARY_LOCATOR = cr.PROCESS_SUPPLY_LOCATOR_ID
854: and SUBINVENTORY_CODE = cr.PROCESS_SUPPLY_SUBINVENTORY;

Line 1027: from MTL_SECONDARY_LOCATORS

1023: l_process_locator_error := TRUE;
1024: elsif cr.RESTRICT_LOCATORS_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' then
1025: BEGIN
1026: select 'x' INTO l_temp
1027: from MTL_SECONDARY_LOCATORS
1028: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
1029: and ORGANIZATION_ID = cr.ORGANIZATION_ID
1030: and SECONDARY_LOCATOR = cr.PROCESS_YIELD_LOCATOR_ID
1031: and SUBINVENTORY_CODE = cr.PROCESS_YIELD_SUBINVENTORY;