Wednesday, June 6, 2018

Form Personalization query


SELECT   ffcr.SEQUENCE Seq, ffcr.description Description,
         DECODE (ffcr.rule_type,
                 'F', 'Form',
                 'A', 'Function',
                 'Other'
                ) Levels,
         ffcr.enabled Enabled, ffcr.trigger_event Trigger_Event,
         ffcr.trigger_object Trigger_Object, ffcr.condition Condition,
         DECODE (ffcr.fire_in_enter_query,
                 'Y', 'Both',
                 'N', 'Not in Enter-Query Mode',
                 'O', 'Only in Enter-Query Mode',
                 'Other'
                ) Processing_Mode
    FROM apps.fnd_form_custom_rules ffcr
   WHERE ffcr.function_name = function name
     AND ffcr.form_name = 'form name'
ORDER BY ffcr.SEQUENCE;