XTR Term Money - New/Settled Retail Term Money

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Term Money - New/Settled Retail Term Money Report (XML)
Short Name: XTRTMNEW_XML
DB package: XTR_XTRTMNEW_XMLP_PKG
select
 d.deal_no           DEAL_NO,
 decode(d.deal_subtype
   ,'FUND','Deposit'
   ,'Advance')       DEAL_TYPE,
 d.product_type      PRODUCT,
 d.currency          CCY,
 d.cparty_code       CP_CODE,
 p.short_name        CP_NAME,
 d.start_date        START_DATE,
 d.maturity_date     MATURITY_DATE,
 d.face_value_amount FACE_VALUE,
 d.settle_date       SETTLE_DATE,
 d.payment_schedule_code PYMT_SCHEDULE,
 d.interest_rate     INT_RATE,
 d.next_coupon_date  FIXED_UNTIL,
 d.payment_freq      PYMT_FREQ,
 d.pi_amount_due     PI_AMT_DUE,
 decode(nvl(upper(substr(:ORDER_BY_COLUMN2,1,1)),'C')
   ,'C',d.cparty_code
   ,'D',d.start_date
   ,' ')              ORD_COLUMN
from XTR_DEALS_V d,
     XTR_PARTIES_V p
where d.deal_type = 'RTMM'
and d.cparty_code = p.party_code
&LP_start_date_q1
AND :P_NEW_SETTLED IN ('NEW','ALL')
order by 16,7
Parameter NameSQL textValidation
New Deal Date From
 
Date
New Deal Date To
 
Date
Deals Repaid Date From
 
Date
Deals Repaid Date To
 
Date
New/Settled
 
LOV Oracle
Sort By
 
LOV Oracle
Download
Related Blitz Reports
XTR Term Money - Retail Term Money Statements XTR Positions - Discounted Securities Register XTR Term Money - By Type and Product XTR Admin - Cancelled Transactions Summary XTR Term Money - Retail Term Money Overdues XTR Positions - Outstanding Hedge Instruments XTR Term Money - Retail Term Money Aging XTR Positions - Outstanding Receivables / Payables XTR Positions - Interest Rate Hedges
Blitz Report™