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 2671: FROM mtl_material_transactions_temp mmtt

2667: ,mil2.volume_uom_code
2668: ,mil2.location_maximum_units
2669: ,mil2.max_weight
2670: ,mil2.max_cubic_area
2671: FROM mtl_material_transactions_temp mmtt
2672: ,mtl_item_locations mil
2673: ,mtl_item_locations mil2
2674: WHERE mmtt.locator_id = mil.inventory_location_id
2675: AND mil.organization_id = mmtt.organization_id

Line 2710: FROM mtl_material_transactions_temp mmtt

2706: ,mil2.volume_uom_code
2707: ,mil2.location_maximum_units
2708: ,mil2.max_weight
2709: ,mil2.max_cubic_area
2710: FROM mtl_material_transactions_temp mmtt
2711: ,mtl_item_locations mil
2712: ,mtl_item_locations mil2
2713: WHERE mmtt.transfer_to_location = mil.inventory_location_id
2714: AND mil.organization_id = mmtt.organization_id

Line 7860: FROM mtl_material_transactions_temp

7856: UNION ALL --Bug 4566485
7857:
7858: -- Pending/Suggestion receipts
7859: SELECT 1
7860: FROM mtl_material_transactions_temp
7861: WHERE LOCATOR_ID = P_LOCATOR_ID
7862: AND ORGANIZATION_ID = P_ORG_ID
7863: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7864: AND POSTING_FLAG = 'Y'

Line 7872: FROM mtl_material_transactions_temp

7868: UNION ALL --Bug 4566485
7869:
7870: -- Pending/Suggestion receipts on transfer side
7871: SELECT 1
7872: FROM mtl_material_transactions_temp
7873: WHERE TRANSFER_TO_LOCATION = P_LOCATOR_ID
7874: AND ORGANIZATION_ID = P_ORG_ID
7875: AND INVENTORY_ITEM_ID <> P_INVENTORY_ITEM_ID
7876: AND POSTING_FLAG = 'Y'

Line 7934: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

7930: MMTT.transaction_quantity,
7931: MMTT.transfer_lpn_id,
7932: MMTT.content_lpn_id,
7933: MMTT.lpn_id
7934: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
7935: MTL_ITEM_LOCATIONS MIL
7936: WHERE MMTT.transaction_status <> 2
7937: AND MMTT.organization_id = p_organization_id
7938: AND MMTT.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID

Line 7958: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

7954: transaction_quantity,
7955: transfer_lpn_id,
7956: content_lpn_id,
7957: lpn_id
7958: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
7959: WHERE transaction_status <> 2
7960: AND organization_id = p_organization_id
7961: and locator_id >0
7962: AND (transfer_lpn_id is not null or