XTR Positions - FX Exposures

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Positions - FX Exposures Report (XML)
Short Name: XTRFXEXP_XML
DB package: XTR_XTRFXEXP_XMLP_PKG
Run XTR Positions - FX Exposures and other Oracle EBS reports with Blitz Report™ on our demo environment
		 select
    decode(nvl(:CF_TEXP_IGBAL,0) ,0,NULL,round(((-1 * (nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0)) / :cf_texp_igbal) * 100)))  COVER,
    round(nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0) + nvl(:cf_texp_igbal,0),0)               COVER_100,
    least((-1 * (nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0) )- nvl(:cf_texp_igbal,0) * nvl(minimum_band,1 / 100))
 ,(-1 * (nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0) )- nvl(:cf_texp_igbal,0) * nvl(maximum_band,1))) MIN_COVER,
nvl(minimum_band,1/100)  min_hedge, 
nvl(maximum_band,1)  max_hedge,
currency, 
XTR_XTRFXEXP_XMLP_PKG.cf_amt_reqformula(decode ( nvl ( :CF_TEXP_IGBAL , 0 ) , 0 , NULL , round ( ( ( - 1 * ( nvl ( :fx_cover , 0 ) + nvl ( :cf_coh_cabal , 0 ) ) / :cf_texp_igbal ) * 100 ) ) ), nvl ( minimum_band , 1 / 100 ), :CF_TEXP_IGBAL, nvl ( maximum_band , 1 ),:TOTAL_HEDGE) CF_AMT_REQ
from XTR_master_currencies_V 
where currency = nvl(:currency_code2, currency) 
 and currency=:CCY
Parameter Name SQL text Validation
Company 
 
 LOV Oracle
Currency 
 
 LOV Oracle
Exposure Type 
 
 LOV Oracle
Factor 
 
 LOV Oracle
Include Intercompany 
 
 LOV Oracle
Download
Related Blitz Reports
XTR Intercompany - Statements XTR Positions - Maturities by Counterparty XTR Term Money - By Type and Product CE Transactions Available for Reconciliation CAC Calculate ICP PII Item Costs by Where Used CE Cleared Transactions XTR Admin - Average FX Rates XTR Positions - Treasury Consolidated Cashflows XTR Term Money - Retail Term Money Overdues
Blitz Report™

Blitz Report™ provides multiple benefits: