1. Tables and Views for SCM
  2. INV_SERIAL_UPDATE_DRAFT

INV_SERIAL_UPDATE_DRAFT

The table inv_serial_update_draft represents the updates made to an inventory serial number and submitted for approval via Electronic Records and Electronic Signature framework. When a serial number is submitted for approval, a new record is inserted into this table with a unique value for electronic record identifier, the serial number being updated, and the values for all the updateable attributes. On approval, the values are copied from this table to inv_serial_numbers and the draft row is deleted. On rejection, no change is propagated to inv_serial_numbers and the draft row is deleted.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_SERIAL_UPDATE_DRAFT_PK

ERECORD_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID, CURRENT_ORGANIZATION_ID

Columns

Name Datatype Length Precision Not-null Comments
ERECORD_ID NUMBER 18 Yes This column stores the unique identifier of the electronic record.
INVENTORY_ITEM_ID NUMBER 18 Yes This column stores the unique identifier of the inventory item.
SERIAL_NUMBER VARCHAR2 80 Yes This column stores the item unit number.
CURRENT_ORGANIZATION_ID NUMBER 18 Yes This column stores the unique identifier of the inventory organization where the serial number is currently stored.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ERES_APPROVAL_STATUS VARCHAR2 80 Yes This column stores the approval status of the electronic record.
ORIGINAL_UNIT_VENDOR_ID NUMBER 18 This column identifies the original unit supplier.
VENDOR_SERIAL_NUMBER VARCHAR2 80 This column stores the serial number provided by the supplier.
VENDOR_LOT_NUMBER VARCHAR2 30 This column stores the lot number provided by the supplier.
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 30 This column defines the structure of the serial attributes descriptive flexfield.
TERRITORY_CODE VARCHAR2 30 This column stores the country of origin for the serial number.
C_ATTRIBUTE1 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE2 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE3 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE4 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE5 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE6 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE7 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE8 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE9 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE10 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE11 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE12 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE13 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE14 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE15 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE16 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE17 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE18 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE19 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
C_ATTRIBUTE20 VARCHAR2 150 Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE1 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE2 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE3 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE4 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE5 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE6 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE7 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE8 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE9 DATE Serial Attributes Descriptive flexfield segment.
D_ATTRIBUTE10 DATE Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE1 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE2 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE3 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE4 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE5 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE6 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE7 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE8 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE9 NUMBER Serial Attributes Descriptive flexfield segment.
N_ATTRIBUTE10 NUMBER Serial Attributes Descriptive flexfield segment.
T_ATTRIBUTE1 TIMESTAMP Serial Attributes Descriptive flexfield segment.
T_ATTRIBUTE2 TIMESTAMP Serial Attributes Descriptive flexfield segment.
T_ATTRIBUTE3 TIMESTAMP Serial Attributes Descriptive flexfield segment.
T_ATTRIBUTE4 TIMESTAMP Serial Attributes Descriptive flexfield segment.
T_ATTRIBUTE5 TIMESTAMP Serial Attributes Descriptive flexfield segment.
STATUS_ID NUMBER 18 This column stores the unique identifier of the material status of the serial number.
TIME_SINCE_NEW NUMBER This column stores the days since the serial number was created.
CYCLES_SINCE_NEW NUMBER This column stores the number of cycles since the serial number was created.
TIME_SINCE_OVERHAUL NUMBER This column stores the days since the last overhaul.
CYCLES_SINCE_OVERHAUL NUMBER This column stores the number of cycles since the last overhaul.
TIME_SINCE_REPAIR NUMBER This column stores the days since the last repair.
CYCLES_SINCE_REPAIR NUMBER This column stores the number of cycles since the last repair.
TIME_SINCE_VISIT NUMBER This column stores the days since the last visit.
CYCLES_SINCE_VISIT NUMBER This column stores the number of cycles since the last visit.
TIME_SINCE_MARK NUMBER This column stores the days since the last time the serial was marked.
CYCLES_SINCE_MARK NUMBER This column stores the time since the last time the serial was marked.
NUMBER_OF_REPAIRS NUMBER This column stores the number of repairs performed.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
INV_SERIAL_UPDATE_DRAFT inv_serial_numbers CURRENT_ORGANIZATION_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID
INV_SERIAL_UPDATE_DRAFT egp_item_org_associations CURRENT_ORGANIZATION_ID, INVENTORY_ITEM_ID

Indexes

Index Uniqueness Tablespace Columns
INV_SERIAL_UPDATE_DRAFT_U1 Unique Default ERECORD_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID, CURRENT_ORGANIZATION_ID