INV_ABC_ASSIGNMENTS
INV_ABC_ASSIGNMENTS holds assignments of inventory items to ABC Classes and ABC Groups. . An item can belong to 1 or more ABC Classes, but not more than once in each ABC Group. . An ABC Class can belong to 1 or more ABC Groups, but not more than once in each ABC Group. . The Assign ABC Items window allows the user to specify for a given ABC Group, the range of items to assign to every single ABC Class in the ABC Group. The range of items is indicated as an absolute sequence number or value; or as a percent of item, or value. Then, a concurrent program (INCAAA) looks at this assignment information and at the items compiled for that group, and assigns items to their corresponding classes. This information is stored in the INV_ABC_ASSIGNMENTS table. . Oracle Inventory uses this information to load the cycle count process.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ABC_ASSIGNMENTS_PK |
ABC_ASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| ABC_ASSIGNMENT_ID | NUMBER | 18 | Yes | Primary key that identifies an assignment of inventory item to ABC class and ABC group. | |
| ASSIGNMENT_GROUP_ID | NUMBER | 18 | Yes | This identifies the ABC assignment group. | |
| ABC_CLASS_ID | NUMBER | 18 | Yes | Identifer of the class to which this item has been assigned in the assignment group | |
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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_ABC_ASSIGNMENTS | inv_abc_assignment_groups | ASSIGNMENT_GROUP_ID |
| INV_ABC_ASSIGNMENTS | inv_abc_classes | ABC_CLASS_ID |
| INV_ABC_ASSIGNMENTS | inv_abc_assgn_group_classes | ASSIGNMENT_GROUP_ID, ABC_CLASS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| INV_ABC_ASSIGNMENTS_N1 | Non Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID | Obsolete |
| INV_ABC_ASSIGNMENTS_U1 | Unique | FUSION_TS_TX_IDX | ASSIGNMENT_GROUP_ID, INVENTORY_ITEM_ID | |
| INV_ABC_ASSIGNMENTS_U2 | Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, ASSIGNMENT_GROUP_ID, ABC_CLASS_ID | |
| INV_ABC_ASSIGNMENTS_U3 | Unique | FUSION_TS_TX_IDX | ABC_ASSIGNMENT_ID |