ZCH_MERGE_DETAILS_VL

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: VIEW

Columns

Name
MERGE_DETAIL_ID DEDUP_HEADER_ID PAR_MERGE_DETAIL_ID RECORD_ID SURVIVOR_ID SURVIVOR_FLAG OBJ_NAME OBJ_DEF TABLE_NAME TOP_ENTITY_FLAG MERGE_REASON_CODE MERGE_STATUS_CODE ACTION_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE CONFLICT_ID MATCH_SCORE MATCH_RULE COMMENTS PARENT_RECORD_ID RULE_BASED_ACTION_FLAG

Query

SQL_Statement

SELECT B.MERGE_DETAIL_ID MERGE_DETAIL_ID, B.DEDUP_HEADER_ID DEDUP_HEADER_ID, B.PAR_MERGE_DETAIL_ID PAR_MERGE_DETAIL_ID, B.RECORD_ID RECORD_ID, B.SURVIVOR_ID SURVIVOR_ID, B.SURVIVOR_FLAG SURVIVOR_FLAG, B.OBJ_NAME OBJ_NAME, B.OBJ_DEF OBJ_DEF, B.TABLE_NAME TABLE_NAME, B.TOP_ENTITY_FLAG TOP_ENTITY_FLAG, B.MERGE_REASON_CODE MERGE_REASON_CODE, B.MERGE_STATUS_CODE MERGE_STATUS_CODE, B.ACTION_TYPE ACTION_TYPE, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, B.CONFLICT_ID CONFLICT_ID, B.MATCH_SCORE, B.MATCH_RULE, TL.COMMENTS COMMENTS, B.PARENT_RECORD_ID, B.RULE_BASED_ACTION_FLAG FROM ZCH_MERGE_DETAILS_B B, ZCH_MERGE_DETAILS_TL TL WHERE B.MERGE_DETAIL_ID = TL.MERGE_DETAIL_ID AND TL.LANGUAGE = USERENV('LANG')