Querying lists of PeopleSoft definitions through SQL*Plus

For some time, we have had been trying to list down all customizations done; however, I do not know where customizations are stored in the database. I know where the SQL tables and views are stored, but nothing else regarding this matter.

In which tables are the following definitions listed (e.g. for records defined as tables, they are located at SYS.ALL_TABLES) in the database, queryable through SQL*Plus?

• Records (regardless of record type)
• Pages and Subpages
• Components
• Portal Menu Definitions
• SQL definitions for Records
• Any other definition commonly used for customizations (I can't think of anything else at the moment)