Sunday, 25 March 2018

SQL To find Who Modified PeopleCode

SQL To find Who Modified PeopleCode

The below SQL helps to identify who modified PeopleCode.
SELECT objectvalue1 record_name, objectvalue2 field_name,
       objectvalue3 peoplecode_event, lastupddttm, lastupdoprid
  FROM pspcmprog
WHERE objectvalue1 = :record_name
   AND objectvalue2 = :field_name
   AND UPPER (objectvalue3) = UPPER (:peoplecode_event);

No comments:

Post a Comment