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
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(+);