EGO_ITEM_EFF_PUB

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
EFF_LINE_ID CATEGORY_CODE OBJECT_VERSION_NUMBER ORGANIZATION_ID INVENTORY_ITEM_ID CONTEXT_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN 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_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 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 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 PROGRAM_NAME PROGRAM_APP_NAME ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_NUMBER1_UOM ATTRIBUTE_NUMBER2_UOM ATTRIBUTE_NUMBER3_UOM ATTRIBUTE_NUMBER4_UOM ATTRIBUTE_NUMBER5_UOM ATTRIBUTE_NUMBER6_UOM ATTRIBUTE_NUMBER7_UOM ATTRIBUTE_NUMBER8_UOM ATTRIBUTE_NUMBER9_UOM ATTRIBUTE_NUMBER10_UOM ATTRIBUTE_NUMBER11_UOM ATTRIBUTE_NUMBER12_UOM ATTRIBUTE_NUMBER13_UOM ATTRIBUTE_NUMBER14_UOM ATTRIBUTE_NUMBER15_UOM ATTRIBUTE_NUMBER16_UOM ATTRIBUTE_NUMBER17_UOM ATTRIBUTE_NUMBER18_UOM ATTRIBUTE_NUMBER19_UOM ATTRIBUTE_NUMBER20_UOM ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 REQUEST_ID

Name

EFF_LINE_ID

CATEGORY_CODE

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

INVENTORY_ITEM_ID

CONTEXT_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

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_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

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

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

PROGRAM_NAME

PROGRAM_APP_NAME

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ATTRIBUTE_TIMESTAMP6

ATTRIBUTE_TIMESTAMP7

ATTRIBUTE_TIMESTAMP8

ATTRIBUTE_TIMESTAMP9

ATTRIBUTE_TIMESTAMP10

ATTRIBUTE_NUMBER1_UOM

ATTRIBUTE_NUMBER2_UOM

ATTRIBUTE_NUMBER3_UOM

ATTRIBUTE_NUMBER4_UOM

ATTRIBUTE_NUMBER5_UOM

ATTRIBUTE_NUMBER6_UOM

ATTRIBUTE_NUMBER7_UOM

ATTRIBUTE_NUMBER8_UOM

ATTRIBUTE_NUMBER9_UOM

ATTRIBUTE_NUMBER10_UOM

ATTRIBUTE_NUMBER11_UOM

ATTRIBUTE_NUMBER12_UOM

ATTRIBUTE_NUMBER13_UOM

ATTRIBUTE_NUMBER14_UOM

ATTRIBUTE_NUMBER15_UOM

ATTRIBUTE_NUMBER16_UOM

ATTRIBUTE_NUMBER17_UOM

ATTRIBUTE_NUMBER18_UOM

ATTRIBUTE_NUMBER19_UOM

ATTRIBUTE_NUMBER20_UOM

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

REQUEST_ID

Query

SQL_Statement
SELECT ItemEffBaseEO.EFF_LINE_ID, ItemEffBaseEO.CATEGORY_CODE, ItemEffBaseEO.OBJECT_VERSION_NUMBER, ItemEffBaseEO.ORGANIZATION_ID, ItemEffBaseEO.INVENTORY_ITEM_ID, ItemEffBaseEO.CONTEXT_CODE, ItemEffBaseEO.CREATED_BY, ItemEffBaseEO.CREATION_DATE, ItemEffBaseEO.LAST_UPDATED_BY, ItemEffBaseEO.LAST_UPDATE_DATE, ItemEffBaseEO.LAST_UPDATE_LOGIN, ItemEffBaseEO.CHANGE_LINE_ID, ItemEffBaseEO.VERSION_ID, ItemEffBaseEO.VERSION_START_DATE, ItemEffBaseEO.VERSION_END_DATE, ItemEffBaseEO.IMPLEMENTATION_DATE, ItemEffBaseEO.CHANGE_BIT_MAP, ItemEffBaseEO.ACD_TYPE, ItemEffBaseEO.ATTRIBUTE_CHAR1, ItemEffBaseEO.ATTRIBUTE_CHAR2, ItemEffBaseEO.ATTRIBUTE_CHAR3, ItemEffBaseEO.ATTRIBUTE_CHAR4, ItemEffBaseEO.ATTRIBUTE_CHAR5, ItemEffBaseEO.ATTRIBUTE_CHAR6, ItemEffBaseEO.ATTRIBUTE_CHAR7, ItemEffBaseEO.ATTRIBUTE_CHAR8, ItemEffBaseEO.ATTRIBUTE_CHAR9, ItemEffBaseEO.ATTRIBUTE_CHAR10, ItemEffBaseEO.ATTRIBUTE_CHAR11, ItemEffBaseEO.ATTRIBUTE_CHAR12, ItemEffBaseEO.ATTRIBUTE_CHAR13, ItemEffBaseEO.ATTRIBUTE_CHAR14, ItemEffBaseEO.ATTRIBUTE_CHAR15, ItemEffBaseEO.ATTRIBUTE_CHAR16, ItemEffBaseEO.ATTRIBUTE_CHAR17, ItemEffBaseEO.ATTRIBUTE_CHAR18, ItemEffBaseEO.ATTRIBUTE_CHAR19, ItemEffBaseEO.ATTRIBUTE_CHAR20, ItemEffBaseEO.ATTRIBUTE_NUMBER1, ItemEffBaseEO.ATTRIBUTE_NUMBER2, ItemEffBaseEO.ATTRIBUTE_NUMBER3, ItemEffBaseEO.ATTRIBUTE_NUMBER4, ItemEffBaseEO.ATTRIBUTE_NUMBER5, ItemEffBaseEO.ATTRIBUTE_NUMBER6, ItemEffBaseEO.ATTRIBUTE_NUMBER7, ItemEffBaseEO.ATTRIBUTE_NUMBER8, ItemEffBaseEO.ATTRIBUTE_NUMBER9, ItemEffBaseEO.ATTRIBUTE_NUMBER10, ItemEffBaseEO.ATTRIBUTE_CHAR21, ItemEffBaseEO.ATTRIBUTE_CHAR22, ItemEffBaseEO.ATTRIBUTE_CHAR23, ItemEffBaseEO.ATTRIBUTE_CHAR24, ItemEffBaseEO.ATTRIBUTE_CHAR25, ItemEffBaseEO.ATTRIBUTE_CHAR26, ItemEffBaseEO.ATTRIBUTE_CHAR27, ItemEffBaseEO.ATTRIBUTE_CHAR28, ItemEffBaseEO.ATTRIBUTE_CHAR29, ItemEffBaseEO.ATTRIBUTE_CHAR30, ItemEffBaseEO.ATTRIBUTE_CHAR31, ItemEffBaseEO.ATTRIBUTE_CHAR32, ItemEffBaseEO.ATTRIBUTE_CHAR33, ItemEffBaseEO.ATTRIBUTE_CHAR34, ItemEffBaseEO.ATTRIBUTE_CHAR35, ItemEffBaseEO.ATTRIBUTE_CHAR36, ItemEffBaseEO.ATTRIBUTE_CHAR37, ItemEffBaseEO.ATTRIBUTE_CHAR38, ItemEffBaseEO.ATTRIBUTE_CHAR39, ItemEffBaseEO.ATTRIBUTE_CHAR40, ItemEffBaseEO.ATTRIBUTE_NUMBER11, ItemEffBaseEO.ATTRIBUTE_NUMBER12, ItemEffBaseEO.ATTRIBUTE_NUMBER13, ItemEffBaseEO.ATTRIBUTE_NUMBER14, ItemEffBaseEO.ATTRIBUTE_NUMBER15, ItemEffBaseEO.ATTRIBUTE_NUMBER16, ItemEffBaseEO.ATTRIBUTE_NUMBER17, ItemEffBaseEO.ATTRIBUTE_NUMBER18, ItemEffBaseEO.ATTRIBUTE_NUMBER19, ItemEffBaseEO.ATTRIBUTE_NUMBER20, ItemEffBaseEO.PROGRAM_NAME, ItemEffBaseEO.PROGRAM_APP_NAME, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP1, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP2, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP3, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP4, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP5, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP6, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP7, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP8, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP9, ItemEffBaseEO.ATTRIBUTE_TIMESTAMP10, ItemEffBaseEO.ATTRIBUTE_NUMBER1_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER2_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER3_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER4_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER5_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER6_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER7_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER8_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER9_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER10_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER11_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER12_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER13_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER14_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER15_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER16_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER17_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER18_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER19_UOM, ItemEffBaseEO.ATTRIBUTE_NUMBER20_UOM, ItemEffBaseEO.ATTRIBUTE_DATE1, ItemEffBaseEO.ATTRIBUTE_DATE2, ItemEffBaseEO.ATTRIBUTE_DATE3, ItemEffBaseEO.ATTRIBUTE_DATE4, ItemEffBaseEO.ATTRIBUTE_DATE5, ItemEffBaseEO.ATTRIBUTE_DATE6, ItemEffBaseEO.ATTRIBUTE_DATE7, ItemEffBaseEO.ATTRIBUTE_DATE8, ItemEffBaseEO.ATTRIBUTE_DATE9, ItemEffBaseEO.ATTRIBUTE_DATE10, ItemEffBaseEO.REQUEST_ID FROM EGO_ITEM_EFF_B ItemEffBaseEO UNION (SELECT ItemEffBaseAuditEO.EFF_LINE_ID, ItemEffBaseAuditEO.CATEGORY_CODE, ItemEffBaseAuditEO.OBJECT_VERSION_NUMBER, ItemEffBaseAuditEO.ORGANIZATION_ID, ItemEffBaseAuditEO.INVENTORY_ITEM_ID, ItemEffBaseAuditEO.CONTEXT_CODE, ItemEffBaseAuditEO.CREATED_BY, ItemEffBaseAuditEO.CREATION_DATE, ItemEffBaseAuditEO.LAST_UPDATED_BY, ItemEffBaseAuditEO.LAST_UPDATE_DATE, ItemEffBaseAuditEO.LAST_UPDATE_LOGIN, ItemEffBaseAuditEO.CHANGE_LINE_ID, ItemEffBaseAuditEO.VERSION_ID, ItemEffBaseAuditEO.VERSION_START_DATE, ItemEffBaseAuditEO.VERSION_END_DATE, ItemEffBaseAuditEO.IMPLEMENTATION_DATE, ItemEffBaseAuditEO.CHANGE_BIT_MAP, ItemEffBaseAuditEO.ACD_TYPE, ItemEffBaseAuditEO.ATTRIBUTE_CHAR1, ItemEffBaseAuditEO.ATTRIBUTE_CHAR2, ItemEffBaseAuditEO.ATTRIBUTE_CHAR3, ItemEffBaseAuditEO.ATTRIBUTE_CHAR4, ItemEffBaseAuditEO.ATTRIBUTE_CHAR5, ItemEffBaseAuditEO.ATTRIBUTE_CHAR6, ItemEffBaseAuditEO.ATTRIBUTE_CHAR7, ItemEffBaseAuditEO.ATTRIBUTE_CHAR8, ItemEffBaseAuditEO.ATTRIBUTE_CHAR9, ItemEffBaseAuditEO.ATTRIBUTE_CHAR10, ItemEffBaseAuditEO.ATTRIBUTE_CHAR11, ItemEffBaseAuditEO.ATTRIBUTE_CHAR12, ItemEffBaseAuditEO.ATTRIBUTE_CHAR13, ItemEffBaseAuditEO.ATTRIBUTE_CHAR14, ItemEffBaseAuditEO.ATTRIBUTE_CHAR15, ItemEffBaseAuditEO.ATTRIBUTE_CHAR16, ItemEffBaseAuditEO.ATTRIBUTE_CHAR17, ItemEffBaseAuditEO.ATTRIBUTE_CHAR18, ItemEffBaseAuditEO.ATTRIBUTE_CHAR19, ItemEffBaseAuditEO.ATTRIBUTE_CHAR20, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER1, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER2, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER3, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER4, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER5, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER6, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER7, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER8, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER9, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER10, ItemEffBaseAuditEO.ATTRIBUTE_CHAR21, ItemEffBaseAuditEO.ATTRIBUTE_CHAR22, ItemEffBaseAuditEO.ATTRIBUTE_CHAR23, ItemEffBaseAuditEO.ATTRIBUTE_CHAR24, ItemEffBaseAuditEO.ATTRIBUTE_CHAR25, ItemEffBaseAuditEO.ATTRIBUTE_CHAR26, ItemEffBaseAuditEO.ATTRIBUTE_CHAR27, ItemEffBaseAuditEO.ATTRIBUTE_CHAR28, ItemEffBaseAuditEO.ATTRIBUTE_CHAR29, ItemEffBaseAuditEO.ATTRIBUTE_CHAR30, ItemEffBaseAuditEO.ATTRIBUTE_CHAR31, ItemEffBaseAuditEO.ATTRIBUTE_CHAR32, ItemEffBaseAuditEO.ATTRIBUTE_CHAR33, ItemEffBaseAuditEO.ATTRIBUTE_CHAR34, ItemEffBaseAuditEO.ATTRIBUTE_CHAR35, ItemEffBaseAuditEO.ATTRIBUTE_CHAR36, ItemEffBaseAuditEO.ATTRIBUTE_CHAR37, ItemEffBaseAuditEO.ATTRIBUTE_CHAR38, ItemEffBaseAuditEO.ATTRIBUTE_CHAR39, ItemEffBaseAuditEO.ATTRIBUTE_CHAR40, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER11, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER12, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER13, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER14, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER15, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER16, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER17, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER18, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER19, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER20, ItemEffBaseAuditEO.PROGRAM_NAME, ItemEffBaseAuditEO.PROGRAM_APP_NAME, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP1, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP2, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP3, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP4, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP5, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP6, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP7, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP8, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP9, ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP10, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER1_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER2_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER3_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER4_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER5_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER6_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER7_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER8_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER9_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER10_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER11_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER12_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER13_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER14_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER15_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER16_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER17_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER18_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER19_UOM, ItemEffBaseAuditEO.ATTRIBUTE_NUMBER20_UOM, ItemEffBaseAuditEO.ATTRIBUTE_DATE1, ItemEffBaseAuditEO.ATTRIBUTE_DATE2, ItemEffBaseAuditEO.ATTRIBUTE_DATE3, ItemEffBaseAuditEO.ATTRIBUTE_DATE4, ItemEffBaseAuditEO.ATTRIBUTE_DATE5, ItemEffBaseAuditEO.ATTRIBUTE_DATE6, ItemEffBaseAuditEO.ATTRIBUTE_DATE7, ItemEffBaseAuditEO.ATTRIBUTE_DATE8, ItemEffBaseAuditEO.ATTRIBUTE_DATE9, ItemEffBaseAuditEO.ATTRIBUTE_DATE10, ItemEffBaseAuditEO.REQUEST_ID FROM EGO_ITEM_EFF_B_ ItemEffBaseAuditEO WHERE ItemEffBaseAuditEO.AUDIT_ACTION_TYPE_ = 'DELETE' )

SQL_Statement

SELECT

ItemEffBaseEO.EFF_LINE_ID,

ItemEffBaseEO.CATEGORY_CODE,

ItemEffBaseEO.OBJECT_VERSION_NUMBER,

ItemEffBaseEO.ORGANIZATION_ID,

ItemEffBaseEO.INVENTORY_ITEM_ID,

ItemEffBaseEO.CONTEXT_CODE,

ItemEffBaseEO.CREATED_BY,

ItemEffBaseEO.CREATION_DATE,

ItemEffBaseEO.LAST_UPDATED_BY,

ItemEffBaseEO.LAST_UPDATE_DATE,

ItemEffBaseEO.LAST_UPDATE_LOGIN,

ItemEffBaseEO.CHANGE_LINE_ID,

ItemEffBaseEO.VERSION_ID,

ItemEffBaseEO.VERSION_START_DATE,

ItemEffBaseEO.VERSION_END_DATE,

ItemEffBaseEO.IMPLEMENTATION_DATE,

ItemEffBaseEO.CHANGE_BIT_MAP,

ItemEffBaseEO.ACD_TYPE,

ItemEffBaseEO.ATTRIBUTE_CHAR1,

ItemEffBaseEO.ATTRIBUTE_CHAR2,

ItemEffBaseEO.ATTRIBUTE_CHAR3,

ItemEffBaseEO.ATTRIBUTE_CHAR4,

ItemEffBaseEO.ATTRIBUTE_CHAR5,

ItemEffBaseEO.ATTRIBUTE_CHAR6,

ItemEffBaseEO.ATTRIBUTE_CHAR7,

ItemEffBaseEO.ATTRIBUTE_CHAR8,

ItemEffBaseEO.ATTRIBUTE_CHAR9,

ItemEffBaseEO.ATTRIBUTE_CHAR10,

ItemEffBaseEO.ATTRIBUTE_CHAR11,

ItemEffBaseEO.ATTRIBUTE_CHAR12,

ItemEffBaseEO.ATTRIBUTE_CHAR13,

ItemEffBaseEO.ATTRIBUTE_CHAR14,

ItemEffBaseEO.ATTRIBUTE_CHAR15,

ItemEffBaseEO.ATTRIBUTE_CHAR16,

ItemEffBaseEO.ATTRIBUTE_CHAR17,

ItemEffBaseEO.ATTRIBUTE_CHAR18,

ItemEffBaseEO.ATTRIBUTE_CHAR19,

ItemEffBaseEO.ATTRIBUTE_CHAR20,

ItemEffBaseEO.ATTRIBUTE_NUMBER1,

ItemEffBaseEO.ATTRIBUTE_NUMBER2,

ItemEffBaseEO.ATTRIBUTE_NUMBER3,

ItemEffBaseEO.ATTRIBUTE_NUMBER4,

ItemEffBaseEO.ATTRIBUTE_NUMBER5,

ItemEffBaseEO.ATTRIBUTE_NUMBER6,

ItemEffBaseEO.ATTRIBUTE_NUMBER7,

ItemEffBaseEO.ATTRIBUTE_NUMBER8,

ItemEffBaseEO.ATTRIBUTE_NUMBER9,

ItemEffBaseEO.ATTRIBUTE_NUMBER10,

ItemEffBaseEO.ATTRIBUTE_CHAR21,

ItemEffBaseEO.ATTRIBUTE_CHAR22,

ItemEffBaseEO.ATTRIBUTE_CHAR23,

ItemEffBaseEO.ATTRIBUTE_CHAR24,

ItemEffBaseEO.ATTRIBUTE_CHAR25,

ItemEffBaseEO.ATTRIBUTE_CHAR26,

ItemEffBaseEO.ATTRIBUTE_CHAR27,

ItemEffBaseEO.ATTRIBUTE_CHAR28,

ItemEffBaseEO.ATTRIBUTE_CHAR29,

ItemEffBaseEO.ATTRIBUTE_CHAR30,

ItemEffBaseEO.ATTRIBUTE_CHAR31,

ItemEffBaseEO.ATTRIBUTE_CHAR32,

ItemEffBaseEO.ATTRIBUTE_CHAR33,

ItemEffBaseEO.ATTRIBUTE_CHAR34,

ItemEffBaseEO.ATTRIBUTE_CHAR35,

ItemEffBaseEO.ATTRIBUTE_CHAR36,

ItemEffBaseEO.ATTRIBUTE_CHAR37,

ItemEffBaseEO.ATTRIBUTE_CHAR38,

ItemEffBaseEO.ATTRIBUTE_CHAR39,

ItemEffBaseEO.ATTRIBUTE_CHAR40,

ItemEffBaseEO.ATTRIBUTE_NUMBER11,

ItemEffBaseEO.ATTRIBUTE_NUMBER12,

ItemEffBaseEO.ATTRIBUTE_NUMBER13,

ItemEffBaseEO.ATTRIBUTE_NUMBER14,

ItemEffBaseEO.ATTRIBUTE_NUMBER15,

ItemEffBaseEO.ATTRIBUTE_NUMBER16,

ItemEffBaseEO.ATTRIBUTE_NUMBER17,

ItemEffBaseEO.ATTRIBUTE_NUMBER18,

ItemEffBaseEO.ATTRIBUTE_NUMBER19,

ItemEffBaseEO.ATTRIBUTE_NUMBER20,

ItemEffBaseEO.PROGRAM_NAME,

ItemEffBaseEO.PROGRAM_APP_NAME,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP1,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP2,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP3,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP4,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP5,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP6,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP7,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP8,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP9,

ItemEffBaseEO.ATTRIBUTE_TIMESTAMP10,

ItemEffBaseEO.ATTRIBUTE_NUMBER1_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER2_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER3_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER4_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER5_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER6_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER7_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER8_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER9_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER10_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER11_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER12_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER13_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER14_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER15_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER16_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER17_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER18_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER19_UOM,

ItemEffBaseEO.ATTRIBUTE_NUMBER20_UOM,

ItemEffBaseEO.ATTRIBUTE_DATE1,

ItemEffBaseEO.ATTRIBUTE_DATE2,

ItemEffBaseEO.ATTRIBUTE_DATE3,

ItemEffBaseEO.ATTRIBUTE_DATE4,

ItemEffBaseEO.ATTRIBUTE_DATE5,

ItemEffBaseEO.ATTRIBUTE_DATE6,

ItemEffBaseEO.ATTRIBUTE_DATE7,

ItemEffBaseEO.ATTRIBUTE_DATE8,

ItemEffBaseEO.ATTRIBUTE_DATE9,

ItemEffBaseEO.ATTRIBUTE_DATE10,

ItemEffBaseEO.REQUEST_ID

FROM EGO_ITEM_EFF_B ItemEffBaseEO

UNION

(SELECT

ItemEffBaseAuditEO.EFF_LINE_ID,

ItemEffBaseAuditEO.CATEGORY_CODE,

ItemEffBaseAuditEO.OBJECT_VERSION_NUMBER,

ItemEffBaseAuditEO.ORGANIZATION_ID,

ItemEffBaseAuditEO.INVENTORY_ITEM_ID,

ItemEffBaseAuditEO.CONTEXT_CODE,

ItemEffBaseAuditEO.CREATED_BY,

ItemEffBaseAuditEO.CREATION_DATE,

ItemEffBaseAuditEO.LAST_UPDATED_BY,

ItemEffBaseAuditEO.LAST_UPDATE_DATE,

ItemEffBaseAuditEO.LAST_UPDATE_LOGIN,

ItemEffBaseAuditEO.CHANGE_LINE_ID,

ItemEffBaseAuditEO.VERSION_ID,

ItemEffBaseAuditEO.VERSION_START_DATE,

ItemEffBaseAuditEO.VERSION_END_DATE,

ItemEffBaseAuditEO.IMPLEMENTATION_DATE,

ItemEffBaseAuditEO.CHANGE_BIT_MAP,

ItemEffBaseAuditEO.ACD_TYPE,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR1,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR2,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR3,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR4,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR5,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR6,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR7,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR8,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR9,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR10,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR11,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR12,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR13,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR14,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR15,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR16,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR17,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR18,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR19,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR20,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER1,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER2,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER3,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER4,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER5,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER6,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER7,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER8,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER9,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER10,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR21,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR22,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR23,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR24,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR25,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR26,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR27,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR28,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR29,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR30,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR31,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR32,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR33,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR34,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR35,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR36,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR37,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR38,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR39,

ItemEffBaseAuditEO.ATTRIBUTE_CHAR40,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER11,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER12,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER13,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER14,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER15,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER16,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER17,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER18,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER19,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER20,

ItemEffBaseAuditEO.PROGRAM_NAME,

ItemEffBaseAuditEO.PROGRAM_APP_NAME,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP1,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP2,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP3,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP4,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP5,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP6,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP7,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP8,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP9,

ItemEffBaseAuditEO.ATTRIBUTE_TIMESTAMP10,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER1_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER2_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER3_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER4_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER5_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER6_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER7_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER8_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER9_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER10_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER11_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER12_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER13_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER14_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER15_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER16_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER17_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER18_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER19_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_NUMBER20_UOM,

ItemEffBaseAuditEO.ATTRIBUTE_DATE1,

ItemEffBaseAuditEO.ATTRIBUTE_DATE2,

ItemEffBaseAuditEO.ATTRIBUTE_DATE3,

ItemEffBaseAuditEO.ATTRIBUTE_DATE4,

ItemEffBaseAuditEO.ATTRIBUTE_DATE5,

ItemEffBaseAuditEO.ATTRIBUTE_DATE6,

ItemEffBaseAuditEO.ATTRIBUTE_DATE7,

ItemEffBaseAuditEO.ATTRIBUTE_DATE8,

ItemEffBaseAuditEO.ATTRIBUTE_DATE9,

ItemEffBaseAuditEO.ATTRIBUTE_DATE10,

ItemEffBaseAuditEO.REQUEST_ID

FROM EGO_ITEM_EFF_B_ ItemEffBaseAuditEO

WHERE ItemEffBaseAuditEO.AUDIT_ACTION_TYPE_ = 'DELETE'

)