XTR Term Money - New/Settled Retail Term Money

Description
Categories: BI Publisher
Columns: Deal No, Deal Type, Product, Ccy, Cp Code, Cp Name, Start Date, Maturity Date, Face Value, Settle Date ...
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 Name SQL text Validation
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