XTR Admin - Loan Securities

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Admin - Loan Securities Report
Application: Treasury
Source: Admin - Loan Securities Report (XML)
Short Name: XTRMILNS_XML
DB package: XTR_XTRMILNS_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Company
 
LOV Oracle
Counterparty
 
LOV Oracle
Valuer
 
LOV Oracle
Valuation Before Date
 
Date
Valuation Amount
 
Number
Priority Sum
 
Number
Account Manager
 
LOV Oracle
Factor
 
LOV Oracle