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);
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