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;