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

Line 2739: FROM mtl_material_transactions_temp mmtt

2735: IS
2736: SELECT mmtt.transaction_temp_id , mmtt.subinventory_code ,
2737: mmtt.locator_id , mmtt.inventory_item_id ,
2738: mmtt.lpn_id , mmtt.item_lot_control_code
2739: FROM mtl_material_transactions_temp mmtt
2740: WHERE mmtt.transfer_lpn_id = p_lpn_id
2741: AND NVL(mmtt.lpn_id,-99) <> p_lpn_id
2742: AND NVL(mmtt.content_lpn_id,-99) <> p_lpn_id;
2743: CURSOR mtlt_cur(l_transaction_temp_id NUMBER)

Line 3251: FROM mtl_material_transactions_temp mmtt

3247: IS SELECT mmtt.transaction_temp_id , mmtt.subinventory_code,
3248: mmtt.transaction_type_id,
3249: mmtt.locator_id , mmtt.inventory_item_id ,
3250: nvl(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.item_lot_control_code
3251: FROM mtl_material_transactions_temp mmtt
3252: where mmtt.transfer_lpn_id = p_fromlpn_id
3253: AND mmtt.transaction_source_type_id = 2
3254: AND mmtt.transaction_type_id = 52
3255: AND Nvl(l_cur_inventory_item_id,inventory_item_id)=inventory_item_id;