XTR Term Money - New/Settled Retail Term Money

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