[Home] [Help]
View: HR_TRIGGER_STATUS_V
View Text
SELECT OWNER
, TRIGGER_NAME
, TRIGGER_TYPE
, TRIGGERING_EVENT
, TABLE_OWNER
, BASE_OBJECT_TYPE
, TABLE_NAME
, COLUMN_NAME
, REFERENCING_NAMES
, WHEN_CLAUSE
, STATUS
, DESCRIPTION
, ACTION_TYPE
, TRIGGER_BODY
FROM ALL_TRIGGERS
WHERE OWNER = 'APPS'
AND TABLE_OWNER = 'HR'
Columns
Name |
OWNER |
TRIGGER_NAME |
TRIGGER_TYPE |
TRIGGERING_EVENT |
TABLE_OWNER |
BASE_OBJECT_TYPE |
TABLE_NAME |
COLUMN_NAME |
REFERENCING_NAMES |
WHEN_CLAUSE |
STATUS |
DESCRIPTION |
ACTION_TYPE |
TRIGGER_BODY |