Showing posts with label Form Personalization. Show all posts
Showing posts with label Form Personalization. Show all posts

Tuesday, June 15, 2021

Query to view all Form Personalizations in Oracle Apps

 SELECT fp.application_id

       ,fp.application_short_name

   ,fpt.application_name

   ,ff.form_name

   ,fft.user_form_name

   ,fft.description

   ,fff.function_name

   ,ffft.user_function_name

   ,ffft.description

   ,ffcr.function_name

   ,ffcr.description

   ,ffcr.trigger_event

   ,ffcr.trigger_object

   ,ffcr.condition

   ,ffcr.sequence

   ,ffcr.enabled

   ,frt.responsibility_name

   ,frt.description

   ,fu.user_id

   ,fu.user_name

   FROM fnd_application fp

       ,fnd_application_tl fpt

       ,fnd_form ff

       ,fnd_form_tl fft

       ,fnd_form_functions fff

       ,fnd_form_functions_tl ffft

       ,fnd_form_custom_rules ffcr

       ,fnd_form_custom_scopes ffcs

       ,fnd_responsibility_tl frt

       ,fnd_user fu

       ,fnd_form_custom_actions ffca

       ,fnd_form_custom_prop_list ffcpl

 WHERE fp.application_id = fpt.application_id

   AND fpt.application_id = ff.application_id

   AND ff.form_id = fft.form_id

   AND ff.form_id = fff.form_id 

   AND fff.function_id = ffft.function_id

   AND ff.form_name = ffcr.form_name

   AND ffcr.function_name = fff.function_name

   AND ffcr.id = ffcs.rule_id

   AND ffcs.created_by = fu.user_id

   and ffcr.last_updated_by = fu.user_id

   and ff.last_updated_by = fu.user_id

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records