INV_ONHAND_QUANTITIES_DETAIL
INV_ONHAND_QUANTITIES_DETAIL stores quantity on hand information by control level and location. . . . INV_ONHAND_QUANTITIES_DETAIL is maintained as a stack of receipt records, which are consumed by issue transactions in FIFO order. The quantity on hand of an item at any particular control level and location can be found by summing TRANSACTION_QUANTITY for all records that match the criteria. Note that any transactions which are committed to the table INV_MATERIAL_TXNS_TEMP are considered to be played out as far as quantity on hand is concerned in Inventory transaction forms. All our Inquiry forms and ABC compile are only based on INV_ONHAND_QUANTITIES_DETAIL. . . . INV_ONHAND_QUANTITIES_DETAIL has two columns, CREATE_TRANSACTION_ID and UPDATE_TRANSACTION_IDs to join to INV_MATERIAL_TXNS.TRANSACTION_ID the transactions that created the row and the transaction that last updated a row. . . . . . . .
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ONHAND_QUANTITIES_PK |
ONHAND_QUANTITIES_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| STANDARD_PACK_UOM | VARCHAR2 | 3 | This is the unit of measure for standard pack. | ||
| STANDARD_PACK_QUANTITY | NUMBER | This is the standard pack quantity. | |||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| DATE_RECEIVED | DATE | Date when the on hand quantity was received. | |||
| 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_TRANSACTION_QUANTITY | NUMBER | Yes | Transaction quantity in the primary unit of measure of the item | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Yes | This is name of the subinventory. | |
| REVISION | VARCHAR2 | 18 | Revision of item if under revision control. | ||
| LOCATOR_ID | NUMBER | 18 | This identifies the item locator. | ||
| CREATE_TRANSACTION_ID | NUMBER | 18 | Transaction identifier of the transaction that created this row | ||
| UPDATE_TRANSACTION_ID | NUMBER | 18 | Transaction identifier of the transaction that last updated this row | ||
| LOT_NUMBER | VARCHAR2 | 80 | This number identifies an inventory lot. | ||
| ORIG_DATE_RECEIVED | DATE | This is the date originally received. | |||
| ONHAND_QUANTITIES_ID | NUMBER | 18 | Yes | Primary key that identifies an Onhand record. | |
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | Transaction unit of measure which created this transaction | |
| TRANSACTION_QUANTITY | NUMBER | Yes | This is the transaction quantity in the user's preferred unit of measure. | ||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure that may have been used to do the material transaction | ||
| SECONDARY_TRANSACTION_QUANTITY | NUMBER | This is the secondary transaction quantity. | |||
| 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. | |
| ORIG_SOURCE_TXN_ID | NUMBER | 18 | This is a reference to the source transaction for tracking consignments. | ||
| OWNING_TYPE | VARCHAR2 | 30 | The owning type identifies the type of the entity who owns this quantity, in the context of consignment; the lookup type INV_OWNING_TYPES has the valid values. The record is consigned only if OWNING_TYPE is populated. | ||
| OWNING_ENTITY_ID | NUMBER | 18 | The owning type will determine the type of value used; for example, this will identify the supplier site for consignment from supplier. | ||
| AGING_ONSET_DATE | DATE | Aging onset date is the date that aging starts for this consigned item. | |||
| AGING_EXPIRATION_DATE | DATE | Aging expiration date is the date that this consigned item will become owned. | |||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_ONHAND_QUANTITIES_DETAIL | inv_org_parameters | ORGANIZATION_ID |
| INV_ONHAND_QUANTITIES_DETAIL | inv_item_locations | LOCATOR_ID |
| INV_ONHAND_QUANTITIES_DETAIL | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ONHAND_QUANTITIES_N10 | Non Unique | Default | AGING_EXPIRATION_DATE |
| INV_ONHAND_QUANTITIES_N11 | Non Unique | Default | ORIG_SOURCE_TXN_ID |
| INV_ONHAND_QUANTITIES_N4 | Non Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, PRIMARY_TRANSACTION_QUANTITY |
| INV_ONHAND_QUANTITIES_N5 | Non Unique | Default | ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID |
| INV_ONHAND_QUANTITIES_N6 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID |
| INV_ONHAND_QUANTITIES_N8 | Non Unique | Default | ORGANIZATION_ID, LOT_NUMBER, INVENTORY_ITEM_ID |
| INV_ONHAND_QUANTITIES_N9 | Non Unique | Default | OWNING_TYPE, OWNING_ENTITY_ID |
| INV_ONHAND_QUANTITIES_U1 | Unique | Default | ONHAND_QUANTITIES_ID |