EGO_CHANGE_LINES

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
CHANGE_LINE_ID OBJECT_VERSION_NUMBER CHANGE_ID LINE_TYPE_ID ORGANIZATION_ID SEQUENCE_NUMBER SUBJECT_INTERNAL_NAME PK1_VALUE PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE STATUS_CODE STATUS_TYPE NAME DESCRIPTION CANCEL_COMMENTS LIFECYCLE_STATE_ID ASSIGNEE_ID NEED_BY_DATE SCHEDULED_DATE IMPLEMENTATION_DATE CANCELATION_DATE REQUIRED_FLAG COMPLETE_BEFORE_STATUS_CODE START_AFTER_STATUS_CODE NEW_ITEM_REVISION_ID NEW_ITEM_REVISION NEW_REVISION_REASON BATCH_ID THREAD_NUMBER REQUEST_ID PROGRAM_NAME PROGRAM_APP_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 EFFECTIVITY_ON_APPROVAL_FLAG DEPENDENCY_FLAG ASSIGNED_BY ASSIGNED_DATE PLAN_NAME USE_UP_ITEM_ID

Name

CHANGE_LINE_ID

OBJECT_VERSION_NUMBER

CHANGE_ID

LINE_TYPE_ID

ORGANIZATION_ID

SEQUENCE_NUMBER

SUBJECT_INTERNAL_NAME

PK1_VALUE

PK2_VALUE

PK3_VALUE

PK4_VALUE

PK5_VALUE

STATUS_CODE

STATUS_TYPE

NAME

DESCRIPTION

CANCEL_COMMENTS

LIFECYCLE_STATE_ID

ASSIGNEE_ID

NEED_BY_DATE

SCHEDULED_DATE

IMPLEMENTATION_DATE

CANCELATION_DATE

REQUIRED_FLAG

COMPLETE_BEFORE_STATUS_CODE

START_AFTER_STATUS_CODE

NEW_ITEM_REVISION_ID

NEW_ITEM_REVISION

NEW_REVISION_REASON

BATCH_ID

THREAD_NUMBER

REQUEST_ID

PROGRAM_NAME

PROGRAM_APP_NAME

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

EFFECTIVITY_ON_APPROVAL_FLAG

DEPENDENCY_FLAG

ASSIGNED_BY

ASSIGNED_DATE

PLAN_NAME

USE_UP_ITEM_ID

Query

SQL_Statement
SELECT EGO_CHANGE_LINES_B.CHANGE_LINE_ID CHANGE_LINE_ID, EGO_CHANGE_LINES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_CHANGE_LINES_B.CHANGE_ID CHANGE_ID, EGO_CHANGE_LINES_B.LINE_TYPE_ID LINE_TYPE_ID, EGO_CHANGE_LINES_B.ORGANIZATION_ID ORGANIZATION_ID, EGO_CHANGE_LINES_B.SEQUENCE_NUMBER SEQUENCE_NUMBER, EGO_CHANGE_LINES_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME, EGO_CHANGE_LINES_B.PK1_VALUE PK1_VALUE, EGO_CHANGE_LINES_B.PK2_VALUE PK2_VALUE, EGO_CHANGE_LINES_B.PK3_VALUE PK3_VALUE, EGO_CHANGE_LINES_B.PK4_VALUE PK4_VALUE, EGO_CHANGE_LINES_B.PK5_VALUE PK5_VALUE, EGO_CHANGE_LINES_B.STATUS_CODE STATUS_CODE, EGO_CHANGE_LINES_B.STATUS_TYPE STATUS_TYPE, EGO_CHANGE_LINES_TL.NAME NAME, EGO_CHANGE_LINES_TL.DESCRIPTION DESCRIPTION, EGO_CHANGE_LINES_TL.CANCEL_COMMENTS CANCEL_COMMENTS, EGO_CHANGE_LINES_B.LIFECYCLE_STATE_ID LIFECYCLE_STATE_ID, EGO_CHANGE_LINES_B.ASSIGNEE_ID ASSIGNEE_ID, EGO_CHANGE_LINES_B.NEED_BY_DATE NEED_BY_DATE, EGO_CHANGE_LINES_B.SCHEDULED_DATE SCHEDULED_DATE, EGO_CHANGE_LINES_B.IMPLEMENTATION_DATE IMPLEMENTATION_DATE, EGO_CHANGE_LINES_B.CANCELATION_DATE CANCELATION_DATE, EGO_CHANGE_LINES_B.REQUIRED_FLAG REQUIRED_FLAG, EGO_CHANGE_LINES_B.COMPLETE_BEFORE_STATUS_CODE COMPLETE_BEFORE_STATUS_CODE, EGO_CHANGE_LINES_B.START_AFTER_STATUS_CODE START_AFTER_STATUS_CODE, EGO_CHANGE_LINES_B.NEW_ITEM_REVISION_ID NEW_ITEM_REVISION_ID, EGO_CHANGE_LINES_B.NEW_ITEM_REVISION NEW_ITEM_REVISION, EGO_CHANGE_LINES_B.NEW_REVISION_REASON NEW_REVISION_REASON, EGO_CHANGE_LINES_B.BATCH_ID BATCH_ID, EGO_CHANGE_LINES_B.THREAD_NUMBER THREAD_NUMBER, EGO_CHANGE_LINES_B.REQUEST_ID REQUEST_ID, EGO_CHANGE_LINES_B.PROGRAM_NAME PROGRAM_NAME, EGO_CHANGE_LINES_B.PROGRAM_APP_NAME PROGRAM_APP_NAME, EGO_CHANGE_LINES_B.CREATED_BY CREATED_BY, EGO_CHANGE_LINES_B.CREATION_DATE CREATION_DATE, EGO_CHANGE_LINES_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_CHANGE_LINES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_CHANGE_LINES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_CHANGE_LINES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, EGO_CHANGE_LINES_B.ATTRIBUTE1 ATTRIBUTE1, EGO_CHANGE_LINES_B.ATTRIBUTE2 ATTRIBUTE2, EGO_CHANGE_LINES_B.ATTRIBUTE3 ATTRIBUTE3, EGO_CHANGE_LINES_B.ATTRIBUTE4 ATTRIBUTE4, EGO_CHANGE_LINES_B.ATTRIBUTE5 ATTRIBUTE5, EGO_CHANGE_LINES_B.ATTRIBUTE6 ATTRIBUTE6, EGO_CHANGE_LINES_B.ATTRIBUTE7 ATTRIBUTE7, EGO_CHANGE_LINES_B.ATTRIBUTE8 ATTRIBUTE8, EGO_CHANGE_LINES_B.ATTRIBUTE9 ATTRIBUTE9, EGO_CHANGE_LINES_B.ATTRIBUTE10 ATTRIBUTE10, EGO_CHANGE_LINES_B.ATTRIBUTE11 ATTRIBUTE11, EGO_CHANGE_LINES_B.ATTRIBUTE12 ATTRIBUTE12, EGO_CHANGE_LINES_B.ATTRIBUTE13 ATTRIBUTE13, EGO_CHANGE_LINES_B.ATTRIBUTE14 ATTRIBUTE14, EGO_CHANGE_LINES_B.ATTRIBUTE15 ATTRIBUTE15, EGO_CHANGE_LINES_B.ATTRIBUTE16 ATTRIBUTE16, EGO_CHANGE_LINES_B.ATTRIBUTE17 ATTRIBUTE17, EGO_CHANGE_LINES_B.ATTRIBUTE18 ATTRIBUTE18, EGO_CHANGE_LINES_B.ATTRIBUTE19 ATTRIBUTE19, EGO_CHANGE_LINES_B.ATTRIBUTE20 ATTRIBUTE20, EGO_CHANGE_LINES_B.ATTRIBUTE21 ATTRIBUTE21, EGO_CHANGE_LINES_B.ATTRIBUTE22 ATTRIBUTE22, EGO_CHANGE_LINES_B.ATTRIBUTE23 ATTRIBUTE23, EGO_CHANGE_LINES_B.ATTRIBUTE24 ATTRIBUTE24, EGO_CHANGE_LINES_B.ATTRIBUTE25 ATTRIBUTE25, EGO_CHANGE_LINES_B.ATTRIBUTE26 ATTRIBUTE26, EGO_CHANGE_LINES_B.ATTRIBUTE27 ATTRIBUTE27, EGO_CHANGE_LINES_B.ATTRIBUTE28 ATTRIBUTE28, EGO_CHANGE_LINES_B.ATTRIBUTE29 ATTRIBUTE29, EGO_CHANGE_LINES_B.ATTRIBUTE30 ATTRIBUTE30, EGO_CHANGE_LINES_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, EGO_CHANGE_LINES_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, EGO_CHANGE_LINES_B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, EGO_CHANGE_LINES_B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, EGO_CHANGE_LINES_B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, EGO_CHANGE_LINES_B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, EGO_CHANGE_LINES_B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, EGO_CHANGE_LINES_B.EFFECTIVITY_ON_APPROVAL_FLAG EFFECTIVITY_ON_APPROVAL_FLAG, EGO_CHANGE_LINES_B.DEPENDENCY_FLAG DEPENDENCY_FLAG, EGO_CHANGE_LINES_B.ASSIGNED_BY ASSIGNED_BY, EGO_CHANGE_LINES_B.ASSIGNED_DATE ASSIGNED_DATE, EGO_CHANGE_LINES_B.PLAN_NAME, EGO_CHANGE_LINES_B.USE_UP_ITEM_ID FROM EGO_CHANGE_LINES_B, EGO_CHANGE_LINES_TL WHERE EGO_CHANGE_LINES_B.CHANGE_LINE_ID = EGO_CHANGE_LINES_TL.CHANGE_LINE_ID AND EGO_CHANGE_LINES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

EGO_CHANGE_LINES_B.CHANGE_LINE_ID CHANGE_LINE_ID,

EGO_CHANGE_LINES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_CHANGE_LINES_B.CHANGE_ID CHANGE_ID,

EGO_CHANGE_LINES_B.LINE_TYPE_ID LINE_TYPE_ID,

EGO_CHANGE_LINES_B.ORGANIZATION_ID ORGANIZATION_ID,

EGO_CHANGE_LINES_B.SEQUENCE_NUMBER SEQUENCE_NUMBER,

EGO_CHANGE_LINES_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME,

EGO_CHANGE_LINES_B.PK1_VALUE PK1_VALUE,

EGO_CHANGE_LINES_B.PK2_VALUE PK2_VALUE,

EGO_CHANGE_LINES_B.PK3_VALUE PK3_VALUE,

EGO_CHANGE_LINES_B.PK4_VALUE PK4_VALUE,

EGO_CHANGE_LINES_B.PK5_VALUE PK5_VALUE,

EGO_CHANGE_LINES_B.STATUS_CODE STATUS_CODE,

EGO_CHANGE_LINES_B.STATUS_TYPE STATUS_TYPE,

EGO_CHANGE_LINES_TL.NAME NAME,

EGO_CHANGE_LINES_TL.DESCRIPTION DESCRIPTION,

EGO_CHANGE_LINES_TL.CANCEL_COMMENTS CANCEL_COMMENTS,

EGO_CHANGE_LINES_B.LIFECYCLE_STATE_ID LIFECYCLE_STATE_ID,

EGO_CHANGE_LINES_B.ASSIGNEE_ID ASSIGNEE_ID,

EGO_CHANGE_LINES_B.NEED_BY_DATE NEED_BY_DATE,

EGO_CHANGE_LINES_B.SCHEDULED_DATE SCHEDULED_DATE,

EGO_CHANGE_LINES_B.IMPLEMENTATION_DATE IMPLEMENTATION_DATE,

EGO_CHANGE_LINES_B.CANCELATION_DATE CANCELATION_DATE,

EGO_CHANGE_LINES_B.REQUIRED_FLAG REQUIRED_FLAG,

EGO_CHANGE_LINES_B.COMPLETE_BEFORE_STATUS_CODE COMPLETE_BEFORE_STATUS_CODE,

EGO_CHANGE_LINES_B.START_AFTER_STATUS_CODE START_AFTER_STATUS_CODE,

EGO_CHANGE_LINES_B.NEW_ITEM_REVISION_ID NEW_ITEM_REVISION_ID,

EGO_CHANGE_LINES_B.NEW_ITEM_REVISION NEW_ITEM_REVISION,

EGO_CHANGE_LINES_B.NEW_REVISION_REASON NEW_REVISION_REASON,

EGO_CHANGE_LINES_B.BATCH_ID BATCH_ID,

EGO_CHANGE_LINES_B.THREAD_NUMBER THREAD_NUMBER,

EGO_CHANGE_LINES_B.REQUEST_ID REQUEST_ID,

EGO_CHANGE_LINES_B.PROGRAM_NAME PROGRAM_NAME,

EGO_CHANGE_LINES_B.PROGRAM_APP_NAME PROGRAM_APP_NAME,

EGO_CHANGE_LINES_B.CREATED_BY CREATED_BY,

EGO_CHANGE_LINES_B.CREATION_DATE CREATION_DATE,

EGO_CHANGE_LINES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_CHANGE_LINES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_CHANGE_LINES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_CHANGE_LINES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

EGO_CHANGE_LINES_B.ATTRIBUTE1 ATTRIBUTE1,

EGO_CHANGE_LINES_B.ATTRIBUTE2 ATTRIBUTE2,

EGO_CHANGE_LINES_B.ATTRIBUTE3 ATTRIBUTE3,

EGO_CHANGE_LINES_B.ATTRIBUTE4 ATTRIBUTE4,

EGO_CHANGE_LINES_B.ATTRIBUTE5 ATTRIBUTE5,

EGO_CHANGE_LINES_B.ATTRIBUTE6 ATTRIBUTE6,

EGO_CHANGE_LINES_B.ATTRIBUTE7 ATTRIBUTE7,

EGO_CHANGE_LINES_B.ATTRIBUTE8 ATTRIBUTE8,

EGO_CHANGE_LINES_B.ATTRIBUTE9 ATTRIBUTE9,

EGO_CHANGE_LINES_B.ATTRIBUTE10 ATTRIBUTE10,

EGO_CHANGE_LINES_B.ATTRIBUTE11 ATTRIBUTE11,

EGO_CHANGE_LINES_B.ATTRIBUTE12 ATTRIBUTE12,

EGO_CHANGE_LINES_B.ATTRIBUTE13 ATTRIBUTE13,

EGO_CHANGE_LINES_B.ATTRIBUTE14 ATTRIBUTE14,

EGO_CHANGE_LINES_B.ATTRIBUTE15 ATTRIBUTE15,

EGO_CHANGE_LINES_B.ATTRIBUTE16 ATTRIBUTE16,

EGO_CHANGE_LINES_B.ATTRIBUTE17 ATTRIBUTE17,

EGO_CHANGE_LINES_B.ATTRIBUTE18 ATTRIBUTE18,

EGO_CHANGE_LINES_B.ATTRIBUTE19 ATTRIBUTE19,

EGO_CHANGE_LINES_B.ATTRIBUTE20 ATTRIBUTE20,

EGO_CHANGE_LINES_B.ATTRIBUTE21 ATTRIBUTE21,

EGO_CHANGE_LINES_B.ATTRIBUTE22 ATTRIBUTE22,

EGO_CHANGE_LINES_B.ATTRIBUTE23 ATTRIBUTE23,

EGO_CHANGE_LINES_B.ATTRIBUTE24 ATTRIBUTE24,

EGO_CHANGE_LINES_B.ATTRIBUTE25 ATTRIBUTE25,

EGO_CHANGE_LINES_B.ATTRIBUTE26 ATTRIBUTE26,

EGO_CHANGE_LINES_B.ATTRIBUTE27 ATTRIBUTE27,

EGO_CHANGE_LINES_B.ATTRIBUTE28 ATTRIBUTE28,

EGO_CHANGE_LINES_B.ATTRIBUTE29 ATTRIBUTE29,

EGO_CHANGE_LINES_B.ATTRIBUTE30 ATTRIBUTE30,

EGO_CHANGE_LINES_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

EGO_CHANGE_LINES_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

EGO_CHANGE_LINES_B.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

EGO_CHANGE_LINES_B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

EGO_CHANGE_LINES_B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

EGO_CHANGE_LINES_B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

EGO_CHANGE_LINES_B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

EGO_CHANGE_LINES_B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

EGO_CHANGE_LINES_B.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

EGO_CHANGE_LINES_B.EFFECTIVITY_ON_APPROVAL_FLAG EFFECTIVITY_ON_APPROVAL_FLAG,

EGO_CHANGE_LINES_B.DEPENDENCY_FLAG DEPENDENCY_FLAG,

EGO_CHANGE_LINES_B.ASSIGNED_BY ASSIGNED_BY,

EGO_CHANGE_LINES_B.ASSIGNED_DATE ASSIGNED_DATE,

EGO_CHANGE_LINES_B.PLAN_NAME,

EGO_CHANGE_LINES_B.USE_UP_ITEM_ID

FROM

EGO_CHANGE_LINES_B,

EGO_CHANGE_LINES_TL

WHERE

EGO_CHANGE_LINES_B.CHANGE_LINE_ID = EGO_CHANGE_LINES_TL.CHANGE_LINE_ID AND EGO_CHANGE_LINES_TL.LANGUAGE = USERENV('LANG')