PeopleSoft Tips and Tricks

SELECT * FROM PSACCESSLOG A WHERE EXISTS (SELECT 'X'                   FROM PS_EM_VNDR_USR_SRC EM, PSOPRALIAS OPR                   WHERE EM.OPRID = OPR.OPRID                   AND A.OPRID = EM.OPRID                   AND OPR.OPRALIASTYPE = 'VND') ;

SELECT * FROM PS_ECQUEUE; SELECT * FROM SYSADM.PS_ECQUEUEINST; SELECT * FROM PS_ECTRANS; SELECT * FROM PS_ECTPPROFILE; SELECT * FROM PS_ECTRANSGROUPLOG; SELECT * FROM PS_ECTRANSGROUP_EC; SELECT * FROM PS_ECBUSDOCHDR; SELECT * FROM PS_ECBUSDOCDATA; SELECT * FROM PS_ECBUSDOCDTL;