As a part of impact analysis while doing any major development work in PeopleSoft, often you may have to search for definition references of fields and other objects. The Find In will bring out list of all the pages where the field might be used. Now to find out the component list where these pages are used, you may have to end up doing the Find In for each and every page. Sometimes if the referenced pages are more, it will become a tiring work. I want to share a simple SQL which could reduce most of your work if you are looking for component references for a field.
Again, the SQL provided here is a simple one and for example purpose. However you could explore more on the system tables and come up with such simpler and time saving SQL’s. If you already do have some, keep sharing the same in the comments section.
SELECT nvl(b.pnlgrpname,'Not added in any component.') AS Component,
a.pnlname AS Page,
a.pnlfldid AS FieldId
FROM pspnlfield a,
WHERE a.recname = 'RECORD_NAME'
AND a.fieldname = 'FIELD_NAME'
AND a.pnlname = b.pnlname(+);