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
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 |