Teamcenter: 图纸版本与BOM视图版本关联查询

Teamcenter 12 : 图纸版本与BOM视图版本关联查询

SELECT PK.PUID AS POM_KEY_PUID,
PK.KEY_VALUE AS 图号,
IR.PUID AS PITEMREVISION_PUID,
IR.PITEM_REVISION_ID AS 当前版本,
BVR.PUID AS PPSBOMVIEWREVISION_PUID,
DECODE(RS.PNAME, 'CUX_MassProduction', '产量',
'CUX_TrialProduce','试产',
RS.PNAME) AS 状态,
(RS.PDATE_RELEASED+ 8/24) AS 发布日期,
BVR.*
FROM POM_KEY PK,  -- 项目对象模板 关键字
PITEM PI , -- 图纸
PITEMREVISION IR,  -- 图纸版本
INFODBA.PSTRUCTURE_REVISIONS STRU , -- 图纸版本与BOM版本关联表
INFODBA.PPSBOMVIEW BV,  -- BOM视图
INFODBA.PPSBOMVIEWREVISION BVR,  -- BOM视图版本
INFODBA.PRELEASE_STATUS_LIST RSL , -- BOM状态
PRELEASESTATUS RS -- 状态
WHERE PK.PUID = PI.PUID
AND PK.PUID = BV.RPARENT_ITEMU
AND PK.PUID = IR.RITEMS_TAGU
AND BV.PUID = BVR.RBOM_VIEWU
AND BVR.PUID = RSL.PUID
AND RSL.PVALU_0 = RS.PUID
AND BVR.PUID = STRU.PVALU_0
AND IR.PUID = STRU.PUID
AND PK.KEY_VALUE = '图纸编号3A'
-- AND BV.PUID LIKE '%h1hZ4oFDZs10RA%'
--AND RS.PUID = '5DtZo495Zs10RA' --'iJtdHHUoZs10RA'
;