APPS.GMD_COA_DATA_OM_NEW dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1775: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

1771: -- Bug# 5629675 Added distinct in the first select and added union.
1772: CURSOR Get_Lot_Tran(p_order_line_id oe_order_lines_all.line_id%TYPE) IS
1773: SELECT distinct MTLT.LOT_NUMBER, Abs(mtlt.primary_quantity) qty1 -- 12659784 added primary_quantity
1774: FROM MTL_TRANSACTION_LOTS_TEMP MTLT,
1775: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
1776: MTL_TXN_REQUEST_LINES_V MTRL
1777: WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID
1778: AND MMTT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID
1779: AND MTRL.TXN_SOURCE_LINE_ID = p_order_line_id

Line 1786: MTL_MATERIAL_TRANSACTIONS MMT

1782: AND MTRL.TRANSACTION_SOURCE_TYPE_ID = 2
1783: UNION
1784: SELECT distinct MTLN.LOT_NUMBER , Abs(mtln.primary_quantity) qty1 -- 12659784 added primary_quantity
1785: FROM MTL_TRANSACTION_LOT_NUMBERS MTLN,
1786: MTL_MATERIAL_TRANSACTIONS MMT
1787: WHERE MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID
1788: AND MMT.TRX_SOURCE_LINE_ID = p_order_line_id
1789: AND MMT.TRANSACTION_TYPE_ID = 52
1790: AND MMT.TRANSACTION_ACTION_ID = 28