Wednesday, August 15, 2018

How to find out PO currency rate differ from Receipt currency conversion rate

PO currency rate in po_headers_all  &  Receipt currency conversion rate in rcv_transactions



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