ZCH_DUP_IDNT_EXCLUSIONS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZCH
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
DUP_IDNT_EXCLUSION_ID OBJ_NAME OBJ_DEF SURVIVOR_RECORD_ID EXCLUDED_RECORD_ID EXCL_START_DATE EXCL_END_DATE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER COMMENTS |
問合せ
| SQL_Statement |
|---|
|
SELECT B.DUP_IDNT_EXCLUSION_ID DUP_IDNT_EXCLUSION_ID, B.OBJ_NAME OBJ_NAME, B.OBJ_DEF OBJ_DEF, B.SURVIVOR_RECORD_ID SURVIVOR_RECORD_ID, B.EXCLUDED_RECORD_ID EXCLUDED_RECORD_ID, B.EXCL_START_DATE EXCL_START_DATE, B.EXCL_END_DATE EXCL_END_DATE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TL.COMMENTS COMMENTS FROM ZCH_DUP_IDNT_EXCLUSIONS_B B, ZCH_DUP_IDNT_EXCLUSIONS_TL TL WHERE B.DUP_IDNT_EXCLUSION_ID = TL.DUP_IDNT_EXCLUSION_ID AND TL.LANGUAGE = USERENV('LANG') |