DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1785: FROM MTL_TRANSACTION_LOT_NUMBERS MTLN,

1781: AND MTRL.TRANSACTION_ACTION_ID = 28
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