EGO_ITEM_EFF_TL_PUB

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
EFF_LINE_ID ORGANIZATION_ID INVENTORY_ITEM_ID CONTEXT_CODE CHANGE_LINE_ID VERSION_ID VERSION_START_DATE VERSION_END_DATE IMPLEMENTATION_DATE CHANGE_BIT_MAP ACD_TYPE 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 PROGRAM_NAME PROGRAM_APP_NAME OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CATEGORY_CODE REQUEST_ID

Name

EFF_LINE_ID

ORGANIZATION_ID

INVENTORY_ITEM_ID

CONTEXT_CODE

CHANGE_LINE_ID

VERSION_ID

VERSION_START_DATE

VERSION_END_DATE

IMPLEMENTATION_DATE

CHANGE_BIT_MAP

ACD_TYPE

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

PROGRAM_NAME

PROGRAM_APP_NAME

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CATEGORY_CODE

REQUEST_ID

Query

SQL_Statement
SELECT EGO_ITEM_EFF_TL.EFF_LINE_ID EFF_LINE_ID, EGO_ITEM_EFF_TL.ORGANIZATION_ID ORGANIZATION_ID, EGO_ITEM_EFF_TL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, EGO_ITEM_EFF_TL.CONTEXT_CODE CONTEXT_CODE, EGO_ITEM_EFF_TL.CHANGE_LINE_ID CHANGE_LINE_ID, EGO_ITEM_EFF_TL.VERSION_ID VERSION_ID, EGO_ITEM_EFF_TL.VERSION_START_DATE VERSION_START_DATE, EGO_ITEM_EFF_TL.VERSION_END_DATE VERSION_END_DATE, EGO_ITEM_EFF_TL.IMPLEMENTATION_DATE IMPLEMENTATION_DATE, EGO_ITEM_EFF_TL.CHANGE_BIT_MAP CHANGE_BIT_MAP, EGO_ITEM_EFF_TL.ACD_TYPE ACD_TYPE, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR31, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR32, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR33, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR34, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR35, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR36, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR37, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR38, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR39, EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR40 ATTRIBUTE_CHAR40, EGO_ITEM_EFF_TL.PROGRAM_NAME PROGRAM_NAME, EGO_ITEM_EFF_TL.PROGRAM_APP_NAME PROGRAM_APP_NAME , EGO_ITEM_EFF_TL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_ITEM_EFF_TL.CREATED_BY CREATED_BY, EGO_ITEM_EFF_TL.CREATION_DATE CREATION_DATE, EGO_ITEM_EFF_TL.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_ITEM_EFF_TL.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_ITEM_EFF_TL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_ITEM_EFF_TL.CATEGORY_CODE CATEGORY_CODE, EGO_ITEM_EFF_TL.REQUEST_ID REQUEST_ID FROM EGO_ITEM_EFF_TL WHERE EGO_ITEM_EFF_TL.LANGUAGE = USERENV('LANG') UNION ( SELECT ItemEffTLAuditEO.EFF_LINE_ID EFF_LINE_ID, ItemEffTLAuditEO.ORGANIZATION_ID ORGANIZATION_ID, ItemEffTLAuditEO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ItemEffTLAuditEO.CONTEXT_CODE CONTEXT_CODE, ItemEffTLAuditEO.CHANGE_LINE_ID CHANGE_LINE_ID, ItemEffTLAuditEO.VERSION_ID VERSION_ID, ItemEffTLAuditEO.VERSION_START_DATE VERSION_START_DATE, ItemEffTLAuditEO.VERSION_END_DATE VERSION_END_DATE, ItemEffTLAuditEO.IMPLEMENTATION_DATE IMPLEMENTATION_DATE, ItemEffTLAuditEO.CHANGE_BIT_MAP CHANGE_BIT_MAP, ItemEffTLAuditEO.ACD_TYPE ACD_TYPE, ItemEffTLAuditEO.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, ItemEffTLAuditEO.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, ItemEffTLAuditEO.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, ItemEffTLAuditEO.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, ItemEffTLAuditEO.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, ItemEffTLAuditEO.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, ItemEffTLAuditEO.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, ItemEffTLAuditEO.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, ItemEffTLAuditEO.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, ItemEffTLAuditEO.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, ItemEffTLAuditEO.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, ItemEffTLAuditEO.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, ItemEffTLAuditEO.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, ItemEffTLAuditEO.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, ItemEffTLAuditEO.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, ItemEffTLAuditEO.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, ItemEffTLAuditEO.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, ItemEffTLAuditEO.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, ItemEffTLAuditEO.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, ItemEffTLAuditEO.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, ItemEffTLAuditEO.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21, ItemEffTLAuditEO.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22, ItemEffTLAuditEO.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23, ItemEffTLAuditEO.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24, ItemEffTLAuditEO.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25, ItemEffTLAuditEO.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26, ItemEffTLAuditEO.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27, ItemEffTLAuditEO.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28, ItemEffTLAuditEO.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29, ItemEffTLAuditEO.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30, ItemEffTLAuditEO.ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR31, ItemEffTLAuditEO.ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR32, ItemEffTLAuditEO.ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR33, ItemEffTLAuditEO.ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR34, ItemEffTLAuditEO.ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR35, ItemEffTLAuditEO.ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR36, ItemEffTLAuditEO.ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR37, ItemEffTLAuditEO.ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR38, ItemEffTLAuditEO.ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR39, ItemEffTLAuditEO.ATTRIBUTE_CHAR40 ATTRIBUTE_CHAR40, ItemEffTLAuditEO.PROGRAM_NAME PROGRAM_NAME, ItemEffTLAuditEO.PROGRAM_APP_NAME PROGRAM_APP_NAME , ItemEffTLAuditEO.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ItemEffTLAuditEO.CREATED_BY CREATED_BY, ItemEffTLAuditEO.CREATION_DATE CREATION_DATE, ItemEffTLAuditEO.LAST_UPDATED_BY LAST_UPDATED_BY, ItemEffTLAuditEO.LAST_UPDATE_DATE LAST_UPDATE_DATE, ItemEffTLAuditEO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ItemEffTLAuditEO.CATEGORY_CODE CATEGORY_CODE, ItemEffTLAuditEO.REQUEST_ID REQUEST_ID FROM EGO_ITEM_EFF_TL_ ItemEffTLAuditEO WHERE ItemEffTLAuditEO.LANGUAGE = USERENV('LANG') AND ItemEffTLAuditEO.AUDIT_ACTION_TYPE_ = 'DELETE' )

SQL_Statement

SELECT

EGO_ITEM_EFF_TL.EFF_LINE_ID EFF_LINE_ID,

EGO_ITEM_EFF_TL.ORGANIZATION_ID ORGANIZATION_ID,

EGO_ITEM_EFF_TL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

EGO_ITEM_EFF_TL.CONTEXT_CODE CONTEXT_CODE,

EGO_ITEM_EFF_TL.CHANGE_LINE_ID CHANGE_LINE_ID,

EGO_ITEM_EFF_TL.VERSION_ID VERSION_ID,

EGO_ITEM_EFF_TL.VERSION_START_DATE VERSION_START_DATE,

EGO_ITEM_EFF_TL.VERSION_END_DATE VERSION_END_DATE,

EGO_ITEM_EFF_TL.IMPLEMENTATION_DATE IMPLEMENTATION_DATE,

EGO_ITEM_EFF_TL.CHANGE_BIT_MAP CHANGE_BIT_MAP,

EGO_ITEM_EFF_TL.ACD_TYPE ACD_TYPE,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR31,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR32,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR33,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR34,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR35,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR36,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR37,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR38,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR39,

EGO_ITEM_EFF_TL.ATTRIBUTE_CHAR40 ATTRIBUTE_CHAR40,

EGO_ITEM_EFF_TL.PROGRAM_NAME PROGRAM_NAME,

EGO_ITEM_EFF_TL.PROGRAM_APP_NAME PROGRAM_APP_NAME ,

EGO_ITEM_EFF_TL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_ITEM_EFF_TL.CREATED_BY CREATED_BY,

EGO_ITEM_EFF_TL.CREATION_DATE CREATION_DATE,

EGO_ITEM_EFF_TL.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_ITEM_EFF_TL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_ITEM_EFF_TL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_ITEM_EFF_TL.CATEGORY_CODE CATEGORY_CODE,

EGO_ITEM_EFF_TL.REQUEST_ID REQUEST_ID

FROM

EGO_ITEM_EFF_TL

WHERE

EGO_ITEM_EFF_TL.LANGUAGE = USERENV('LANG')

UNION

(

SELECT

ItemEffTLAuditEO.EFF_LINE_ID EFF_LINE_ID,

ItemEffTLAuditEO.ORGANIZATION_ID ORGANIZATION_ID,

ItemEffTLAuditEO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

ItemEffTLAuditEO.CONTEXT_CODE CONTEXT_CODE,

ItemEffTLAuditEO.CHANGE_LINE_ID CHANGE_LINE_ID,

ItemEffTLAuditEO.VERSION_ID VERSION_ID,

ItemEffTLAuditEO.VERSION_START_DATE VERSION_START_DATE,

ItemEffTLAuditEO.VERSION_END_DATE VERSION_END_DATE,

ItemEffTLAuditEO.IMPLEMENTATION_DATE IMPLEMENTATION_DATE,

ItemEffTLAuditEO.CHANGE_BIT_MAP CHANGE_BIT_MAP,

ItemEffTLAuditEO.ACD_TYPE ACD_TYPE,

ItemEffTLAuditEO.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

ItemEffTLAuditEO.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

ItemEffTLAuditEO.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

ItemEffTLAuditEO.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

ItemEffTLAuditEO.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

ItemEffTLAuditEO.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

ItemEffTLAuditEO.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

ItemEffTLAuditEO.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

ItemEffTLAuditEO.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

ItemEffTLAuditEO.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

ItemEffTLAuditEO.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

ItemEffTLAuditEO.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

ItemEffTLAuditEO.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

ItemEffTLAuditEO.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

ItemEffTLAuditEO.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

ItemEffTLAuditEO.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

ItemEffTLAuditEO.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

ItemEffTLAuditEO.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

ItemEffTLAuditEO.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

ItemEffTLAuditEO.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

ItemEffTLAuditEO.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21,

ItemEffTLAuditEO.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22,

ItemEffTLAuditEO.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23,

ItemEffTLAuditEO.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24,

ItemEffTLAuditEO.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25,

ItemEffTLAuditEO.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26,

ItemEffTLAuditEO.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27,

ItemEffTLAuditEO.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28,

ItemEffTLAuditEO.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29,

ItemEffTLAuditEO.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30,

ItemEffTLAuditEO.ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR31,

ItemEffTLAuditEO.ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR32,

ItemEffTLAuditEO.ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR33,

ItemEffTLAuditEO.ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR34,

ItemEffTLAuditEO.ATTRIBUTE_CHAR35 ATTRIBUTE_CHAR35,

ItemEffTLAuditEO.ATTRIBUTE_CHAR36 ATTRIBUTE_CHAR36,

ItemEffTLAuditEO.ATTRIBUTE_CHAR37 ATTRIBUTE_CHAR37,

ItemEffTLAuditEO.ATTRIBUTE_CHAR38 ATTRIBUTE_CHAR38,

ItemEffTLAuditEO.ATTRIBUTE_CHAR39 ATTRIBUTE_CHAR39,

ItemEffTLAuditEO.ATTRIBUTE_CHAR40 ATTRIBUTE_CHAR40,

ItemEffTLAuditEO.PROGRAM_NAME PROGRAM_NAME,

ItemEffTLAuditEO.PROGRAM_APP_NAME PROGRAM_APP_NAME ,

ItemEffTLAuditEO.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ItemEffTLAuditEO.CREATED_BY CREATED_BY,

ItemEffTLAuditEO.CREATION_DATE CREATION_DATE,

ItemEffTLAuditEO.LAST_UPDATED_BY LAST_UPDATED_BY,

ItemEffTLAuditEO.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ItemEffTLAuditEO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ItemEffTLAuditEO.CATEGORY_CODE CATEGORY_CODE,

ItemEffTLAuditEO.REQUEST_ID REQUEST_ID

FROM

EGO_ITEM_EFF_TL_ ItemEffTLAuditEO

WHERE

ItemEffTLAuditEO.LANGUAGE = USERENV('LANG')

AND ItemEffTLAuditEO.AUDIT_ACTION_TYPE_ = 'DELETE'

)