VCS_MNGD_EXCEPTIONS_HIST_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: VCS
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
COLLABORATION_ENTRY_ID EXCEPTION_TYPE_CODE EXCEPTION_FLAG |
問合せ
| 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 |