SQL Query to identify the Level 0 record of a component
The below SQL will give all the records of a component along with its corresponding occurs levels: SELECT DISTINCT D . recname ...
Formerly Shyam's PeopleSoft Blog
The below SQL will give all the records of a component along with its corresponding occurs levels: SELECT DISTINCT D . recname ...
The below specified queries are no big deal as we can retrieve the information by viewing the respective definition in Application Designer...
SQL query to get all the child records for a parent record: select recname from psrecdefn CONNECT BY PRIOR RECNAME=PARENTRECNAME START...