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_TRANSACTION_LOT_NUMBERS

Line 2750: mtl_transaction_lot_numbers mtln

2746: -----fetching the received quantity for that lot if line set id is not null
2747: CURSOR Cr_lot_recv_qty_lineset IS
2748: SELECT SUM(mtln.primary_quantity)
2749: FROM mtl_material_transactions mmt ,
2750: mtl_transaction_lot_numbers mtln
2751: WHERE mmt.trx_source_line_id IN
2752: (SELECT line_id
2753: FROM oe_order_lines_all
2754: WHERE line_set_id = l_line_set_id)

Line 2768: mtl_transaction_lot_numbers mtln

2764: ------fetching the received quantity for that lot if line set id is null
2765: CURSOR Cr_lot_recv_qty IS
2766: SELECT SUM(mtln.primary_quantity)
2767: FROM mtl_material_transactions mmt ,
2768: mtl_transaction_lot_numbers mtln
2769: WHERE mmt.trx_source_line_id = p_oe_order_line_id
2770: AND mmt.transaction_source_type_id = 12
2771: and mmt.transaction_action_id in (1,27)
2772: and mmt.transaction_type_id in (15,36,37)