1. Tables and Views for SCM
  2. EGP_ITEM_REVISIONS_B_

EGP_ITEM_REVISIONS_B_

This ia an audit table, which stores revision data for an item.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

EGP_ITEM_REVISIONS_B_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, REVISION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INVENTORY_ITEM_ID NUMBER 18 Attribute indicating the unique identifier of the item. Active
ORGANIZATION_ID NUMBER 18 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
REVISION_ID NUMBER 18 Yes Identifies the revision of an item. Active
REVISION VARCHAR2 18 Code identifying the Item Revision Active
EFFECTIVITY_DATE DATE Date on which the item revision is scheduled to be effective Active
OBJECT_VERSION_NUMBER NUMBER 9 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
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ECN_INITIATION_DATE DATE Attribute indicating the change order implementation date thorugh which the revision was created Active
IMPLEMENTATION_DATE DATE Date on which the item revision is scheduled to be implemented Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
CHANGE_LINE_ID NUMBER 18 A unique identifier of a change order. Active
DESCRIPTION VARCHAR2 240 No longer used - DESCRIPTION column is now in the MTL_ITEM_REVISIONS_TL table Active
REVISION_REASON VARCHAR2 30 Attribute indicating the reason which necessitated the New Revision of the Item. Active
CURRENT_PHASE_ID NUMBER 18 Each phase represents a set of tasks and deliverables that are required before promoting the object to the next phase of the Item Lifecycle. For example, the life cycle phases for a computer component life cycle might be: Concept, Design, Prototype, Preproduction, Production, and Retirement. Active
END_EFFECTIVITY_DATE DATE Date on which the item revision is scheduled to stop being effective Active
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
ALT_REVISION_CODE VARCHAR2 40 Substitute identifier for Item revision code Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
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_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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Attribute indicating the original impersonator user

Indexes

Index Uniqueness Tablespace Columns Status
EGP_ITEM_REVISIONS_BN1_ Non Unique Default REVISION_ID
EGP_ITEM_REVISIONS_B_N2_ Non Unique Default AUDIT_ACTION_TYPE_, REQUEST_ID
EGP_ITEM_REVISIONS_B_PK_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, REVISION_ID Active
EGP_ITEM_REVISIONS_B_U1_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION Active