eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_CS_PARTIES_TAB_UV

Product:	OKL - Lease and Finance Management
Description:	List of Parties
Implementation/DBA Data:	APPS.OKL_CS_PARTIES_TAB_UV

View Text

SELECT CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, INITCAP(ROLE_NAME) ROLE_NAME
, PTYPE PTYPE
, COMPANY COMPANY
, CUSTOMER_NUMBER CUSTOMER_NUMBER
FROM OKL_CS_VENDORS_UV
WHERE 1=1 UNION SELECT CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, INITCAP(ROLE_NAME) ROLE_NAME
, PTYPE PTYPE
, COMPANY COMPANY
, CUSTOMER_NUMBER CUSTOMER_NUMBER
FROM OKL_CS_LESSOR_UV UNION SELECT CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, INITCAP(ROLE_NAME) ROLE_NAME
, PARTY_TYPE PTYPE
, COMPANY COMPANY
, CUSTOMER_NUMBER CUSTOMER_NUMBER
FROM OKL_CS_GUARANTOR_AMOUNT_UV UNION SELECT CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, INITCAP(ROLE_NAME) ROLE_NAME
, PTYPE PTYPE
, COMPANY COMPANY
, CUSTOMER_NUMBER CUSTOMER_NUMBER
FROM OKL_CS_ALL_PARTIES_UV

Columns

Name
CONTRACT_ID
CONTRACT_NUMBER
ROLE_NAME
PTYPE
COMPANY
CUSTOMER_NUMBER