|
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 |
|
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
|
|
|