XTR Term Money - Term Average Rates

Description
Categories: BI Publisher
Columns: Deal Num, Subtype, Ccy, Product ...
Application: Treasury
Source: Term Money - Term Average Rates Report (XML)
Short Name: XTRTMAVG_XML
DB package: XTR_XTRTMAVG_XMLP_PKG
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