OAF Personlization related Script

 Scripts  Add comments
Sep 282011
 

The below script will list all the OAF Personlizations in Oracle Applications:

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)
ORDER BY PERZ_DOC_PATH;

Related Articles:

  1. Forms Personalization related Script
  2. Menu and Functions Related Scripts
  3. Concurrent Requests and Programs Related Scripts
  4. Script to End Date Responsibility for a User
  5. List of Approvers for a Purchase Order in Position Hierarchy

admin

 Posted by at 2:19 pm

 Leave a Reply

[Social Login] Please enable at least one social network!

*

*

CAPTCHA Image

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>