DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SECONDARY_LOCATORS

Line 8003: FROM MTL_SECONDARY_LOCATORS MSL,

7999: AND PROCESS_FLAG = 1
8000: AND LOCATOR_ID IS NOT NULL
8001: AND NOT EXISTS (
8002: SELECT NULL
8003: FROM MTL_SECONDARY_LOCATORS MSL,
8004: MTL_SYSTEM_ITEMS MSI
8005: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8006: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8007: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 8077: FROM MTL_SECONDARY_LOCATORS MSL,

8073: AND TRANSACTION_ACTION_ID in (2,21,3,5)
8074: AND TRANSFER_LOCATOR IS NOT NULL
8075: AND NOT EXISTS (
8076: SELECT NULL
8077: FROM MTL_SECONDARY_LOCATORS MSL,
8078: MTL_SYSTEM_ITEMS MSI
8079: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
8080: MTI.ORGANIZATION_ID, MTI.TRANSFER_ORGANIZATION)
8081: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID