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_ROI_INTEGRATION_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2642: FROM mtl_material_transactions mmt ,

2638:
2639: -----fetching the received quantity for that lot if line set id is not null
2640: CURSOR Cr_lot_recv_qty_lineset IS
2641: SELECT SUM(mtln.primary_quantity)
2642: FROM mtl_material_transactions mmt ,
2643: mtl_transaction_lot_numbers mtln
2644: WHERE mmt.trx_source_line_id IN
2645: (SELECT line_id
2646: FROM oe_order_lines_all

Line 2659: FROM mtl_material_transactions mmt ,

2655:
2656: ------fetching the received quantity for that lot if line set id is null
2657: CURSOR Cr_lot_recv_qty IS
2658: SELECT SUM(mtln.primary_quantity)
2659: FROM mtl_material_transactions mmt ,
2660: mtl_transaction_lot_numbers mtln
2661: WHERE mmt.trx_source_line_id = p_oe_order_line_id
2662: AND mmt.transaction_source_type_id = 12
2663: and mmt.transaction_action_id in (1,27)