View: OKL_CURE_VENDOR_SUMRY_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CURE_VENDOR_SUMRY_UV

View Text

SELECT CHR.ID
, CHR.CONTRACT_NUMBER
, CHR.SHORT_DESCRIPTION
, PVN.VENDOR_NAME
, PVN.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID
, PVS.ADDRESS_LINE1 || PVS.ADDRESS_LINE2 || PVS.ADDRESS_LINE3 || '
, ' || PVS.CITY ||'
, ' || PVS.STATE || ' '||PVS.ZIP
, PVC.VENDOR_CONTACT_ID
, PVC.LAST_NAME||'
, '||PVC.FIRST_NAME
, '('||PVC.AREA_CODE || ')'|| PVC.PHONE
FROM OKC_K_PARTY_ROLES_V PTY
, OKC_RULES_V RUL
, OKC_K_HEADERS_V CHR
, PO_VENDORS PVN
, PO_VENDOR_CONTACTS PVC
, PO_VENDOR_SITES_ALL PVS
WHERE CHR.SCS_CODE = 'PROGRAM'
AND RUL.DNZ_CHR_ID = CHR.ID
AND RUL. RULE_INFORMATION_CATEGORY='COVNAG'
AND CHR.ID = PTY.CHR_ID
AND RLE_CODE = 'OKL_VENDOR'
AND PTY.OBJECT1_ID1 = PVN.VENDOR_ID
AND PVN.VENDOR_ID = PVS.VENDOR_ID
AND PVS.VENDOR_SITE_ID = RUL.RULE_INFORMATION1
AND PVS.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID
AND PVC.VENDOR_CONTACT_ID = RUL.RULE_INFORMATION2

Columns