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.GMD_COA_DATA_OM_NEW dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1599: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

1595: -- Bug# 5629675 Added distinct in the first select and added union.
1596: CURSOR get_lot_tran(p_order_line_id oe_order_lines_all.line_id%TYPE) IS
1597: SELECT distinct MTLT.LOT_NUMBER
1598: FROM MTL_TRANSACTION_LOTS_TEMP MTLT,
1599: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
1600: MTL_TXN_REQUEST_LINES_V MTRL
1601: WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID
1602: AND MMTT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID
1603: AND MTRL.TXN_SOURCE_LINE_ID = p_order_line_id

Line 1610: MTL_MATERIAL_TRANSACTIONS MMT

1606: AND MTRL.TRANSACTION_SOURCE_TYPE_ID = 2
1607: UNION
1608: SELECT distinct MTLN.LOT_NUMBER
1609: FROM MTL_TRANSACTION_LOT_NUMBERS MTLN,
1610: MTL_MATERIAL_TRANSACTIONS MMT
1611: WHERE MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID
1612: AND MMT.TRX_SOURCE_LINE_ID = p_order_line_id
1613: AND MMT.TRANSACTION_TYPE_ID = 52
1614: AND MMT.TRANSACTION_ACTION_ID = 28