VIEW: CSI.CSI_I_ORG_ASSIGNMENTS_H#

Source

View Text - Preformatted

select INSTANCE_OU_HISTORY_ID INSTANCE_OU_HISTORY_ID, INSTANCE_OU_ID INSTANCE_OU_ID, TRANSACTION_ID TRANSACTION_ID, OLD_OPERATING_UNIT_ID OLD_OPERATING_UNIT_ID, NEW_OPERATING_UNIT_ID NEW_OPERATING_UNIT_ID, OLD_RELATIONSHIP_TYPE_CODE OLD_RELATIONSHIP_TYPE_CODE, NEW_RELATIONSHIP_TYPE_CODE NEW_RELATIONSHIP_TYPE_CODE, OLD_ACTIVE_START_DATE OLD_ACTIVE_START_DATE, NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE, OLD_ACTIVE_END_DATE OLD_ACTIVE_END_DATE, NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE, OLD_CONTEXT OLD_CONTEXT, NEW_CONTEXT NEW_CONTEXT, OLD_ATTRIBUTE1 OLD_ATTRIBUTE1, NEW_ATTRIBUTE1 NEW_ATTRIBUTE1, OLD_ATTRIBUTE2 OLD_ATTRIBUTE2, NEW_ATTRIBUTE2 NEW_ATTRIBUTE2, OLD_ATTRIBUTE3 OLD_ATTRIBUTE3, NEW_ATTRIBUTE3 NEW_ATTRIBUTE3, OLD_ATTRIBUTE4 OLD_ATTRIBUTE4, NEW_ATTRIBUTE4 NEW_ATTRIBUTE4, OLD_ATTRIBUTE5 OLD_ATTRIBUTE5, NEW_ATTRIBUTE5 NEW_ATTRIBUTE5, OLD_ATTRIBUTE6 OLD_ATTRIBUTE6, NEW_ATTRIBUTE6 NEW_ATTRIBUTE6, OLD_ATTRIBUTE7 OLD_ATTRIBUTE7, NEW_ATTRIBUTE7 NEW_ATTRIBUTE7, OLD_ATTRIBUTE8 OLD_ATTRIBUTE8, NEW_ATTRIBUTE8 NEW_ATTRIBUTE8, OLD_ATTRIBUTE9 OLD_ATTRIBUTE9, NEW_ATTRIBUTE9 NEW_ATTRIBUTE9, OLD_ATTRIBUTE10 OLD_ATTRIBUTE10, NEW_ATTRIBUTE10 NEW_ATTRIBUTE10, OLD_ATTRIBUTE11 OLD_ATTRIBUTE11, NEW_ATTRIBUTE11 NEW_ATTRIBUTE11, OLD_ATTRIBUTE12 OLD_ATTRIBUTE12, NEW_ATTRIBUTE12 NEW_ATTRIBUTE12, OLD_ATTRIBUTE13 OLD_ATTRIBUTE13, NEW_ATTRIBUTE13 NEW_ATTRIBUTE13, OLD_ATTRIBUTE14 OLD_ATTRIBUTE14, NEW_ATTRIBUTE14 NEW_ATTRIBUTE14, OLD_ATTRIBUTE15 OLD_ATTRIBUTE15, NEW_ATTRIBUTE15 NEW_ATTRIBUTE15, FULL_DUMP_FLAG FULL_DUMP_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MIGRATED_FLAG MIGRATED_FLAG from "CSI"."CSI_I_ORG_ASSIGNMENTS_H"

View Text - HTML Formatted

SELECT INSTANCE_OU_HISTORY_ID INSTANCE_OU_HISTORY_ID
, INSTANCE_OU_ID INSTANCE_OU_ID
, TRANSACTION_ID TRANSACTION_ID
, OLD_OPERATING_UNIT_ID OLD_OPERATING_UNIT_ID
, NEW_OPERATING_UNIT_ID NEW_OPERATING_UNIT_ID
, OLD_RELATIONSHIP_TYPE_CODE OLD_RELATIONSHIP_TYPE_CODE
, NEW_RELATIONSHIP_TYPE_CODE NEW_RELATIONSHIP_TYPE_CODE
, OLD_ACTIVE_START_DATE OLD_ACTIVE_START_DATE
, NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE
, OLD_ACTIVE_END_DATE OLD_ACTIVE_END_DATE
, NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE
, OLD_CONTEXT OLD_CONTEXT
, NEW_CONTEXT NEW_CONTEXT
, OLD_ATTRIBUTE1 OLD_ATTRIBUTE1
, NEW_ATTRIBUTE1 NEW_ATTRIBUTE1
, OLD_ATTRIBUTE2 OLD_ATTRIBUTE2
, NEW_ATTRIBUTE2 NEW_ATTRIBUTE2
, OLD_ATTRIBUTE3 OLD_ATTRIBUTE3
, NEW_ATTRIBUTE3 NEW_ATTRIBUTE3
, OLD_ATTRIBUTE4 OLD_ATTRIBUTE4
, NEW_ATTRIBUTE4 NEW_ATTRIBUTE4
, OLD_ATTRIBUTE5 OLD_ATTRIBUTE5
, NEW_ATTRIBUTE5 NEW_ATTRIBUTE5
, OLD_ATTRIBUTE6 OLD_ATTRIBUTE6
, NEW_ATTRIBUTE6 NEW_ATTRIBUTE6
, OLD_ATTRIBUTE7 OLD_ATTRIBUTE7
, NEW_ATTRIBUTE7 NEW_ATTRIBUTE7
, OLD_ATTRIBUTE8 OLD_ATTRIBUTE8
, NEW_ATTRIBUTE8 NEW_ATTRIBUTE8
, OLD_ATTRIBUTE9 OLD_ATTRIBUTE9
, NEW_ATTRIBUTE9 NEW_ATTRIBUTE9
, OLD_ATTRIBUTE10 OLD_ATTRIBUTE10
, NEW_ATTRIBUTE10 NEW_ATTRIBUTE10
, OLD_ATTRIBUTE11 OLD_ATTRIBUTE11
, NEW_ATTRIBUTE11 NEW_ATTRIBUTE11
, OLD_ATTRIBUTE12 OLD_ATTRIBUTE12
, NEW_ATTRIBUTE12 NEW_ATTRIBUTE12
, OLD_ATTRIBUTE13 OLD_ATTRIBUTE13
, NEW_ATTRIBUTE13 NEW_ATTRIBUTE13
, OLD_ATTRIBUTE14 OLD_ATTRIBUTE14
, NEW_ATTRIBUTE14 NEW_ATTRIBUTE14
, OLD_ATTRIBUTE15 OLD_ATTRIBUTE15
, NEW_ATTRIBUTE15 NEW_ATTRIBUTE15
, FULL_DUMP_FLAG FULL_DUMP_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, MIGRATED_FLAG MIGRATED_FLAG
FROM "CSI"."CSI_I_ORG_ASSIGNMENTS_H"