Friday, 6 May 2016

Form personalization query on form

SELECT   fcr.form_name, fcr.function_name, fcr.SEQUENCE "Rule Seq",
         fcr.description, fcr.condition, fca.SEQUENCE "Action Seq",
         fca.action_type, fca.object_type, fca.target_object,
         fca.MESSAGE_TYPE, fca.MESSAGE_TEXT, fca.builtin_type,
         fca.builtin_arguments, fca.property_name, fca.property_value,
         fca.menu_entry, fca.menu_label, fca.menu_seperator,
         fca.menu_enabled_in, fca.menu_argument_long, fca.menu_argument_short
    FROM apps.fnd_form_custom_rules fcr,
         apps.fnd_form_custom_scopes fcs,
         apps.fnd_form_custom_actions fca
   WHERE                                          --fcr.form_name = 'OEXOEORD'
         fcr.enabled = 'Y'
     AND fcr.ID = fcs.rule_id
     AND (   fcs.level_id = 20
          OR (    fcs.level_id = 30
              AND fcs.level_value =
                     (SELECT responsibility_id
                        FROM fnd_responsibility_tl
                       WHERE responsibility_name = 'ME HLS Sales Quote - RSM'
                         AND LANGUAGE = USERENV ('LANG'))
             )
         )
     AND fcr.ID = fca.rule_id
     AND fca.enabled = 'Y'

ORDER BY fcr.SEQUENCE, fca.SEQUENCE

No comments:

Post a Comment