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.

VIEW: APPS.OKL_CS_PARTIES_TAB_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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