XTR Term Money - Term Average Rates
Description
- Categories
- BI Publisher
- Application
- Treasury
- Source
- Term Money - Term Average Rates Report (XML)
- Short Name
- XTRTMAVG_XML
- DB package
- XTR_XTRTMAVG_XMLP_PKG
SQL 20 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Product Type | LOV Oracle | |
| Deposit/Advance | LOV Oracle | |
| As of Date | Date | |
| Show Contracts | LOV Oracle |