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
Description: Admin - Loan Securities Report
Application: Treasury
Source: Admin - Loan Securities Report (XML)
Short Name: XTRMILNS_XML
DB package: XTR_XTRMILNS_XMLP_PKG
Run
XTR Admin - Loan Securities and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |