VIEW: APPS.OKL_CURE_HEADER_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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