DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on MTL_SECONDARY_LOCATORS

Line 678: FROM MTL_SECONDARY_LOCATORS MSL,

674: AND TRANSACTION_STATUS = 3
675: AND LOCATOR_ID IS NOT NULL
676: AND NOT EXISTS (
677: SELECT NULL
678: FROM MTL_SECONDARY_LOCATORS MSL,
679: MTL_SYSTEM_ITEMS MSI
680: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
681: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
682: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 832: FROM MTL_SECONDARY_LOCATORS MSL,

828: AND TRANSACTION_ACTION_ID in (2,21,3)
829: AND TRANSFER_TO_LOCATION IS NOT NULL
830: AND NOT EXISTS (
831: SELECT NULL
832: FROM MTL_SECONDARY_LOCATORS MSL,
833: MTL_SYSTEM_ITEMS MSI
834: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID, 2,
835: MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
836: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID