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. | ||
ORACLE_HEALTH_LOCATION | VARCHAR2 | 1 | Code that indicates whether the subinventory is an oracle health location. Possible values are Y or N. | ||
ORACLE_HEALTH_LOCATION_MEANING | VARCHAR2 | 20 | Value that indicates whether the subinventory is an oracle health location. Possible values are Yes or No. |
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 |