1. Tables and Views for SCM
  2. INV_ITEM_SUB_MAINT_DETAILS

INV_ITEM_SUB_MAINT_DETAILS

This table is the detail level table which will detail the mass update/create action taken for the Item Subinventory association. There will be one row denoting the action taken and the object on which the action is taken in the INV_SUBINV_MASS_MAINT_ACTION table and the details of each Item Subinventory association for which the action is to be performed in this table.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

inv_item_sub_maint_details_PK

ITEM_SUB_MAINT_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
ITEM_SUB_MAINT_DETAIL_ID NUMBER 18 Yes Primary key to uniquely identify the item subinventory maintenance detail id.
MASS_MAINT_ACTION_ID NUMBER 18 Yes The foreign key to the INV_SUBINV_MASS_MAINT_ACTION table.
INVENTORY_ITEM_ID NUMBER 18 Value that uniquely identifies the inventory item.
ITEM_NUMBER VARCHAR2 300 Name that identifies the inventory item.
ORGANIZATION_ID NUMBER 18 Value that uniquely identifies the organization.
ORGANIZATION_CODE VARCHAR2 18 Code that identifies the inventory organization.
SECONDARY_INVENTORY VARCHAR2 10 Yes Name that identifies the subinventory.
PROCESSING_STATUS_CODE VARCHAR2 80 Yes Shows the status whether this is processed/not processed/errored record.
ERROR_CODE VARCHAR2 30 Error message code for the failure during maintenance action for item-subinventory association.
ERROR_EXPLANATION VARCHAR2 240 Error message text for the failure during maintenance action for item-subinventory association.
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.
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.
MINMAX_QUANTITY_UOM VARCHAR2 3 Abbreviation that identifies the minmax quantity uom.
MINMAX_QTY_UNIT_OF_MEASURE VARCHAR2 25 Name that identifies the minmax quantity uom.
MIN_MINMAX_QUANTITY NUMBER Subinventory-level minmax planning minimum quantity.
MAX_MINMAX_QUANTITY NUMBER Subinventory-level minmax planning maximum quantity.
INVENTORY_PLANNING_CODE NUMBER 9 Value that identifies the item planning method.
INVENTORY_PLANNING_MEANING VARCHAR2 80 Name that indicates the item planning method.
FIXED_LOT_MULTIPLE NUMBER 9 Subinventory-level fixed lot multiple.
MINIMUM_ORDER_QUANTITY NUMBER Subinventory-level minimum order quantity.
MAXIMUM_ORDER_QUANTITY NUMBER Subinventory-level maximum order quantity.
SOURCE_TYPE VARCHAR2 30 Value that identifies the inventory or supplier source type.
SOURCE_TYPE_MEANING VARCHAR2 80 Name that identifies the inventory or supplier source type.
SOURCE_ORGANIZATION_ID NUMBER 18 Value that identifies the organization to source items from.
SOURCE_ORGANIZATION_NAME VARCHAR2 240 Name that identifies the organization to source items from.
SOURCE_SUBINVENTORY VARCHAR2 10 Value that identifies the subinventory to source items from.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PREPROCESSING_LEAD_TIME NUMBER This is the lead time for pre-processing.
PROCESSING_LEAD_TIME NUMBER This is the lead time for processing.
POSTPROCESSING_LEAD_TIME NUMBER This is the lead time for post-processing.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PAR_LEVEL NUMBER Level at with the quantity should be stocked. If the count falls below this quantity, it is used to calculate the re-order quantity(if the PAR Maximum Quantity is not specified).
PAR_UOM_CODE VARCHAR2 3 Value that indicates the PAR level unit of measure associated with the item. This value will automatically default based on the item entered.
PAR_UNIT_OF_MEASURE VARCHAR2 25 Name that indicates the PAR level unit of measure associated with the item. This value will automatically default based on the item entered.
DEFAULT_COUNT_TYPE_CODE VARCHAR2 30 Value that indicates the replenishment count type. Values include Order PAR, On-Hand Quantity, and Order Quantity. If this field is not specified, the Default Replenishment Count Type specified for the subinventory will be used.
DEFAULT_COUNT_TYPE_NAME VARCHAR2 80 Name that indicates the replenishment count type. Values include Order PAR, On-Hand Quantity, and Order Quantity. If this field is not specified, the Default Replenishment Count Type specified for the subinventory will be used.
PAR_MAX_QTY NUMBER If the count falls below the PAR level, this value is used to calculate the re-order quantity. If not specified, the PAR level will be used.
COUNT_REQUIRED VARCHAR2 1 Indicates the item in the PAR location must be counted.
QTY_COUNT_TOLERANCE NUMBER Use this field to define the allowed count tolerance to be used before the system will not allow the count. This prevents data entry mistakes when counting and over-ordering on replenishment requests.

Indexes

Index Uniqueness Tablespace Columns
INV_ITEM_SUB_MAINT_DETAILS_N1 Non Unique FUSION_TS_TX_DATA MASS_MAINT_ACTION_ID
INV_ITEM_SUB_MAINT_DETAILS_N2 Non Unique FUSION_TS_TX_DATA PROCESSING_STATUS_CODE, MASS_MAINT_ACTION_ID
INV_ITEM_SUB_MAINT_DETAILS_U1 Unique FUSION_TS_TX_DATA ITEM_SUB_MAINT_DETAIL_ID