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. |
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 |