XTR Positions - FX Exposures

Description
Categories: BI Publisher
Columns: Cover, Cover 100, Min Cover, Min Hedge, Max Hedge, Currency, Cf Amt Req ...
Application: Treasury
Source: Positions - FX Exposures Report (XML)
Short Name: XTRFXEXP_XML
DB package: XTR_XTRFXEXP_XMLP_PKG
		 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