Home » Applications » Oracle Fusion Apps & E-Business Suite » link between average cost update row and po receipt row in mtl_material_transactions table ?? (Oracle EBS 12.1.3)
link between average cost update row and po receipt row in mtl_material_transactions table ?? [message #629318] Sun, 07 December 2014 02:50 Go to next message
Splinter2010
Messages: 20
Registered: July 2006
Location: EGYPT
Junior Member

Dear All ,


I'm facing problem in creating cost report , i need to get the value change from average cost update row to add it into the actual cost in po receipt row of the same shipment in mtl_material_transactions table.
if anyone help ....


Thanks
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
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
Previous Topic: Payables Check Printer Options
Next Topic: A Value set return "No entries found for LIst of Values", but its query have to return data
Goto Forum:
  


Current Time: Mon Jun 21 05:24:01 CDT 2021