TC:查询零组件的创建日期、修改日期

Teamcenter 11 查询 零组件的创建日期

SELECT PK.PUID AS "主键ID", 
    pi.pitem_id as "项ID" ,
     pir.pitem_revision_id as "版本", 
     pwso.pobject_name "名称",
     PWSO.POBJECT_DESC "描述",
     ( po.plsd +8/24) as "修改日期",
     PIR.PSEQUENCE_ID "序号",
     (PAO.PCREATION_DATE +8/24) AS "创建日期",
     (SELECT PUSER_ID||'-'||PUSER_NAME FROM PPOM_USER PU WHERE PU.PUID = PAO.ROWNING_USERU ) AS "所有人",
     (SELECT PNAME FROM INFODBA.PPOM_GROUP PG WHERE PG.PUID = PAO.ROWNING_GROUPU ) AS "组ID",
     (SELECT PUSER_ID||'-'||PUSER_NAME FROM PPOM_USER PU WHERE PU.PUID = PAO.RLAST_MOD_USERU ) AS "修改用户",
    (PAO.PLAST_MOD_DATE +8/24) as "修改日期2",
     PO.* 
 FROM INFODBA.PITEMREVISION  pir -- 项目版本
      , INFODBA.pitem pi -- 项目
      , INFODBA.pworkSpaceObject pwso -- 工作空间项目
      , INFODBA.PIMANRELATION PREL   -- 类型关系 
      , INFODBA.POM_KEY  PK  -- 项目对象主键 
      , INFODBA.PPOM_OBJECT po  --   POM: Project Object Model 项目对象模型 
      ,INFODBA.PPOM_APPLICATION_OBJECT pao -- 模型应用对象
where pir.ritems_tagu = pi.puid 
 and pi.pitem_id LIKE '00004_'
 and pwso.puid = pir.puid 
 --AND PIR.PSEQUENCE_ID = 1 
 AND PWSO.PACTIVE_SEQ= 1 -- 有效序号，0：无效， 1：有效
 AND PREL.RPRIMARY_OBJECTU = PIR.PUID
 and pi.puid = po.puid 
 AND PI.PUID= PK.PUID 
 AND PIR.PUID = PAO.PUID 
 

　　TEAMCENTER 表关联关系资料比较少的。也许德国的软件的（如：SAP 、PLM）都是不建议用户直接对数据库表进行读取吧

另外 通过 创建一个零组件，跟踪数据库数据记录变动 情况如下：

SELECT * FROM INFODBA.PANCHOR
SELECT * FROM INFODBA.PCONTENTS
SELECT * FROM INFODBA.PFND0GENERALAUDIT
SELECT * FROM INFODBA.PFORM
SELECT * FROM INFODBA.PIMANRELATION
SELECT * FROM INFODBA.PITEM
SELECT * FROM INFODBA.PITEMREVISION
SELECT * FROM INFODBA.PMANAGED_OBJECTS
SELECT * FROM INFODBA.POM_BACKPOINTER
SELECT * FROM INFODBA.POM_KEY
SELECT * FROM INFODBA.POM_R_LOCK
SELECT * FROM INFODBA.POM_TIMESTAMP
SELECT * FROM INFODBA.PPOM_APPLICATION_OBJECT
SELECT * FROM INFODBA.PPOM_OBJECT
SELECT * FROM INFODBA.PWORKSPACEOBJECT