SELECT CONTRACT_ID CONTRACT_ID , CONTRACT_NUMBER CONTRACT_NUMBER , INITCAP(ROLE_NAME) ROLE_NAME , NVL(AMT_GUARANTEED , 0) AMT_GUARANTEED , PTYPE PTYPE , COMPANY COMPANY , CUSTOMER_NUMBER CUSTOMER_NUMBER , EMAIL EMAIL , PHONE PHONE , ADDRESS1 ADDRESS1 , ADDRESS2 ADDRESS2 , ADDRESS3 ADDRESS3 , ADDRESS4 ADDRESS4 , CITY CITY , COUNTY COUNTY , PROVINCE PROVINCE , STATE STATE , POSTAL_CODE POSTAL_CODE , COUNTRY COUNTRY FROM OKL_CS_VENDORS_UV UNION SELECT CONTRACT_ID CONTRACT_ID , CONTRACT_NUMBER CONTRACT_NUMBER , INITCAP(ROLE_NAME) ROLE_NAME , NVL(AMT_GUARANTEED , 0) AMT_GUARANTEED , PTYPE PTYPE , COMPANY COMPANY , CUSTOMER_NUMBER CUSTOMER_NUMBER , EMAIL EMAIL , PHONE PHONE , ADDRESS1 ADDRESS1 , ADDRESS2 ADDRESS2 , ADDRESS3 ADDRESS3 , ADDRESS4 ADDRESS4 , CITY CITY , COUNTY COUNTY , PROVINCE PROVINCE , STATE STATE , POSTAL_CODE POSTAL_CODE , COUNTRY COUNTRY FROM OKL_CS_LESSOR_UV UNION SELECT CONTRACT_ID CONTRACT_ID , CONTRACT_NUMBER CONTRACT_NUMBER , INITCAP(ROLE_NAME) ROLE_NAME , NVL(AMOUNT_GUARANTEED , 0) AMT_GUARANTEED , PARTY_TYPE PTYPE , COMPANY COMPANY , CUSTOMER_NUMBER CUSTOMER_NUMBER , EMAIL EMAIL , RAW_PHONE_NUMBER PHONE , ADDRESS1 ADDRESS1 , ADDRESS2 ADDRESS2 , ADDRESS3 ADDRESS3 , ADDRESS4 ADDRESS4 , CITY CITY , COUNTY COUNTY , PROVINCE PROVINCE , STATE STATE , POSTAL_CODE POSTAL_CODE , COUNTRY COUNTRY FROM OKL_CS_GUARANTOR_AMOUNT_UV UNION SELECT CONTRACT_ID CONTRACT_ID , CONTRACT_NUMBER CONTRACT_NUMBER , INITCAP(ROLE_NAME) ROLE_NAME , NVL(AMT_GUARANTEED , 0) AMT_GUARANTEED , PTYPE PTYPE , COMPANY COMPANY , CUSTOMER_NUMBER CUSTOMER_NUMBER , EMAIL EMAIL , PHONE PHONE , ADDRESS1 ADDRESS1 , ADDRESS2 ADDRESS2 , ADDRESS3 ADDRESS3 , ADDRESS4 ADDRESS4 , CITY CITY , COUNTY COUNTY , PROVINCE PROVINCE , STATE STATE , POSTAL_CODE POSTAL_CODE , COUNTRY COUNTRY FROM OKL_CS_ALL_PARTIES_UV