Identifying modified peoplecode and PeopleSoft objects based upon OPRID and Date modified

SELECT DISTINCT OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3  FROM PSPCMPROG
WHERE LASTUPDDTTM = SYSDATE 
AND (OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3)  -- Specify PeopleSoft objects name
NOT IN 
(SELECT OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3
FROM PSPROJECTITEM WHERE PROJECTNAME LIKE '%SS')  AND LASTUPDOPRID !='OPRID';


SELECT * FROM PSRECDEFN WHERE LASTUPDDTTM >'01-JAN-2008' AND LASTUPDOPRID NOT LIKE 'PPLSOFT';

SHARE

peoplesoft

• 
• 
• 
• 
•