PeopleSoft查看所有translate value
下面sql可以列出PS中所有translate value
SELECT FIELDNAME, FIELDVALUE, EFFDT, EFF_STATUS, XLATLONGNAME, XLATSHORTNAME, LASTUPDDTTM, LASTUPDOPRID, SYNCID FROM PSXLATITEM A WHERE EFFDT = (SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME = A.FIELDNAME AND FIELDVALUE = A.FIELDVALUE AND A.EFFDT <= SYSDATE) AND A.EFF_STATUS = 'A';
posted on 2018-07-04 00:19 Maxwell_Yang 阅读(170) 评论(0) 编辑 收藏 举报