1. Tables and Views for SCM
  2. INV_SUBINV_MAINT_DETAILS

INV_SUBINV_MAINT_DETAILS

INV_SUBINV_MAINT_DETAILS stores details of the mass create or update action taken for the subinventory object. 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 subinventory for which the action is to be performed in this table.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

inv_subinv_maint_details_PK

INV_SUBINV_MAINT_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
INV_SUBINV_MAINT_DETAIL_ID NUMBER 18 Yes This is the Primary Key for the subinventory maintenace details table.
MASS_MAINT_ACTION_ID NUMBER 18 Yes The foreign key to the INV_SUBINV_MASS_MAINT_ACTION.
ORGANIZATION_ID NUMBER 18 Value that uniquely identifies the organization.
ORGANIZATION_CODE VARCHAR2 18 Abbreviation that identifies the inventory organization code.
SECONDARY_INVENTORY_NAME VARCHAR2 10 Yes Name that identifies the subinventory.
SUBINVENTORY_TYPE_CODE VARCHAR2 30 Value that identifies subinventory type.
SUBINVENTORY_TYPE_NAME VARCHAR2 80 Name that identifies subinventory type.
STRUCTURE_INSTANCE_NUMBER NUMBER 18 Value that uniquely identifies Structure instance number of the locator key field.
STRUCTURE_INSTANCE_NAME VARCHAR2 60 Name that uniquely identifies Structure instance number of the locator key field.
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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
DESCRIPTION VARCHAR2 50 This is description of the subinventory.
DISABLE_DATE VARCHAR2 20 Date after which subinventory is disabled.
LOCATOR_TYPE VARCHAR2 80 Name that uniquely identifies Subinventory-level stock locator control type.
LOCATOR_TYPE_CODE VARCHAR2 30 Value that uniquely identified Subinventory-level stock locator control type.
PICKING_ORDER NUMBER Value that sets the order of picking.
QUANTITY_TRACKED NUMBER Code that indicates whether the onhand item quantity is recorded.
QUANTITY_TRACKED_MEANING VARCHAR2 80 Value that indicates whether the onhand item quantity is recorded.
ASSET_INVENTORY NUMBER Code that identifies whether the items contained within the subinventory are regarded as assets.
ASSET_INVENTORY_MEANING VARCHAR2 80 Value that identifies whether the items contained within the subinventory regarded are as assets.
DEPRECIABLE_FLAG NUMBER Code that indicates whether the subinventory is depreciable.
DEPRECIABLE_FLAG_MEANING VARCHAR2 80 Value that indicates whether the subinventory is depreciable.
SOURCE_TYPE_CODE VARCHAR2 30 Abbreviation that identifies Inventory or Supplier sourcing type.
SOURCE_TYPE_NAME VARCHAR2 80 Name that identifies Inventory or Supplier sourcing type.
SOURCE_SUBINVENTORY VARCHAR2 10 Name that identifies subinventory to source the items from.
SOURCE_ORGANIZATION_ID NUMBER 18 Value that uniquely identifies organization to source items from.
SOURCE_ORGANIZATION_NAME VARCHAR2 240 Name that identifies organization to source items from.
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.
LOCATION_ID NUMBER 18 Value that uniquely identifies the locator.
LOCATION_NAME VARCHAR2 240 Name that represents concatenation of Location Name and Alternate Location Code.
STATUS_ID NUMBER 18 Value that uniquely identifies the material status.
STATUS_CODE VARCHAR2 80 Name that identifies the material status.
DEFAULT_LOC_STATUS_ID NUMBER 18 Value that uniquely identifies status ID for locators - Used by WMS only.
DEFAULT_LOC_STATUS_CODE VARCHAR2 80 Abbreviation that identifies Default status name for locations - Used by WMS only.
PLANNING_LEVEL NUMBER Code that indicates whether PAR level planning is enabled.
PLANNING_LEVEL_MEANING VARCHAR2 80 Value that indicates whether PAR level planning is enabled.
DEFAULT_COUNT_TYPE_CODE VARCHAR2 30 Value that indicates the replenishment count type code.
DEFAULT_COUNT_TYPE_NAME VARCHAR2 80 Name that indicates the replenishment count type.
FILL_KILL_TO_LOOKUP_CODE VARCHAR2 30 Value that determines if remaining quantities on transfer order lines will be cancelled during pick release, pick confirm and ship confirm processing.
FILL_KILL_TO_LOOKUP_NAME VARCHAR2 80 Name that determines if remaining quantities on transfer order lines will be cancelled during pick release, pick confirm and ship confirm processing.
COUNT_METHOD_CODE VARCHAR2 30 Value that indicates the PAR Replenishment Count Method. Count method Values:Two-Bin,Request,Count.
COUNT_METHOD_NAME VARCHAR2 80 Name that indicates the PAR Replenishment Count Method. Count method Values:Two-Bin,Request,Count.
SUBINVENTORY_GROUP VARCHAR2 100 The name of the Subinventory Group.
PROCESSING_STATUS_CODE VARCHAR2 30 Yes Shows the status whether this is processed/not processed/errored record.
INVENTORY_ATP_CODE NUMBER 9 Inventory available to promise code.
AVAILABILITY_TYPE NUMBER 9 This code indicates subinventory availability.
RESERVABLE_TYPE NUMBER 9 Indicates hard reservation eligibility.
ERROR_CODE VARCHAR2 30 Error message code for the failure during create or update action for the subinventory.
ERROR_EXPLANATION VARCHAR2 240 Error message text for the failure during create or update action for the subinventory.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
INV_SUBINV_MAINT_DETAILS_N1 Non Unique Default MASS_MAINT_ACTION_ID
INV_SUBINV_MAINT_DETAILS_N2 Non Unique Default PROCESSING_STATUS_CODE, MASS_MAINT_ACTION_ID
INV_SUBINV_MAINT_DETAILS_U1 Unique Default INV_SUBINV_MAINT_DETAIL_ID