INV_ITEM_SUB_INVENTORIES
INV_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item. . These subinventories make up the list of valid subinventories when transacting this specific item and the user has specified (in the master window) that the item must use subinventories restricted to a pre-defined list.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ITEM_SUB_INVS_PK |
INVENTORY_ITEM_ID, ORGANIZATION_ID, SECONDARY_INVENTORY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | ||
| SECONDARY_INVENTORY | VARCHAR2 | 10 | Yes | This is the name of the subinventory. | ||
| 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. | |||
| PRIMARY_SUBINVENTORY_FLAG | NUMBER | 9 | This code indicates if the subinventory is primary or secondary. | |||
| PICKING_ORDER | NUMBER | This sets the order of picking. | ||||
| MINMAX_QUANTITY_UOM | VARCHAR2 | 3 | This indentifies 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 | Yes | This code 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 | Inventory or supplier source type | |||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Organization to source items from | |||
| SOURCE_SUBINVENTORY | VARCHAR2 | 10 | Subinventory to source items from | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Item Subinventories (INV_ITEM_SUB_INVENTORIES) | ||
| 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 | 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 | 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. | ||||
| LAST_REPLENISHED_DATE | TIMESTAMP | Datetime when the item is replenished during a PAR count. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_ITEM_SUB_INVENTORIES | inv_secondary_inventories | SECONDARY_INVENTORY, ORGANIZATION_ID |
| INV_ITEM_SUB_INVENTORIES | egp_item_org_associations | INVENTORY_ITEM_ID, ORGANIZATION_ID |
| INV_ITEM_SUB_INVENTORIES | inv_secondary_inventories | SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID |
| INV_ITEM_SUB_INVENTORIES | inv_org_parameters | SOURCE_ORGANIZATION_ID |
| inv_secondary_locators | inv_item_sub_inventories | INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ITEM_SUB_INVS_N1 | Non Unique | Default | ORGANIZATION_ID, SECONDARY_INVENTORY, INVENTORY_PLANNING_CODE |
| INV_ITEM_SUB_INVS_U1 | Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, SECONDARY_INVENTORY |
| INV_ITEM_SUB_INVS_U2 | Unique | Default | ORGANIZATION_ID, SECONDARY_INVENTORY, INVENTORY_ITEM_ID |