1. Tables and Views for SCM
  2. EGO_ITEM_REVISION_EFF_B

EGO_ITEM_REVISION_EFF_B

Item Revision EFF table holds the attribute group data.

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

EGO_ITEM_REVISION_EFF_B_PK

EFF_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
EFF_LINE_ID NUMBER 18 Yes Stores the Unique identifier for the row Active
CATEGORY_CODE VARCHAR2 800 Yes Stores the Item Class associated with the item.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
ORGANIZATION_ID NUMBER 18 Yes A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. Active
INVENTORY_ITEM_ID NUMBER 18 Yes Stores the Unique identifier for an item. Active
REVISION_ID NUMBER 18 Yes Stores the Unique identifier of a revision. Active
CHANGE_LINE_ID NUMBER 18 Yes Stores the unique identifier for a change line. Active
VERSION_ID NUMBER 18 Yes Version number to identify a version uniquely within a revision Active
VERSION_START_DATE DATE Yes Date when new version is set to be effective Active
VERSION_END_DATE DATE Date after which the version will no longer remain effective. Active
IMPLEMENTATION_DATE DATE The date on which the change in the item will be implemented. Active
CHANGE_BIT_MAP VARCHAR2 200 Yes Stores the bitmap representation for attributes which are changed through the row. Active
ACD_TYPE VARCHAR2 30 Yes Refers to the type of modification made to an object, such as add, update or delete. Active
CONTEXT_CODE VARCHAR2 80 Yes Internal Name of Attributes.This is displayed as a label for a text field. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CHAR1 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR16 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR17 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR18 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR19 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR20 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR21 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR22 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR23 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR24 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR25 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR26 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR27 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR28 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR29 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR30 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR31 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR32 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR33 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR34 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR35 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR36 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR37 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR38 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR39 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR40 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program. Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request. Active
ATTRIBUTE_NUMBER1_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER1
ATTRIBUTE_NUMBER2_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER2
ATTRIBUTE_NUMBER3_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER3
ATTRIBUTE_NUMBER4_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER4
ATTRIBUTE_NUMBER5_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER5
ATTRIBUTE_NUMBER6_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER6
ATTRIBUTE_NUMBER7_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER7
ATTRIBUTE_NUMBER8_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER8
ATTRIBUTE_NUMBER9_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER9
ATTRIBUTE_NUMBER10_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER10
ATTRIBUTE_NUMBER11_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER11
ATTRIBUTE_NUMBER12_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER12
ATTRIBUTE_NUMBER13_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER13
ATTRIBUTE_NUMBER14_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER14
ATTRIBUTE_NUMBER15_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER15
ATTRIBUTE_NUMBER16_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER16
ATTRIBUTE_NUMBER17_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER17
ATTRIBUTE_NUMBER18_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER18
ATTRIBUTE_NUMBER19_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER19
ATTRIBUTE_NUMBER20_UOM VARCHAR2 9 UOM Attribute for ATTRIBUTE_NUMBER20
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
EGO_ITEM_REVISION_EFF_B egp_item_revisions_b REVISION_ID
EGO_ITEM_REVISION_EFF_B ego_versions_b VERSION_ID

Indexes

Index Uniqueness Tablespace Columns Status
EGO_ITEM_REVISION_EFF_B_N1 Non Unique FUSION_TS_TX_DATA ORGANIZATION_ID, INVENTORY_ITEM_ID, REVISION_ID, CONTEXT_CODE Active
EGO_ITEM_REVISION_EFF_B_N2 Non Unique Default LAST_UPDATE_DATE
EGO_ITEM_REVISION_EFF_B_U1 Unique FUSION_TS_TX_DATA EFF_LINE_ID, VERSION_START_DATE, CHANGE_LINE_ID Active
EGO_ITEM_REVISION_EFF_B_U2 Unique FUSION_TS_TX_DATA EFF_LINE_ID, CHANGE_LINE_ID, VERSION_ID, ACD_TYPE Active
EGO_ITEM_REVISION_EFF_B_U3 Unique Default EFF_LINE_ID