VIEW: APPS.OKL_CURE_VENDOR_SUMRY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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