Saturday, January 8, 2022

Query to find a list of all the forms in Oracle Applications that have been customized using Forms Personalization

 Query to find all Forms customized uining Personalization



Query to find a list of all the forms in Oracle Applications that have been customized using Forms Personalization:

select distinct a.form_name , a.enabled, c.USER_FORM_NAME, d.APPLICATION_NAME 

from FND_FORM_CUSTOM_RULES a,

     FND_FORM b,

     FND_FORM_TL c,

     fnd_application_tl d

where enabled = 'Y'

and a.form_name = b.form_name

and b.form_id = c.form_id

and b.application_id = d.application_id

order by application_name;


No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...