-- Hi Josef,
 -- This is the query to detect the imprecise bvrs having precise occurrences.
 -- To find the incorrect precise bvrs the left join should be on pitemrevision and the p2.pis_precise = 1
 -- Regards, Jos 22.08.2016
select
distinct
t2.puid ,
t4.pobject_name ,
t5.plast_mod_date
from
pworkspaceobject t4 ,
ppsbomviewrevision t2 ,
ppom_application_object t5 ,
ppom_object t6 ,
ppsoccurrence t1
 left join pitem t3 on t3.puid = t1.rchild_itemu
where
t4.puid = t2.puid and
t5.puid = t2.puid and
t4.puid = t6.puid and
t4.pactive_seq = 1 and
t6.rowning_siteu is null and
t1.rparent_bvru = t2.puid and
t2.pis_precise = 0 and
t3.puid is null;


