Oracle Technology
select * from apps.gl_daily_rates
where trunc(conversion_date) ='22-MAR-2023'
and from_currency='EUR' and TO_CURRENCY ='USD'
and conversion_type ='1002'
order by 3 desc;
1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...
No comments:
Post a Comment