- select c.doc_type, c.doc_init_rel_date, vp.vul_status,
- p.prod_name, vul_cve
- from pa_cvrf_doc c, pa_cvrf_vul v, pa_cvrf_vul_product vp,
- pa_cvrf_product p
- where c.cvrf_id=v.cvrf_id
- and v.vul_id=vp.vul_id
- and vp.prod_id=p.prod_id
- and prod_name like '%Java%'
- and c.cvrf_id=3357
The output can be formatted for reporting as follow: