INV_SECONDARY_INVENTORIES_
INV_SECONDARY_INVENTORIES is the definition table for the subinventory. A subinventory is a section of inventory, i.e., raw material, finished goods, etc. Subinventories are assigned to items (in a many to one relationship), indicating a list of valid places where this item will physically exist in inventory. . Other attributes include general ledger accounts, demand picking order, locator type, availability type, and reservable type. . You can also specify whether this subinventory is an expense or asset subinventory (ASSET_INVENTORY), or whether quantities are tracked (QUANTITY_TRACKED). .
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_SECONDARY_INVS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, SECONDARY_INVENTORY_NAME, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SECONDARY_INVENTORY_NAME | VARCHAR2 | 10 | Yes | This is the name of the subinventory. | |
| STANDARD_PACK_TYPE | VARCHAR2 | 3 | This indicates the type of standard pack. | ||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Structure instance number of the locator key field. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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 | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | 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. | ||
| DESCRIPTION | VARCHAR2 | 50 | This is description of the subinventory. | ||
| DISABLE_DATE | DATE | Date this subinventory is disabled. | |||
| 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. | ||
| LOCATOR_TYPE | VARCHAR2 | 30 | Subinventory-level stock locator control type | ||
| PICKING_ORDER | NUMBER | This sets the order of picking. | |||
| QUANTITY_TRACKED | NUMBER | Flag indicating onhand item quantity is recorded | |||
| SUBINVENTORY_ID | NUMBER | 18 | Surrogate field for Subinventory. Not to be used in business | ||
| ASSET_INVENTORY | NUMBER | 9 | Items contained within the subinventory regarded as assets | ||
| SOURCE_TYPE | VARCHAR2 | 30 | Inventory or Supplier sourcing type | ||
| SOURCE_SUBINVENTORY | VARCHAR2 | 10 | Subinventory to source items from | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Organization to source items from | ||
| REQUISITION_APPROVAL_TYPE | NUMBER | Approval status of replenishment requisitions generated | |||
| FILL_KILL_TO_LOOKUP | VARCHAR2 | 30 | Determines if remaining quantities on transfer order lines will be cancelled during pick release, pick confirm and ship confirm processing | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | |||
| DEMAND_CLASS | VARCHAR2 | 30 | Demand class for the subinventory | ||
| PROJECT_ID | NUMBER | 18 | This column identifies the project. | ||
| TASK_ID | NUMBER | 18 | This column identifies the task. | ||
| SUBINVENTORY_USAGE | NUMBER | Specifies whether costs should be collected for this subinventory in project manufacturing environment | |||
| LOCATION_ID | NUMBER | 18 | This identifies the item locator. | ||
| PICK_UOM_CODE | VARCHAR2 | 3 | Unit of measure in which items are stored/picked in this subinventory | ||
| DEPRECIABLE_FLAG | NUMBER | 9 | Flag indicating if the sub inventory is depreciable | ||
| STATUS_ID | NUMBER | 18 | Status Identifier - Used by WMS only | ||
| DEFAULT_LOC_STATUS_ID | NUMBER | 18 | Default status ID for locators - Used by WMS only | ||
| LPN_CONTROLLED_FLAG | NUMBER | 9 | Flag indicates whether the subinventory is packing unit controlled. | ||
| PICK_METHODOLOGY | NUMBER | 9 | This indicates the pick methodology. | ||
| CARTONIZATION_FLAG | NUMBER | 9 | Flag indicates whether cartonization occurs by default in this subinventory. Used by WMS only. | ||
| DROPPING_ORDER | NUMBER | Dropping order used to sequence a drop operation | |||
| SUBINVENTORY_TYPE | VARCHAR2 | 30 | Type of subinventory. A value 1 means storage and 2 means receiving. | ||
| PLANNING_LEVEL | NUMBER | 9 | This enables PAR level planning. | ||
| DEFAULT_COUNT_TYPE_CODE | VARCHAR2 | 30 | Default Replenishment Count Type. | ||
| COUNT_METHOD | VARCHAR2 | 30 | Indicates the PAR Replenishment Count Method.Count method Values:,Two-Bin,Request,Count | ||
| SUBINVENTORY_GROUP | VARCHAR2 | 100 | Name of the Subinventory Group. | ||
| ENABLE_BULK_PICK | VARCHAR2 | 1 | Flag indicates whether Bulk Pick is enabled. | ||
| ENABLE_LOCATOR_ALIAS | VARCHAR2 | 1 | Indicates whether Locator Aliases are enabled for this Subinventory | ||
| ENFORCE_ALIAS_UNIQUENESS | VARCHAR2 | 1 | Flag to Enforce Locator Alias Uniqueness in the Subinventory | ||
| 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | This column will store the Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_SECONDARY_INVENTORIEN1_ | Non Unique | Default | SECONDARY_INVENTORY_NAME, ORGANIZATION_ID, LAST_UPDATE_DATE |
| INV_SECONDARY_INVS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, SECONDARY_INVENTORY_NAME, ORGANIZATION_ID |