Hi Chandra

You can use this query to list all customizations across all modules

SELECT   PATH.PATH_DOCID CUSTM_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_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)
ORDER BY CUSTM_DOC_PATH;

and if you want to get only specific module you can use following query:

SELECT   PATH.PATH_DOCID PERZ_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_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      (JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID)) LIKE '%/ar/%'
ORDER BY CUSTM_DOC_PATH;