Query to Fetch Last Receiving Price for an Item Code in Oracle Apps
Hi Team,
I am trying to retrieve the last receiving price for a specific Item Code: 9LC05460000380 in Oracle Apps. The query should return the most recent purchase price based on receiving transactions. I am primarily looking to extract details from relevant tables such as:
- RCV_TRANSACTIONS (Receiving transactions)
- PO_HEADERS_ALL (Purchase order headers)
- PO_LINES_ALL (Purchase order lines)
- RCV_SHIPMENT_HEADERS (Shipment details)
- mtl_system_items_b
The goal is to get the latest price based on the most recent receiving transaction date. Could anyone provide guidance on the best way to write this query?
Thanks in advance!