ALR_ALERTS.ALERT_CONDITION_TYPE(Event, Periodic) in Oracle Alerts

SELECT * FROM fnd_lookups WHERE lookup_type = 'ALERT_CONDITION_TYPE'