java.sql.SQLException: ORA-04063: view "AFCEAPPS.VW_SOURCEBOOK" has errors
SELECT a.constit_id, a.company_name, extract(year from a.join_dt) as join_dt , ''||a.addr1||''||decode(a.addr2,NULL,'','
'||a.addr2)||decode(a.addr3,NULL,'','
'||a.addr3) ||'
'||decode(a.country_cd, 'USA', trim(a.city)||', '||a.state_name||' '||a.postal_cd , 'CAN', trim(a.city)||', '||a.state_name||' '||a.postal_cd||'
'||a.country_name , trim(a.addr_foreign)||'
'||a.country_name) addr , nvl(a.phone,' ') phone, nvl(a.fax,' ') fax, a.email, a.website_url website , nvl(a.focus,' ') focus, nvl(a.products,' ') products, nvl(a.clients,' ') clients, nvl(a.sales,' ') sales , nvl(a.contract_vehicles,' ') contract_vehicles, nvl(a.certifications,' ') certifications , a.logo, a.pic, nvl(a.caption,' ') caption , a.sustainer sustainer_sw, a.strategic_partner_sw , case when a.sustainer = 'Y' or has_sb_product( a.constit_id, 'LOGO' ) = 'Y' then 'Y' else 'N' end logo_sw , a.sustainer power_search_sw , a.contact_name1, a.contact_title1 , a.contact_name2, a.contact_title2 , a.contact_name3, a.contact_title3 , decode(n.naics_cd, null, '', n.naics_cd||' - '||n.description) naics , b.img_url badge_img_url, b.description badge_desc , a.vet_program_desc, a.vet_program_url , a.badge_ty from vw_sourcebook a, vw_naics_code n, sourcebook_badge_type b where a.naics_cd = n.naics_cd (+) and a.constit_id = ? and a.badge_ty = b.badge_ty (+)

Companies provide the information for publication in AFCEA directories. To be included, organizations must offer products and/or services that are relevant to a directory's focus and to the AFCEA community. AFCEA reserves the right to edit or remove material that does not meet these criteria.

To update existing company directory information click here

Listing of All Current Corporate Members 


Not a member yet? Join Now

Click here for a list of all AFCEA directories


Click here for a list of all Sustaining Members.