## DEL_MD_TRIGGERS_V_TRG

Code
Dependencies
Details

Name | Value
--- | ---
OWNER | AREL
TRIGGER_NAME | DEL_MD_TRIGGERS_V_TRG
TRIGGER_TYPE | AFTER EACH ROW
TRIGGERING_EVENT | DELETE
TABLE_OWNER | AREL
BASE_OBJECT_TYPE | TABLE
TABLE_NAME | MD_VIEWS
COLUMN_NAME | null
REFERENCING_NAMES | REFERENCING NEW AS NEW OLD AS OLD
WHEN_CLAUSE | null
STATUS | ENABLED
DESCRIPTION | "DEL_MD_TRIGGERS_V_TRG" AFTER DELETE ON MD_VIEWS FOR EACH ROW
ACTION_TYPE | PL/SQL
TRIGGER_BODY | BEGIN DELETE FROM MD_TRIGGERS WHERE MD_TRIGGERS.TABLE_OR_VIEW_ID_FK = :OLD.ID AND MD_TRIGGERS.TRIGGER_ON_FLAG = 'V'; END;
CREATED | 2011-09-19 12:29:35.0
LAST_DDL_TIME | 2011-09-19 12:29:35.0