SELECT fcr.function_name,
fcr.description,
fcr.trigger_event,
fcr.trigger_object,
fcr.condition,
fcr.enabled,
fcr.fire_in_enter_query,
--fcr.rule_type,
--fcr.form_name,
fcs.level_id,
fcs.level_value,
fca.*
FROM applsys.fnd_form_custom_rules fcr,
applsys.fnd_form_custom_scopes fcs,
applsys.fnd_form_custom_actions fca
WHERE fcr.id = fcs.rule_id(+)
AND fcr.id = fca.rule_id(+)