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