VIEW: APPS.HR_TRIGGER_STATUS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'