XTR Term Money - Term Average Rates

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Term Money - Term Average Rates Report (XML)
Short Name: XTRTMAVG_XML
DB package: XTR_XTRTMAVG_XMLP_PKG
Run XTR Term Money - Term Average Rates and other Oracle EBS reports with Blitz Report™ on our demo environment
select d.deal_no      DEAL_NUM,
       decode(d.deal_subtype
         ,'FUND','DEPOSIT','ADVANCE')  SUBTYPE,
       d.currency     CCY,
       d.product_type PRODUCT
	/*XTR_XTRTMAVG_XMLP_PKG.wavg_rate1formula() WAVG_RATE1, 
	XTR_XTRTMAVG_XMLP_PKG.avg_amount1formula() AVG_AMOUNT1,
	XTR_XTRTMAVG_XMLP_PKG.WAVG_RATE_p WAVG_RATE,
	XTR_XTRTMAVG_XMLP_PKG.AVG_AMOUNT_p AVG_AMOUNT*/
from XTR_DEALS_V d
where d.deal_type  = 'RTMM'
and ((d.deal_subtype = 'FUND' and nvl(upper(:DEAL_SUBTYPE2),deal_subtype)
       IN('DEPOSIT')) or
     (d.deal_subtype = 'INVEST' and nvl(upper(:DEAL_SUBTYPE2),deal_subtype)
       IN('ADVANCE')))
and d.product_type like nvl(upper(:PRODUCT_TYPE2),product_type)
and d.start_date <= :AS_AT_DATE2
and d.maturity_date > :AS_AT_DATE2
ORDER BY 2 ASC,3 ASC,4 ASC
Parameter Name SQL text Validation
Product Type 
 
 LOV Oracle
Deposit/Advance 
 
 LOV Oracle
As of Date 
 
 Date
Show Contracts 
 
 LOV Oracle
Download
Related Blitz Reports
XTR Term Money - Retail Term Money Statements XTR Term Money - New/Settled Retail Term Money XTR Positions - Outstanding Hedge Instruments XTR Positions - Discounted Securities Register XTR Term Money - Retail Term Money Aging XTR Positions - Outstanding Receivables / Payables XTR Term Money - By Type and Product XTR Admin - Cancelled Transactions Summary XTR Positions - Interest Rate Hedges XTR Term Money - Retail Term Money Overdues
Blitz Report™

Blitz Report™ provides multiple benefits: