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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· 上周热点回顾(2.17-2.23)
· 如何使用 Uni-app 实现视频聊天(源码,支持安卓、iOS)
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章