DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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