By using Following query you can get application wise detail

SELECT (SELECT application_name

FROM fnd_application_tl fa

WHERE fa.application_id = ff.application_id)

application,

ffcr.ID,

ffcr.SEQUENCE,

ffcr.function_name,

REPLACE (ffcr.description, CHR (39), CHR (39) || CHR (39)) description,

ffcr.trigger_event,

ffcr.trigger_object,

REPLACE (REPLACE (ffcr.condition, CHR (10), CHR (32)),

CHR (39),

CHR (39) || CHR (39))

condition,

ffcr.enabled,

ffcr.fire_in_enter_query,

ffcr.rule_key,

ffcr.form_name,

ffcr.rule_type

FROM apps.fnd_form_custom_rules ffcr, applsys.fnd_form ff

WHERE (ff.form_name) = (ffcr.form_name)