XTR Admin - Loan Securities

select a.valuation_date       VALUE_DATE,
       a.security_description SEC_DESCRIP,
       a.security_ref         SEC_REF,
       a.company_code    COMP_CODE,
       a.issued_by             ISSUED_BY,							
       a.valuer               VALUER,
       a.security_value/:amt_unit2       SEC_VALUE,
       a.priority_sum/:amt_unit2         PRIORITY_SUM,
       decode(nvl(upper(:ORDER_BY_PTY_MGR2),'C')
         ,'C',b.short_name,b.account_manager
         )       PARTY_NAME,
       b.short_name            CPARTY,
       b.account_manager    ACCT_MANAGER
from XTR_LOAN_SECURITIES_V a,
     XTR_PARTIES_V b,
     XTR_PARTIES_V c
where a.cparty_code like nvl(upper(:PARTY_CODE2), a.cparty_code)
and a.company_code like nvl(upper(:P_COMPANY),'%')
and a.cparty_code = b.party_code
and nvl(b.account_manager,'%') like nvl(upper(:ACCOUNT_MANAGER2), b.account_manager)
and a.valuer = c.party_code (+)
and ((c.party_code like nvl(upper(:VALUER2),'%')) or (:VALUER2 is null))
and nvl(a.valuation_date ,to_date('01/01/1980','MM/DD/YYYY')) <= nvl(:BEFORE_VALUE_DATE2, nvl(a.valuation_date ,to_date('01/01/1980','MM/DD/YYYY')))
and nvl(a.security_value,0) >= nvl(:OVER_VALUATION2,0)
and nvl(a.priority_sum,0) >= nvl(:OVER_PRIORITY_SUM2,0)
order by 8,7