Teamcenter:业务对象查询

Teamcenter 12 业务对象查询 

 

-- N: BMIDE>>业务对象 
with  imanType(puid, ptype_name, rparent_typeu,level_id) as
( select pt.puid, pt.ptype_name,pt.rparent_typeu , 0 as level_id FROM pImanType  PT 
  where   upper(ptype_name) in ( upper('BusinessObject') )
  union all
   select pt.puid, pt.ptype_name,pt.rparent_typeu , it.level_id +1 as level_id FROM pImanType  PT , imantype it
  where  1=1 -- and upper(pt.ptype_name) in ( upper('POM_object') ) 
   and pt.rparent_typeu =  it.puid 
)   
select it.*,
       PT.ptype_name  as rparent_type_name ,
       --pt.pdescription as rparent_Pdescription  ,
       pt2.pcategory, --
       pt2.pisAbstract, -- 抽象
       pt2.vla_250_8 ,
       VTN.PVAL_0 AS "名称(英文)",
       DECODE(VTN2.PVAL_0,NULL, VTN.PVAL_0, VTN2.PVAL_0) AS "名称"
  from imantype it , pImanType pt,
       pImanType pt2,
       INFODBA.VL10N_TYPE_NAME  VTN ,-- 英文
       INFODBA.VL10N_TYPE_NAME  VTN2  -- 中文
 where 1=1 
  and upper(it.ptype_name) like upper( 'ItemRevision%')
  and it.rparent_typeu = pt.puid 
  and it.puid = pt2.puid 
  AND PT2.PUID = VTN.PUID 
  AND VTN.LOCALE= 'en_US'
  AND pt2.puid = vtn2.puid(+) and vtn2.locale(+) = 'zh_CN'  
 order by it.level_id  , pt.ptype_name  , it.ptype_name
 ;

　　

从Business Module IDE 设置