PeopleSoft finally in 8.52 tools delivers a table with all peoplecode listed in plain text in table: “pspcmtxt”.

Use this SQL:

select objectvalue1,objectvalue2,objectvalue3,objectvalue4,pctext from pspcmtxt ;

Example:

select objectvalue1,objectvalue2,objectvalue3,objectvalue4,pctext from pspcmtxt where UPPER(pctext) like ‘%CLEARDROPDOWN%’

Advertisements