VIEW: APPS.CN_OBJ_TRIGGERS_V

Source

View Text - Preformatted

SELECT o.rowid, o.object_id, o.last_update_date, o.last_updated_by, o.creation_date, o.created_by, o.last_update_login, o.name, o.description, o.dependency_map_complete, o.next_synchronization_date, o.synchronization_frequency, o.object_status, o.repository_id, o.when_clause, o.triggering_event, o.table_id, o.event_id, o.for_each_row, o.trigger_type, o.statement_text, o.seed_object_id, o.object_type FROM CN_OBJECTS O WHERE o.object_type = 'TRG'

View Text - HTML Formatted

SELECT O.ROWID
, O.OBJECT_ID
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.CREATION_DATE
, O.CREATED_BY
, O.LAST_UPDATE_LOGIN
, O.NAME
, O.DESCRIPTION
, O.DEPENDENCY_MAP_COMPLETE
, O.NEXT_SYNCHRONIZATION_DATE
, O.SYNCHRONIZATION_FREQUENCY
, O.OBJECT_STATUS
, O.REPOSITORY_ID
, O.WHEN_CLAUSE
, O.TRIGGERING_EVENT
, O.TABLE_ID
, O.EVENT_ID
, O.FOR_EACH_ROW
, O.TRIGGER_TYPE
, O.STATEMENT_TEXT
, O.SEED_OBJECT_ID
, O.OBJECT_TYPE
FROM CN_OBJECTS O
WHERE O.OBJECT_TYPE = 'TRG'