EGO_CHANGE_AUDIT_INGEST_V

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
AUDIT_ENTITY_ID AUDIT_ENTITY_ATTR_ID CHANGE_ID AUDIT_TYPE ACTION_TYPE CO_STATUS_CODE AUTHOR_ID AUTHOR_NAME AUTHOR_DATETIME AFFECTED_OBJ_NAME AFFECTED_OBJ_SEQ ENTITY_NAME SUB_ENTITY_NAME SUB_ACTION_TYPE ATTR_DISPLAY_NAME ATTR_OLD_VALUE ATTR_NEW_VALUE COMMENTS ENTITY_TYPE CO_STATUS_VALUE SUB_ACTION_TYPE_VALUE ACTION_TYPE_VALUE MIGRATED_FLAG

Query

SQL_Statement

SELECT changeAuditEntities.AUDIT_ENTITY_ID, cast(nvl(changeAuditAttr.AUDIT_ENTITY_ATTR_ID, -1) as number(18)) AUDIT_ENTITY_ATTR_ID, changeAuditEntities.CHANGE_ID, changeAuditEntities.AUDIT_TYPE, DECODE(changeAuditEntities.MIGRATED_FLAG, 'M', changeAuditEntities.ACTION_TYPE_VALUE, changeAuditEntities.ACTION_TYPE) ACTION_TYPE, DECODE(changeAuditEntities.MIGRATED_FLAG, 'M', changeAuditEntities.CO_STATUS_VALUE, to_char(changeAuditEntities.CO_STATUS_CODE)) CO_STATUS_CODE, DECODE(changeAuditEntities.MIGRATED_FLAG, 'M', changeAuditEntities.AUTHOR_NAME, changeAuditEntities.AUTHOR_ID) AUTHOR_ID, changeAuditEntities.AUTHOR_NAME, changeAuditEntities.AUTHOR_DATETIME, changeAuditEntities.AFFECTED_OBJ_NAME, changeAuditEntities.AFFECTED_OBJ_SEQ, changeAuditEntities.ENTITY_NAME, changeAuditEntities.SUB_ENTITY_NAME, DECODE(changeAuditEntities.MIGRATED_FLAG, 'M', changeAuditEntities.SUB_ACTION_TYPE_VALUE, changeAuditEntities.SUB_ACTION_TYPE) SUB_ACTION_TYPE, changeAuditAttr.ATTR_DISPLAY_NAME, changeAuditAttr.ATTR_OLD_VALUE, changeAuditAttr.ATTR_NEW_VALUE, changeAuditEntities.COMMENTS, changeAuditEntities.ENTITY_TYPE, changeAuditEntities.CO_STATUS_VALUE, changeAuditEntities.SUB_ACTION_TYPE_VALUE, changeAuditEntities.ACTION_TYPE_VALUE, changeAuditEntities.MIGRATED_FLAG FROM EGO_CHANGE_AUDIT_ENTITIES changeAuditEntities Left Outer Join EGO_CHANGE_AUDIT_REDLINE_ATTRS changeAuditAttr ON changeAuditEntities.AUDIT_ENTITY_ID=changeAuditAttr.AUDIT_ENTITY_ID