select rt.currency_conversion_rate receipt_rate,pda.rate po_distribution_rate,pha.segment1, rsh.receipt_num
from rcv_transactions rt,
po_distributions_all pda,
po_headers_all pha,
rcv_shipment_headers rsh
where rt.po_distribution_id = pda.po_distribution_id
and rt.currency_conversion_rate <> pda.rate
and pda.po_header_id = pha.po_header_id
and rsh.shipment_header_id = rt.shipment_header_id
--and rsh.ship_to_org_id = 40
order by pha.segment1 desc
No comments:
Post a Comment