INV_ABC_ASSGN_GROUP_CLASSES
INV_ABC_ASSGN_GROUP_CLASSES stores information about the ABC Classes that are assigned to an ABC Group. An ABC Class can be assigned to 1 or more ABC Groups, but may be used only once in each ABC Group. . In addition to membership information, this table contains the priority number of the ABC Class in the ABC Group, and compile breakpoint specifications such as item sequence number from the compile, percent of items, and percent of value that goes into this ABC Class/ABC Group combination. . Oracle Inventory uses this information for mass loading the items from a compile to the ABC Classes in an ABC Group. . . .
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ABC_ASSGN_GRP_CLS_PK |
ASSIGNMENT_GROUP_ID, ABC_CLASS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSIGNMENT_GROUP_ID | NUMBER | 18 | Yes | This identifies the ABC assignment group. | |
| ABC_GROUP_CLASS_ID | NUMBER | 18 | Yes | ABC Class Identifier associated with the Group | |
| ABC_CLASS_ID | NUMBER | 18 | Yes | This column identifies the ABC class. | |
| SEQUENCE_NUMBER | NUMBER | 18 | Yes | Priority of the class 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. | |
| ITEM_SEQ_NUMBER | NUMBER | 18 | Sequence number of last item in this class within group. | ||
| PERCENT_OF_ITEMS | NUMBER | Percentage of the total number of assignment group items in this assignment group class | |||
| PERCENT_OF_VALUE | NUMBER | Percentage of the total inventory value in this assignment group class | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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_ASSGN_GROUP_CLASSES | inv_abc_classes | ABC_CLASS_ID |
| INV_ABC_ASSGN_GROUP_CLASSES | inv_abc_assignment_groups | ASSIGNMENT_GROUP_ID |
| inv_abc_assignments | inv_abc_assgn_group_classes | ASSIGNMENT_GROUP_ID, ABC_CLASS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ABC_ASSGN_GRP_CLS_U1 | Unique | FUSION_TS_TX_IDX | ASSIGNMENT_GROUP_ID, ABC_CLASS_ID |