View: OKL_CS_VENDORS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_VENDORS_UV

View Text

SELECT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PR.ROLE ROLE_NAME
, '' AMT_GUARANTEED
, NVL(''
, '') PTYPE
, POV.VENDOR_NAME COMPANY
, POV.SEGMENT1 CUSTOMER_NUMBER
, POVS.EMAIL_ADDRESS EMAIL
, POVS.AREA_CODE || '-'|| POVS.PHONE PHONE
, POVS.ADDRESS_LINE1 ADDRESS1
, POVS.ADDRESS_LINE2 ADDRESS2
, POVS.ADDRESS_LINE3 ADDRESS3
, POVS.ADDRESS_LINE4 ADDRESS4
, POVS.CITY CITY
, POVS.COUNTY COUNTY
, POVS.PROVINCE PROVINCE
, POVS.STATE STATE
, POVS.ZIP POSTAL_CODE
, POVS.COUNTRY COUNTRY
FROM PO_VENDOR_SITES_ALL POVS
, PO_VENDORS POV
, OKC_K_PARTY_ROLES_V PR
, OKC_K_HEADERS_B CHR
WHERE POV.VENDOR_ID = POVS.VENDOR_ID
AND PR.OBJECT1_ID1=POV.VENDOR_ID
AND PR.JTOT_OBJECT1_CODE = 'OKX_VENDOR'
AND PR.DNZ_CHR_ID = CHR.ID
AND PR.CHR_ID = CHR.ID

Columns