DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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