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_LOC_WMS_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2580: FROM mtl_material_transactions_temp mmtt,

2576: , mmtt.transfer_lpn_id transfer_lpn_id
2577: , mmtt.content_lpn_id content_lpn_id
2578: , mmtt.lpn_id lpn_id
2579: , transaction_status transaction_status
2580: FROM mtl_material_transactions_temp mmtt,
2581: mtl_item_locations mil
2582: WHERE mmtt.locator_id = mil.inventory_location_id
2583: AND mil.organization_id = mmtt.organization_id
2584: AND mil.subinventory_code = mmtt.subinventory_code

Line 2612: FROM mtl_material_transactions_temp mmtt,

2608: , mmtt.transfer_lpn_id transfer_lpn_id
2609: , mmtt.content_lpn_id content_lpn_id
2610: , mmtt.lpn_id lpn_id
2611: , transaction_status transaction_status
2612: FROM mtl_material_transactions_temp mmtt,
2613: mtl_item_locations mil
2614: WHERE mmtt.transfer_to_location = mil.inventory_location_id
2615: AND mil.organization_id = mmtt.organization_id
2616: AND mil.subinventory_code = mmtt.transfer_subinventory--bug 6110275 for destination locator

Line 7340: FROM mtl_material_transactions_temp

7336: UNION ALL --Bug 4566485
7337:
7338: -- Pending/Suggestion receipts
7339: SELECT 1
7340: FROM mtl_material_transactions_temp
7341: WHERE LOCATOR_ID = P_LOCATOR_ID
7342: AND ORGANIZATION_ID = P_ORG_ID
7343: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7344: AND POSTING_FLAG = 'Y'

Line 7352: FROM mtl_material_transactions_temp

7348: UNION ALL --Bug 4566485
7349:
7350: -- Pending/Suggestion receipts on transfer side
7351: SELECT 1
7352: FROM mtl_material_transactions_temp
7353: WHERE TRANSFER_TO_LOCATION = P_LOCATOR_ID
7354: AND ORGANIZATION_ID = P_ORG_ID
7355: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7356: AND POSTING_FLAG = 'Y'

Line 7414: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

7410: MMTT.transaction_quantity,
7411: MMTT.transfer_lpn_id,
7412: MMTT.content_lpn_id,
7413: MMTT.lpn_id
7414: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
7415: MTL_ITEM_LOCATIONS MIL
7416: WHERE MMTT.transaction_status <> 2
7417: AND MMTT.organization_id = p_organization_id
7418: AND MMTT.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID

Line 7438: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

7434: transaction_quantity,
7435: transfer_lpn_id,
7436: content_lpn_id,
7437: lpn_id
7438: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
7439: WHERE transaction_status <> 2
7440: AND organization_id = p_organization_id
7441: and locator_id >0
7442: AND (transfer_lpn_id is not null or