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 a.badge_ty = 'PREFERRED_PROVIDER' or has_sb_product( a.constit_id, 'LOGO' ) = 'Y' then 'Y' else 'N' end logo_sw , has_cat_code( a.constit_id, 'AFFINPRTNR', '' ) affinity_partner , 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 (+)