|
Re: link between average cost update row and po receipt row in mtl_material_transactions table ?? [message #629510 is a reply to message #629318] |
Wed, 10 December 2014 02:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/61d40af7c1226fe1be2b1777a49c7a64?s=64&d=mm&r=g) |
sambuduk
Messages: 2 Registered: January 2011 Location: Pune
|
Junior Member |
|
|
Hi,
Try with the below query.
SELECT mmt.*
FROM rcv_shipment_headers rsh
, rcv_transactions rt
, mtl_material_transactions mmt
WHERE
rsh.shipment_header_id = rt.shipment_header_id
AND rt.transaction_type = 'DELIVER'
AND to_char(rt.transaction_id) = mmt.transaction_reference
AND mmt.transaction_type_id = 80 -- Average Cost Update id
AND rsh.receipt_num = :P_RCPT_NUM ----'111010000089'
AND mmt.transaction_date BETWEEN '9-Oct-2011' AND '10-Oct-2011'
Regards
Sambasiva Reddy
|
|
|