VCS_MNGD_EXCEPTIONS_HIST_V

Details

• Schema: FUSION

• Object owner: VCS

• Object type: VIEW

Columns

Name
COLLABORATION_ENTRY_ID EXCEPTION_TYPE_CODE EXCEPTION_FLAG

Query

SQL_Statement
SELECT collaboration_entry_id, exception_type_code, CASE WHEN COUNT(*)>0 THEN 'Y' ELSE 'N' END EXCEPTION_FLAG FROM vcs_managed_exceptions_hist GROUP BY collaboration_entry_id, exception_type_code