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 |
SECONDARY_INVENTORY_NAME, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| 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 | 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. | |||
| DESCRIPTION | VARCHAR2 | 50 | This is description of the subinventory. | |||
| DISABLE_DATE | DATE | Date this subinventory is disabled. | ||||
| INVENTORY_ATP_CODE | NUMBER | 9 | Yes | Inventory available to promise code | ||
| AVAILABILITY_TYPE | NUMBER | 9 | Yes | This code indicates subinventory availability. | ||
| RESERVABLE_TYPE | NUMBER | 9 | Yes | 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 | 9 | Yes | Flag indicating onhand item quantity is recorded | ||
| SUBINVENTORY_ID | NUMBER | 18 | Yes | Surrogate field for Subinventory. Not to be used in business | ||
| ASSET_INVENTORY | NUMBER | 9 | Yes | 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. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_INVENTORIES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Subinventories (INV_SECONDARY_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. | ||||
| 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. | |||
| ORACLE_HEALTH_LOCATION | VARCHAR2 | 1 | Indicates whether the subinventory is an oracle health location. Possible values are Y or N. | |||
| USE_SUB_MFG_MNT_IN_WMS | VARCHAR2 | 1 | This flag indicates whether or not the subinventory is used for manufacturing and maintenance integration with WMS. | |||
| USE_PACK_UNIT_COMP_RET | VARCHAR2 | 1 | This flag indicates whether or not to use packing unit for product completion and return transactions in manufacturing and maintenance. This is used only when the subinventory is enabled for manufacturing and maintenance integration with WMS. | |||
| ALLOW_OFFLINE_MODE | VARCHAR2 | 1 | This flag indicates whether the subinventory will allow counts from mobile in the offline mode. | |||
| AUTO_CREATE_DELIVERIES | VARCHAR2 | 1 | Value that indicates whether the deliveries should be created for orders requested from this subinventory. Valid values include Y and N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_SECONDARY_INVENTORIES | inv_org_parameters | SOURCE_ORGANIZATION_ID |
| INV_SECONDARY_INVENTORIES | inv_secondary_inventories | SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID |
| INV_SECONDARY_INVENTORIES | inv_material_statuses_b | STATUS_ID |
| INV_SECONDARY_INVENTORIES | inv_org_parameters | ORGANIZATION_ID |
| inv_cc_entries_interface | inv_secondary_inventories | SUBINVENTORY, ORGANIZATION_ID |
| inv_cycle_count_entries | inv_secondary_inventories | SUBINVENTORY, ORGANIZATION_ID |
| inv_lpn_interface | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_onhand_quantities_detail | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_reservations_interface | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_reservations_interface | inv_secondary_inventories | TO_SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_serial_numbers | inv_secondary_inventories | CURRENT_SUBINVENTORY_CODE, CURRENT_ORGANIZATION_ID |
| inv_license_plate_numbers | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| rcv_transactions | inv_secondary_inventories | SUBINVENTORY, ORGANIZATION_ID |
| inv_item_loc_defaults | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_item_locations | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_abc_compiles | inv_secondary_inventories | SECONDARY_INVENTORY, ORGANIZATION_ID |
| inv_supply | inv_secondary_inventories | FROM_SUBINVENTORY, FROM_ORGANIZATION_ID |
| inv_supply | inv_secondary_inventories | TO_SUBINVENTORY, TO_ORGANIZATION_ID |
| inv_supply | inv_secondary_inventories | MRP_TO_SUBINVENTORY, MRP_TO_ORGANIZATION_ID |
| inv_reservations | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_intersub_parameters | inv_secondary_inventories | FROM_SUBINVENTORY, ORGANIZATION_ID |
| inv_intersub_parameters | inv_secondary_inventories | TO_SUBINVENTORY, ORGANIZATION_ID |
| inv_abc_assignment_groups | inv_secondary_inventories | SECONDARY_INVENTORY, ORGANIZATION_ID |
| inv_material_status_history | inv_secondary_inventories | ZONE_CODE, ORGANIZATION_ID |
| inv_physical_subinventories | inv_secondary_inventories | SUBINVENTORY, ORGANIZATION_ID |
| inv_consumption_rules | inv_secondary_inventories | FROM_SUBINVENTORY_CODE, FROM_ORGANIZATION_ID |
| inv_consumption_rules | inv_secondary_inventories | TO_SUBINVENTORY_CODE, TO_ORGANIZATION_ID |
| inv_secondary_inventories | inv_secondary_inventories | SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID |
| inv_abc_compile_headers | inv_secondary_inventories | SECONDARY_INVENTORY, ORGANIZATION_ID |
| rcv_supply | inv_secondary_inventories | FROM_SUBINVENTORY, FROM_ORGANIZATION_ID |
| rcv_supply | inv_secondary_inventories | TO_SUBINVENTORY, TO_ORGANIZATION_ID |
| rcv_transactions_interface | inv_secondary_inventories | SUBINVENTORY, TO_ORGANIZATION_ID |
| inv_uom_usages | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_transactions_interface | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_transactions_interface | inv_secondary_inventories | TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION |
| inv_onhand_quantities_cons_bkp | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_txn_request_lines | inv_secondary_inventories | FROM_SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_txn_request_lines | inv_secondary_inventories | TO_SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_item_sub_inventories | inv_secondary_inventories | SECONDARY_INVENTORY, ORGANIZATION_ID |
| inv_item_sub_inventories | inv_secondary_inventories | SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID |
| inv_physical_adjustments | inv_secondary_inventories | SUBINVENTORY_NAME, ORGANIZATION_ID |
| inv_physical_inventory_tags | inv_secondary_inventories | SUBINVENTORY, ORGANIZATION_ID |
| rcv_shipment_lines | inv_secondary_inventories | TO_SUBINVENTORY, TO_ORGANIZATION_ID |
| inv_material_txns_temp | inv_secondary_inventories | TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION |
| inv_material_txns_temp | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_org_parameters | inv_secondary_inventories | SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID |
| inv_txn_request_headers | inv_secondary_inventories | FROM_SUBINVENTORY_CODE, ORGANIZATION_ID |
| inv_txn_request_headers | inv_secondary_inventories | TO_SUBINVENTORY_CODE, ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_SECONDARY_INVENTORIES_N2 | Non Unique | Default | LAST_UPDATE_DATE |
| INV_SECONDARY_INVENTORIES_N3 | Non Unique | Default | ORGANIZATION_ID, UPPER("SECONDARY_INVENTORY_NAME") |
| INV_SECONDARY_INVENTORIES_N4 | Non Unique | Default | SUBINVENTORY_GROUP, ORGANIZATION_ID |
| INV_SECONDARY_INVS_N1 | Non Unique | Default | SUBINVENTORY_TYPE, ORGANIZATION_ID |
| INV_SECONDARY_INVS_U1 | Unique | Default | SECONDARY_INVENTORY_NAME, ORGANIZATION_ID |