XTR Admin - Loan Securities

Description
Categories: BI Publisher, Financials
Application: Treasury
Source: Admin - Loan Securities Report (XML)
Short Name: XTRMILNS_XML
DB package: XTR_XTRMILNS_XMLP_PKG
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
Parameter Name SQL text Validation
Sort By
 
LOV Oracle
Factor
 
LOV Oracle
Account Manager
 
LOV Oracle
Priority Sum
 
Number
Valuation Amount
 
Number
Valuation Before Date
 
Date
Valuer
 
LOV Oracle
Counterparty
 
LOV Oracle
Company
 
LOV Oracle