Thursday, March 04, 2010

To Get Inventory transaction Id from Order Line ID

SELECT transaction_id

FROM mtl_material_transactions

WHERE trx_source_line_id = &order_line_id

AND transaction_type_id = 33

No comments:

Post a Comment