ZCH_DUP_IDNT_EXCLUSIONS_VL
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: VIEW
Columns
Name |
---|
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 |
Query
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') |