DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SECONDARY_LOCATORS

Line 8500: FROM MTL_SECONDARY_LOCATORS MSL,

8496: AND PROCESS_FLAG = 1
8497: AND LOCATOR_ID IS NOT NULL
8498: AND NOT EXISTS (
8499: SELECT NULL
8500: FROM MTL_SECONDARY_LOCATORS MSL,
8501: MTL_SYSTEM_ITEMS MSI
8502: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8503: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8504: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 8574: FROM MTL_SECONDARY_LOCATORS MSL,

8570: AND TRANSACTION_ACTION_ID in (2,21,3,5)
8571: AND TRANSFER_LOCATOR IS NOT NULL
8572: AND NOT EXISTS (
8573: SELECT NULL
8574: FROM MTL_SECONDARY_LOCATORS MSL,
8575: MTL_SYSTEM_ITEMS MSI
8576: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
8577: MTI.ORGANIZATION_ID, MTI.TRANSFER_ORGANIZATION)
8578: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID