INV_ABC_COMPILE_HEADERS
INV_ABC_COMPILE_HEADERS contains information that is used for, and that results from an ABC compile or ABC analysis. It holds user- specified information entered through the Define ABC Compiles window, such as the current compile option and cost code chosen, as well as the results of an ABC analysis, such as the number of items included in the compile, the cumulative item quantity and the cumulative item value. . Oracle Inventory uses this information during the ABC compilation process to determine the compile criterion and attributes used for the compilation; this information is also used for reporting purposes in the ABC Descending Value Report, and the ABC Assignments Report. . .
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ABC_COMPILE_HEADERS_PK |
COMPILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| COMPILE_ID | NUMBER | 18 | Yes | Primary key of the ABC compile header. | ||
| 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. | ||
| COMPILE_NAME | VARCHAR2 | 40 | Yes | This is name of the ABC compile. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | ||
| 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. | |||
| COMPILE_TYPE | VARCHAR2 | 30 | Yes | Code indicating type of compile | ||
| COMPILE_STATUS | VARCHAR2 | 30 | Yes | This indicates the status of ABC compile. | ||
| SECONDARY_INVENTORY | VARCHAR2 | 10 | This is the name of the subinventory. | |||
| ITEM_SCOPE_CODE | VARCHAR2 | 30 | Scope of compile: Whether all are included items or just those within the specified subinventory | |||
| DESCRIPTION | VARCHAR2 | 50 | This is the description of ABC compile. | |||
| COMPILE_ITEMS | NUMBER | 18 | This is the number of items ABC compiled. | |||
| COMPILE_DATE | DATE | This date is the ABC compile date. | ||||
| COST_TYPE | NUMBER | This column indicates the cost type. | ||||
| CUMULATIVE_QUANTITY | NUMBER | Total quantity of all items within this compile | ||||
| CUMULATIVE_VALUE | NUMBER | Total value of all items within this compile | ||||
| SCHEDULE_DESIGNATOR | VARCHAR2 | 10 | This indicates the MRP designator. | |||
| MRP_PLAN_NAME | VARCHAR2 | 10 | This is the name of the MRP plan. | |||
| START_DATE | DATE | Start date for historical data analysis | ||||
| CUTOFF_DATE | DATE | End date for historical data analysis | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ABC Classification Set Headers (INV_ABC_COMPILE_HEADERS) | ||
| 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. | |||
| MRP_FORECAST_NAME | VARCHAR2 | 10 | This is the name of the MRP forecast. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_ABC_COMPILE_HEADERS | inv_org_parameters | ORGANIZATION_ID |
| INV_ABC_COMPILE_HEADERS | inv_secondary_inventories | SECONDARY_INVENTORY, ORGANIZATION_ID |
| inv_abc_compiles | inv_abc_compile_headers | COMPILE_ID |
| inv_abc_assignment_groups | inv_abc_compile_headers | COMPILE_ID |
| inv_assgn_groups_seeddata_b | inv_abc_compile_headers | COMPILE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ABC_COMPILE_HEADERS_U1 | Unique | FUSION_TS_TX_IDX | COMPILE_ID |
| INV_ABC_COMPILE_HEADERS_U2 | Unique | FUSION_TS_TX_IDX | ORGANIZATION_ID, COMPILE_NAME |