eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_PROCESS_TEMP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 613: FROM MTL_ITEM_SUB_INVENTORIES MIS,

609: AND PROCESS_FLAG = 'Y'
610: AND TRANSACTION_STATUS = 3
611: AND NOT EXISTS (
612: SELECT NULL
613: FROM MTL_ITEM_SUB_INVENTORIES MIS,
614: MTL_SYSTEM_ITEMS MSI
615: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
616: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
617: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1

Line 761: FROM MTL_ITEM_SUB_INVENTORIES MIS,

757: AND TRANSFER_SUBINVENTORY IS NOT NULL
758: AND TRANSACTION_ACTION_ID in (2,21,3)
759: AND NOT EXISTS (
760: SELECT NULL
761: FROM MTL_ITEM_SUB_INVENTORIES MIS,
762: MTL_SYSTEM_ITEMS MSI
763: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID, 2,
764: MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
765: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID