VIEW: APPS.OKL_CS_ALL_PARTIES_W_AMOUNT_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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