Teamcenter LOV的视图

create or replace view v_lov_filter as
select lov.plov_name parentlovname, v3.puid parentlovuid, v3.pseq,v3.pval_0 plovvalue,f.pvalu_0 childlovuid,clov.plov_name childlovname
from plov_values_3 v3 ,PVALUE_FILTERS f,PVALUE_FILTERS_INDEXES idx, Plistofvalues lov, Plistofvalues clov
where f.puid = v3.puid and idx.puid = v3.puid and f.pseq=idx.pseq and idx.pval_0=v3.pseq and lov.puid = v3.puid and clov.puid = f.pvalu_0

order by parentlovname , v3.pseq;