EGO_ITEM_INTF_EFF

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
BATCH_ID TRANSACTION_ID PROCESS_STATUS TRANSACTION_TYPE BUNDLE_ID SOURCE_SYSTEM_ID SOURCE_SYSTEM_REFERENCE INVENTORY_ITEM_ID ITEM_NUMBER ORGANIZATION_ID ORGANIZATION_CODE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE THREAD_NUMBER CONTEXT_CODE INTERFACE_TABLE_UNIQUE_ID ROW_NUM ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR40 VERSION_START_DATE VERSION_REVISION_CODE PHASE_NUMBER VERSION_ENABLED_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN BATCH_NUMBER SOURCE_SYSTEM_CODE LOAD_REQUEST_ID ATTRIBUTE_CHAR1_VALUE ATTRIBUTE_CHAR2_VALUE ATTRIBUTE_CHAR3_VALUE ATTRIBUTE_CHAR4_VALUE ATTRIBUTE_CHAR5_VALUE ATTRIBUTE_CHAR6_VALUE ATTRIBUTE_CHAR7_VALUE ATTRIBUTE_CHAR8_VALUE ATTRIBUTE_CHAR9_VALUE ATTRIBUTE_CHAR10_VALUE ATTRIBUTE_CHAR11_VALUE ATTRIBUTE_CHAR12_VALUE ATTRIBUTE_CHAR13_VALUE ATTRIBUTE_CHAR14_VALUE ATTRIBUTE_CHAR15_VALUE ATTRIBUTE_CHAR16_VALUE ATTRIBUTE_CHAR17_VALUE ATTRIBUTE_CHAR18_VALUE ATTRIBUTE_CHAR19_VALUE ATTRIBUTE_CHAR20_VALUE ATTRIBUTE_CHAR21_VALUE ATTRIBUTE_CHAR22_VALUE ATTRIBUTE_CHAR23_VALUE ATTRIBUTE_CHAR24_VALUE ATTRIBUTE_CHAR25_VALUE ATTRIBUTE_CHAR26_VALUE ATTRIBUTE_CHAR27_VALUE ATTRIBUTE_CHAR28_VALUE ATTRIBUTE_CHAR29_VALUE ATTRIBUTE_CHAR30_VALUE ATTRIBUTE_CHAR31_VALUE ATTRIBUTE_CHAR32_VALUE ATTRIBUTE_CHAR33_VALUE ATTRIBUTE_CHAR34_VALUE ATTRIBUTE_CHAR35_VALUE ATTRIBUTE_CHAR36_VALUE ATTRIBUTE_CHAR37_VALUE ATTRIBUTE_CHAR38_VALUE ATTRIBUTE_CHAR39_VALUE ATTRIBUTE_CHAR40_VALUE INTERFACE_DATA_TYPE PREPROCESS_THREAD_NUMBER

Name

BATCH_ID

TRANSACTION_ID

PROCESS_STATUS

TRANSACTION_TYPE

BUNDLE_ID

SOURCE_SYSTEM_ID

SOURCE_SYSTEM_REFERENCE

INVENTORY_ITEM_ID

ITEM_NUMBER

ORGANIZATION_ID

ORGANIZATION_CODE

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

THREAD_NUMBER

CONTEXT_CODE

INTERFACE_TABLE_UNIQUE_ID

ROW_NUM

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_CHAR21

ATTRIBUTE_CHAR22

ATTRIBUTE_CHAR23

ATTRIBUTE_CHAR24

ATTRIBUTE_CHAR25

ATTRIBUTE_CHAR26

ATTRIBUTE_CHAR27

ATTRIBUTE_CHAR28

ATTRIBUTE_CHAR29

ATTRIBUTE_CHAR30

ATTRIBUTE_CHAR31

ATTRIBUTE_CHAR32

ATTRIBUTE_CHAR33

ATTRIBUTE_CHAR34

ATTRIBUTE_CHAR35

ATTRIBUTE_CHAR36

ATTRIBUTE_CHAR37

ATTRIBUTE_CHAR38

ATTRIBUTE_CHAR39

ATTRIBUTE_CHAR40

VERSION_START_DATE

VERSION_REVISION_CODE

PHASE_NUMBER

VERSION_ENABLED_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BATCH_NUMBER

SOURCE_SYSTEM_CODE

LOAD_REQUEST_ID

ATTRIBUTE_CHAR1_VALUE

ATTRIBUTE_CHAR2_VALUE

ATTRIBUTE_CHAR3_VALUE

ATTRIBUTE_CHAR4_VALUE

ATTRIBUTE_CHAR5_VALUE

ATTRIBUTE_CHAR6_VALUE

ATTRIBUTE_CHAR7_VALUE

ATTRIBUTE_CHAR8_VALUE

ATTRIBUTE_CHAR9_VALUE

ATTRIBUTE_CHAR10_VALUE

ATTRIBUTE_CHAR11_VALUE

ATTRIBUTE_CHAR12_VALUE

ATTRIBUTE_CHAR13_VALUE

ATTRIBUTE_CHAR14_VALUE

ATTRIBUTE_CHAR15_VALUE

ATTRIBUTE_CHAR16_VALUE

ATTRIBUTE_CHAR17_VALUE

ATTRIBUTE_CHAR18_VALUE

ATTRIBUTE_CHAR19_VALUE

ATTRIBUTE_CHAR20_VALUE

ATTRIBUTE_CHAR21_VALUE

ATTRIBUTE_CHAR22_VALUE

ATTRIBUTE_CHAR23_VALUE

ATTRIBUTE_CHAR24_VALUE

ATTRIBUTE_CHAR25_VALUE

ATTRIBUTE_CHAR26_VALUE

ATTRIBUTE_CHAR27_VALUE

ATTRIBUTE_CHAR28_VALUE

ATTRIBUTE_CHAR29_VALUE

ATTRIBUTE_CHAR30_VALUE

ATTRIBUTE_CHAR31_VALUE

ATTRIBUTE_CHAR32_VALUE

ATTRIBUTE_CHAR33_VALUE

ATTRIBUTE_CHAR34_VALUE

ATTRIBUTE_CHAR35_VALUE

ATTRIBUTE_CHAR36_VALUE

ATTRIBUTE_CHAR37_VALUE

ATTRIBUTE_CHAR38_VALUE

ATTRIBUTE_CHAR39_VALUE

ATTRIBUTE_CHAR40_VALUE

INTERFACE_DATA_TYPE

PREPROCESS_THREAD_NUMBER

Query

SQL_Statement
SELECT EGO_ITEM_INTF_EFF_TL.BATCH_ID BATCH_ID, EGO_ITEM_INTF_EFF_TL.TRANSACTION_ID TRANSACTION_ID, EGO_ITEM_INTF_EFF_TL.PROCESS_STATUS PROCESS_STATUS, EGO_ITEM_INTF_EFF_TL.TRANSACTION_TYPE TRANSACTION_TYPE, EGO_ITEM_INTF_EFF_TL.BUNDLE_ID BUNDLE_ID, EGO_ITEM_INTF_EFF_TL.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID, EGO_ITEM_INTF_EFF_TL.SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE, EGO_ITEM_INTF_EFF_TL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, EGO_ITEM_INTF_EFF_TL.ITEM_NUMBER ITEM_NUMBER, EGO_ITEM_INTF_EFF_TL.ORGANIZATION_ID ORGANIZATION_ID, EGO_ITEM_INTF_EFF_TL.ORGANIZATION_CODE ORGANIZATION_CODE, EGO_ITEM_INTF_EFF_TL.REQUEST_ID REQUEST_ID, EGO_ITEM_INTF_EFF_TL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, EGO_ITEM_INTF_EFF_TL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, EGO_ITEM_INTF_EFF_TL.THREAD_NUMBER THREAD_NUMBER, EGO_ITEM_INTF_EFF_TL.CONTEXT_CODE CONTEXT_CODE, EGO_ITEM_INTF_EFF_TL.INTERFACE_TABLE_UNIQUE_ID INTERFACE_TABLE_UNIQUE_ID, EGO_ITEM_INTF_EFF_TL.ROW_NUM ROW_NUM, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR31, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR32, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR33, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR34, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR35, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR36, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR37, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR38, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR39, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR40 ATTRIBUTE_CHAR40, EGO_ITEM_INTF_EFF_TL.VERSION_START_DATE VERSION_START_DATE, EGO_ITEM_INTF_EFF_TL.VERSION_REVISION_CODE VERSION_REVISION_CODE, EGO_ITEM_INTF_EFF_TL.PHASE_NUMBER PHASE_NUMBER, EGO_ITEM_INTF_EFF_TL.VERSION_ENABLED_FLAG VERSION_ENABLED_FLAG, EGO_ITEM_INTF_EFF_TL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_ITEM_INTF_EFF_TL.CREATED_BY CREATED_BY, EGO_ITEM_INTF_EFF_TL.CREATION_DATE CREATION_DATE, EGO_ITEM_INTF_EFF_TL.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_ITEM_INTF_EFF_TL.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_ITEM_INTF_EFF_TL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_ITEM_INTF_EFF_TL.BATCH_NUMBER BATCH_NUMBER, EGO_ITEM_INTF_EFF_TL.SOURCE_SYSTEM_CODE SOURCE_SYSTEM_CODE, EGO_ITEM_INTF_EFF_TL.LOAD_REQUEST_ID LOAD_REQUEST_ID, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR1_VALUE ATTRIBUTE_CHAR1_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR2_VALUE ATTRIBUTE_CHAR2_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR3_VALUE ATTRIBUTE_CHAR3_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR4_VALUE ATTRIBUTE_CHAR4_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR5_VALUE ATTRIBUTE_CHAR5_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR6_VALUE ATTRIBUTE_CHAR6_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR7_VALUE ATTRIBUTE_CHAR7_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR8_VALUE ATTRIBUTE_CHAR8_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR9_VALUE ATTRIBUTE_CHAR9_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR10_VALUE ATTRIBUTE_CHAR10_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR11_VALUE ATTRIBUTE_CHAR11_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR12_VALUE ATTRIBUTE_CHAR12_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR13_VALUE ATTRIBUTE_CHAR13_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR14_VALUE ATTRIBUTE_CHAR14_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR15_VALUE ATTRIBUTE_CHAR15_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR16_VALUE ATTRIBUTE_CHAR16_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR17_VALUE ATTRIBUTE_CHAR17_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR18_VALUE ATTRIBUTE_CHAR18_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR19_VALUE ATTRIBUTE_CHAR19_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR20_VALUE ATTRIBUTE_CHAR20_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR21_VALUE ATTRIBUTE_CHAR21_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR22_VALUE ATTRIBUTE_CHAR22_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR23_VALUE ATTRIBUTE_CHAR23_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR24_VALUE ATTRIBUTE_CHAR24_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR25_VALUE ATTRIBUTE_CHAR25_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR26_VALUE ATTRIBUTE_CHAR26_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR27_VALUE ATTRIBUTE_CHAR27_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR28_VALUE ATTRIBUTE_CHAR28_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR29_VALUE ATTRIBUTE_CHAR29_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR30_VALUE ATTRIBUTE_CHAR30_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR31_VALUE ATTRIBUTE_CHAR31_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR32_VALUE ATTRIBUTE_CHAR32_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR33_VALUE ATTRIBUTE_CHAR33_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR34_VALUE ATTRIBUTE_CHAR34_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR35_VALUE ATTRIBUTE_CHAR35_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR36_VALUE ATTRIBUTE_CHAR36_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR37_VALUE ATTRIBUTE_CHAR37_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR38_VALUE ATTRIBUTE_CHAR38_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR39_VALUE ATTRIBUTE_CHAR39_VALUE, EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR40_VALUE ATTRIBUTE_CHAR40_VALUE, EGO_ITEM_INTF_EFF_TL.INTERFACE_DATA_TYPE INTERFACE_DATA_TYPE , EGO_ITEM_INTF_EFF_TL.PREPROCESS_THREAD_NUMBER PREPROCESS_THREAD_NUMBER FROM EGO_ITEM_INTF_EFF_TL WHERE EGO_ITEM_INTF_EFF_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

EGO_ITEM_INTF_EFF_TL.BATCH_ID BATCH_ID,

EGO_ITEM_INTF_EFF_TL.TRANSACTION_ID TRANSACTION_ID,

EGO_ITEM_INTF_EFF_TL.PROCESS_STATUS PROCESS_STATUS,

EGO_ITEM_INTF_EFF_TL.TRANSACTION_TYPE TRANSACTION_TYPE,

EGO_ITEM_INTF_EFF_TL.BUNDLE_ID BUNDLE_ID,

EGO_ITEM_INTF_EFF_TL.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID,

EGO_ITEM_INTF_EFF_TL.SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE,

EGO_ITEM_INTF_EFF_TL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

EGO_ITEM_INTF_EFF_TL.ITEM_NUMBER ITEM_NUMBER,

EGO_ITEM_INTF_EFF_TL.ORGANIZATION_ID ORGANIZATION_ID,

EGO_ITEM_INTF_EFF_TL.ORGANIZATION_CODE ORGANIZATION_CODE,

EGO_ITEM_INTF_EFF_TL.REQUEST_ID REQUEST_ID,

EGO_ITEM_INTF_EFF_TL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

EGO_ITEM_INTF_EFF_TL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

EGO_ITEM_INTF_EFF_TL.THREAD_NUMBER THREAD_NUMBER,

EGO_ITEM_INTF_EFF_TL.CONTEXT_CODE CONTEXT_CODE,

EGO_ITEM_INTF_EFF_TL.INTERFACE_TABLE_UNIQUE_ID INTERFACE_TABLE_UNIQUE_ID,

EGO_ITEM_INTF_EFF_TL.ROW_NUM ROW_NUM,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR31,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR32,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR33,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR34,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR35,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR36,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR37,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR38,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR39,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR40 ATTRIBUTE_CHAR40,

EGO_ITEM_INTF_EFF_TL.VERSION_START_DATE VERSION_START_DATE,

EGO_ITEM_INTF_EFF_TL.VERSION_REVISION_CODE VERSION_REVISION_CODE,

EGO_ITEM_INTF_EFF_TL.PHASE_NUMBER PHASE_NUMBER,

EGO_ITEM_INTF_EFF_TL.VERSION_ENABLED_FLAG VERSION_ENABLED_FLAG,

EGO_ITEM_INTF_EFF_TL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_ITEM_INTF_EFF_TL.CREATED_BY CREATED_BY,

EGO_ITEM_INTF_EFF_TL.CREATION_DATE CREATION_DATE,

EGO_ITEM_INTF_EFF_TL.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_ITEM_INTF_EFF_TL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_ITEM_INTF_EFF_TL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_ITEM_INTF_EFF_TL.BATCH_NUMBER BATCH_NUMBER,

EGO_ITEM_INTF_EFF_TL.SOURCE_SYSTEM_CODE SOURCE_SYSTEM_CODE,

EGO_ITEM_INTF_EFF_TL.LOAD_REQUEST_ID LOAD_REQUEST_ID,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR1_VALUE ATTRIBUTE_CHAR1_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR2_VALUE ATTRIBUTE_CHAR2_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR3_VALUE ATTRIBUTE_CHAR3_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR4_VALUE ATTRIBUTE_CHAR4_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR5_VALUE ATTRIBUTE_CHAR5_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR6_VALUE ATTRIBUTE_CHAR6_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR7_VALUE ATTRIBUTE_CHAR7_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR8_VALUE ATTRIBUTE_CHAR8_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR9_VALUE ATTRIBUTE_CHAR9_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR10_VALUE ATTRIBUTE_CHAR10_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR11_VALUE ATTRIBUTE_CHAR11_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR12_VALUE ATTRIBUTE_CHAR12_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR13_VALUE ATTRIBUTE_CHAR13_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR14_VALUE ATTRIBUTE_CHAR14_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR15_VALUE ATTRIBUTE_CHAR15_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR16_VALUE ATTRIBUTE_CHAR16_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR17_VALUE ATTRIBUTE_CHAR17_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR18_VALUE ATTRIBUTE_CHAR18_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR19_VALUE ATTRIBUTE_CHAR19_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR20_VALUE ATTRIBUTE_CHAR20_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR21_VALUE ATTRIBUTE_CHAR21_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR22_VALUE ATTRIBUTE_CHAR22_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR23_VALUE ATTRIBUTE_CHAR23_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR24_VALUE ATTRIBUTE_CHAR24_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR25_VALUE ATTRIBUTE_CHAR25_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR26_VALUE ATTRIBUTE_CHAR26_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR27_VALUE ATTRIBUTE_CHAR27_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR28_VALUE ATTRIBUTE_CHAR28_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR29_VALUE ATTRIBUTE_CHAR29_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR30_VALUE ATTRIBUTE_CHAR30_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR31_VALUE ATTRIBUTE_CHAR31_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR32_VALUE ATTRIBUTE_CHAR32_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR33_VALUE ATTRIBUTE_CHAR33_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR34_VALUE ATTRIBUTE_CHAR34_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR35_VALUE ATTRIBUTE_CHAR35_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR36_VALUE ATTRIBUTE_CHAR36_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR37_VALUE ATTRIBUTE_CHAR37_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR38_VALUE ATTRIBUTE_CHAR38_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR39_VALUE ATTRIBUTE_CHAR39_VALUE,

EGO_ITEM_INTF_EFF_TL.ATTRIBUTE_CHAR40_VALUE ATTRIBUTE_CHAR40_VALUE,

EGO_ITEM_INTF_EFF_TL.INTERFACE_DATA_TYPE INTERFACE_DATA_TYPE ,

EGO_ITEM_INTF_EFF_TL.PREPROCESS_THREAD_NUMBER PREPROCESS_THREAD_NUMBER

FROM

EGO_ITEM_INTF_EFF_TL

WHERE

EGO_ITEM_INTF_EFF_TL.LANGUAGE = USERENV('LANG')