View: OKL_CURE_HEADER_UV

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

View Text

SELECT VND.VENDOR_ID VENDOR_ID
, VND.VENDOR_NAME VENDOR_NAME
, VCV.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, CONCAT(VCV.LAST_NAME||'
, '
, VCV.FIRST_NAME) VENDOR_CONTACT_NAME
, DECODE(VCV.AREA_CODE
, NULL
, VCV.PHONE
, CONCAT('(' || VCV.AREA_CODE || ')'
, VCV.PHONE)) VENDOR_CONTACT_PHONE
, (VSV.ADDRESS_LINE1|| DECODE(VSV.ADDRESS_LINE2
, NULL
, VSV.ADDRESS_LINE2
, '
, '||VSV.ADDRESS_LINE2) ||DECODE(VSV.ADDRESS_LINE3
, NULL
, VSV.ADDRESS_LINE3
, '
, '||VSV.ADDRESS_LINE3) || DECODE(VSV.CITY
, NULL
, VSV.CITY
, '
, '||VSV.CITY) || DECODE(VSV.STATE
, NULL
, VSV.STATE
, '
, '||VSV.STATE) || DECODE(VSV.ZIP
, NULL
, VSV.ZIP
, '
, '||VSV.ZIP) ) VENDOR_ADDRESS
, VSV.VENDOR_SITE_ID VENDOR_SITE_ID
, VSV.ORG_ID
FROM PO_VENDORS VND
, PO_VENDOR_SITES_ALL VSV
, PO_VENDOR_CONTACTS VCV
WHERE VND.VENDOR_ID = VSV.VENDOR_ID
AND VSV.VENDOR_SITE_ID = VCV.VENDOR_SITE_ID

Columns