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.WMS_EPC_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 663: FROM mtl_material_transactions_temp mmtt,

659:
660: BEGIN
661: SELECT DISTINCT mmtt.inventory_item_id, SUM(mmtt.primary_quantity), mmtt.revision
662: INTO l_lpn_item_id,l_total_qty,l_rev
663: FROM mtl_material_transactions_temp mmtt,
664: wms_license_plate_numbers wlpn
665: WHERE Nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) = p_lpn_id
666: AND mmtt.organization_id = p_org_id
667: AND wlpn.lpn_id = Nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id)

Line 715: FROM mtl_material_transactions_temp mmtt

711: --Pick Release cartonization
712: BEGIN
713: SELECT mmtt.inventory_item_id, SUM(mmtt.primary_quantity), mmtt.revision
714: INTO l_lpn_item_id,l_total_qty,l_rev
715: FROM mtl_material_transactions_temp mmtt
716: WHERE mmtt.cartonization_id = p_lpn_id
717: AND mmtt.cartonization_id IS NOT NULL
718: AND mmtt.organization_id = p_org_id
719: GROUP BY mmtt.inventory_item_id,mmtt.transaction_uom, mmtt.revision;