INV_ONHAND_QUANTITIES_CONS_BKP
INV_ONHAND_QUANTITIES_CONS_BKP stores backup data when ESS Program job Perform Inventory On-hand Quantities Consolidation for Transaction Processing is Executed. THe data in table will be purged after a month.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ONHAND_QUANTITIES_CONS_PK |
INV_ONHAND_QUANTITIES_BKP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| INV_ONHAND_QUANTITIES_BKP_ID | NUMBER | 18 | Yes | Primary key that identifies an Onhand backup record. | |
| 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. | ||
| EXECUTION_ID | NUMBER | 18 | Yes | Execution ID is the Ess process id | |
| EXECUTION_DATE | TIMESTAMP | Yes | Execution date is the date of backup | ||
| 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_CONS_BKP | inv_org_parameters | ORGANIZATION_ID |
| INV_ONHAND_QUANTITIES_CONS_BKP | inv_item_locations | LOCATOR_ID |
| INV_ONHAND_QUANTITIES_CONS_BKP | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ONHAND_CONS_BKP_N1 | Non Unique | Default | ORGANIZATION_ID, LOT_NUMBER, INVENTORY_ITEM_ID |
| INV_ONHAND_CONS_BKP_N2 | Non Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, PRIMARY_TRANSACTION_QUANTITY |
| INV_ONHAND_CONS_BKP_N3 | Non Unique | Default | EXECUTION_DATE |
| INV_ONHAND_QUANTITIES_CON_U1 | Unique | Default | INV_ONHAND_QUANTITIES_BKP_ID |