You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Looking for SQL to show all PeopleCode on Componet.

1 reply [Last post]
ChiDONEt's picture
User offline. Last seen 1 year 28 weeks ago. Offline
Joined: 09/24/2008
Posts: 9

Given a Component Name I want the list of all Peoplecode that it have on records and events, pages, etc..
If some have one idea... thanks in advance.

Janaka11's picture
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 03/01/2015
Posts: 5
Re: Looking for SQL to show all PeopleCode on Componet.

You can use something like

SELECT * FROM PSPCMTXT WHERE OBJECTID1 = 10
and OBJECTVALUE1 = 'SFA_RUN_EDITMSG';

where OBJECTVALUE1 is your component name.

PSPCMTXT is the table where you can find read only versions of the PeopleCode programs.

for more tips go to http://www.peoplesoftdotnet.blogspot.com.au/