Oracle EBS Form Personalization Query

 Form Personzalization in Oracle:


 SELECT   fat.application_name, ffc.function_name, fff.user_function_name,
         fff.description function_description, ffc.form_name,
         fft.user_form_name, fft.description form_description, ffc.SEQUENCE,
         ffc.description, trigger_event, trigger_object, condition,
         ffc.enabled, ffca.SEQUENCE line_sequence, argument_type, action_type,
         ffca.enabled line_enabled, object_type, ffca.MESSAGE_TYPE,
         ffca.MESSAGE_TEXT, ffca.builtin_type, ffca.property_name,
         ffca.menu_entry, ffca.menu_label, menu_action,
         ffca.menu_argument_long, ffca.menu_argument_short
    FROM fnd_form_custom_rules ffc,
         fnd_form_custom_actions ffca,
         fnd_form_functions_vl fff,
         fnd_form_tl fft,
         fnd_application_tl fat
   WHERE ffc.ID = ffca.rule_id
     AND ffc.form_name = NVL (:p_form_name, ffc.form_name)
     AND ffc.description = NVL (:p_forms_personalization, ffc.description)
     AND ffc.function_name = fff.function_name
     AND fff.form_id = fft.form_id
     AND fat.application_id = fff.application_id
     AND ffc.form_name LIKE 'GME%'
ORDER BY fat.application_name, ffc.form_name, ffc.SEQUENCE