V_PAAC

SELECT     a.puid AS 对象ID, c.puid AS 版本ID, a.pitem_id AS 编号, c.pitem_revision_id AS 版本, c.psequence_id AS 版本序号, b.pobject_name AS 品名, 
                      b.pactive_seq AS 品名序号, d.pvalu_0 AS 状态ID, DATEADD(hh, 8, e.pdate_released) AS 发版时间, b.pobject_type AS 资源类型, ISNULL(a.py6_company, 'XXX') 
                      AS 所属公司, '12' AS 企业编号
FROM         dbo.PITEM AS a LEFT OUTER JOIN
                      dbo.PWORKSPACEOBJECT AS b ON a.puid = b.puid LEFT OUTER JOIN
                      dbo.PITEMREVISION AS c ON a.puid = c.ritems_tagu LEFT OUTER JOIN
                      dbo.PRELEASE_STATUS_LIST AS d ON c.puid = d.puid LEFT OUTER JOIN
                      dbo.PRELEASESTATUS AS e ON d.pvalu_0 = e.puid LEFT OUTER JOIN
                      dbo.PY6_DESPARTREVISION AS f ON c.puid = f.puid