1. Tables and Views for SCM
  2. INV_MATERIAL_STATUS_HISTORY

INV_MATERIAL_STATUS_HISTORY

INV_MATERIAL_STATUS_HISTORY stores the status update history for subinventory, locator, lot and serial.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_MTL_STATUS_HIST_PK

STATUS_UPDATE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
STATUS_UPDATE_ID NUMBER 18 Yes Primary key of the inventory status history. Active
ORGANIZATION_ID NUMBER 18 Yes This identifies the inventory organization. Active
INVENTORY_ITEM_ID NUMBER 18 This identifies the inventory item. Active
LOT_NUMBER VARCHAR2 80 This number identifies an inventory lot. Active
SERIAL_NUMBER VARCHAR2 80 This stores the item unit number. Active
UPDATE_METHOD NUMBER 18 Yes Indicates the lot grade update method. Active
STATUS_ID NUMBER 18 Yes This identifies the inventory status. Active
ZONE_CODE VARCHAR2 10 This is name of the subinventory. Active
LOCATOR_ID NUMBER 18 This identifies the item locator. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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_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
UPDATE_REASON_ID NUMBER This identifies the update reason. Active
INITIAL_STATUS_FLAG VARCHAR2 1 If this column is 'Y', it indicates that this is the initial status of object. Active
FROM_MOBILE_APPS_FLAG VARCHAR2 1 If this column is 'Y', it indicates that the status is updated from Mobile Applications. Active
GRADE_CODE VARCHAR2 150 This code indicates the lot grade. Active
PRIMARY_ONHAND NUMBER This is the primary onhand quantity. Active
SECONDARY_ONHAND NUMBER This is the secondary onhand quantity. Active
AVAILABILITY_TYPE NUMBER 9 Inventory available to promise code Active
INVENTORY_ATP_CODE NUMBER 9 Code indicates subinventory available to promise. Active
RESERVABLE_TYPE NUMBER 9 Indicates hard reservation eligibility. Active
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_MATERIAL_STATUS_HISTORY inv_material_statuses_b STATUS_ID
INV_MATERIAL_STATUS_HISTORY inv_secondary_inventories ZONE_CODE, ORGANIZATION_ID
INV_MATERIAL_STATUS_HISTORY inv_item_locations LOCATOR_ID
INV_MATERIAL_STATUS_HISTORY inv_lot_numbers INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER
INV_MATERIAL_STATUS_HISTORY inv_serial_numbers ORGANIZATION_ID, INVENTORY_ITEM_ID, SERIAL_NUMBER
INV_MATERIAL_STATUS_HISTORY inv_transaction_reasons_b UPDATE_REASON_ID

Indexes

Index Uniqueness Tablespace Columns
INV_MTL_STATUS_HIST_N1 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, INVENTORY_ITEM_ID, LOT_NUMBER
INV_MTL_STATUS_HIST_N2 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, INVENTORY_ITEM_ID, SERIAL_NUMBER
INV_MTL_STATUS_HIST_N3 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, ZONE_CODE
INV_MTL_STATUS_HIST_N4 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, LOCATOR_ID
INV_MTL_STATUS_HIST_U1 Unique FUSION_TS_TX_IDX STATUS_UPDATE_ID