Teamcenter 查询关系的最新版本

select pi.pitem_id,pws.pobject_desc,pir.pitem_revision_id,pit.ptype_name,

pi1.pitem_id,pir1.pitem_revision_id,pws1.pobject_desc

from infodba.pitemrevision pir

join infodba.pitem pi on pir.ritems_tagu =pi.puid --AND pi.PITEM_ID ='12200560006'

join infodba.pworkspaceobject pws on pir.puid=pws.puid and pws.pobject_type like 'L8%PartRevision' AND pws.pobject_desc LIKE '半成品电池,BZ%'

 

join infodba.pimanrelation prel1 on prel1.rprimary_objectu =pir.puid

 

join infodba.pitemrevision pir1 on pir1.ritems_tagu =prel1.rsecondary_objectu

 

join infodba.pitem pi1 on pir1.ritems_tagu =pi1.puid --and pi1.pitem_id='12200500037'

AND pir1.PITEM_REVISION_ID =

(

 

SELECT PITEM_REVISION_ID FROM

(select rownum,pir.PITEM_REVISION_ID from infodba.pitemrevision pir

join infodba.pitem pix on pir.ritems_tagu =pix.puid and pix.pitem_id=pi1.pitem_id ORDER BY pir.PITEM_REVISION_ID DESC ) WHERE rownum=1

 

)

join infodba.pworkspaceobject pws1 on pir1.puid=pws1.puid and pws1.pobject_type like 'L8%PartRevision'

join infodba.pimantype pit on prel1.rrelation_typeu =pit.puid

;

 

 

 

SELECT PITEM_REVISION_ID FROM

(select rownum,pir.PITEM_REVISION_ID from infodba.pitemrevision pir

join infodba.pitem pi on pir.ritems_tagu =pi.puid and pi.pitem_id='12200500037' ORDER BY pir.PITEM_REVISION_ID DESC ) WHERE rownum=1

 

 

posted @   张永全-PLM顾问  阅读(127)  评论(1编辑  收藏  举报
相关博文:
阅读排行:
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· 上周热点回顾(2.17-2.23)
· 如何使用 Uni-app 实现视频聊天(源码,支持安卓、iOS)
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
点击右上角即可分享
微信分享提示