[Home] [Help]
View: OKL_CS_NON_VENDORS_UV
View Text
SELECT APV.CONTRACT_ID CONTRACT_ID
, APV.CONTRACT_NUMBER CONTRACT_NUMBER
, APV.ROLE_NAME ROLE_NAME
, GAV.AMOUNT_GUARANTEED AMT_GUARANTEED
, APV.PTYPE PTYPE
, APV.COMPANY COMPANY
, APV.CUSTOMER_NUMBER CUSTOMER_NUMBER
, APV.EMAIL EMAIL
, APV.PHONE PHONE
, APV.ADDRESS1 ADDRESS1
, APV.ADDRESS2 ADDRESS2
, APV.ADDRESS3 ADDRESS3
, APV.ADDRESS4 ADDRESS4
, APV.CITY CITY
, APV.COUNTY COUNTY
, APV.PROVINCE PROVINCE
, APV.STATE STATE
, APV.POSTAL_CODE POSTAL_CODE
, APV.COUNTRY COUNTRY
FROM OKL_CS_ALL_PARTIES_UV APV
, OKL_CS_GUARANTOR_AMOUNT_UV GAV
WHERE APV.CUSTOMER_NUMBER=GAV.CUSTOMER_NUMBER(+)
Columns
Name |
CONTRACT_ID |
CONTRACT_NUMBER |
ROLE_NAME |
AMT_GUARANTEED |
PTYPE |
COMPANY |
CUSTOMER_NUMBER |
EMAIL |
PHONE |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
COUNTY |
PROVINCE |
STATE |
POSTAL_CODE |
COUNTRY |