OAF: SQL Query to get all the Personalization on the OAF Pages in Oracle

Below Sql script is used to get all the Personliazations on the OAF Page in Oracle.

--------------------------------------------------------------------------------------------------------

SELECT PATH.path_docid perz_doc_id,

         jdr_mds_internal.getdocumentname (PATH.path_docid) perz_doc_path

    FROM jdr_paths PATH

   WHERE PATH.path_docid IN

               (SELECT DISTINCT comp_docid

                  FROM jdr_components

                 WHERE     comp_seq = 0

                       AND comp_element = 'customization'

                       AND comp_id IS NULL)

         AND UPPER (jdr_mds_internal.getdocumentname (PATH.path_docid)) LIKE

               UPPER ('%CustomPageNamePG%')

ORDER BY perz_doc_path;

--------------------------------------------------------------------------------------------------------