[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_ABC_COMPILE_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_ABC_COMPILE_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
MTL_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.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_ABC_COMPILE_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 COMPILE_ID
|
| MTL_ABC_COMPILE_HEADERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
COMPILE_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMPILE_ID | NUMBER | Yes | Compile identifier | |
| COMPILE_NAME | VARCHAR2 | (40) | Yes | Name of compile |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| COMPILE_TYPE | NUMBER | Yes | Code indicating type of compile | |
| COMPILE_STATUS | NUMBER | Yes | Status of compile | |
| SECONDARY_INVENTORY | VARCHAR2 | (10) | Subinventory name | |
| ITEM_SCOPE_CODE | NUMBER | Scope of compile: Whether all are included items or just those within the specified subinventory | ||
| DESCRIPTION | VARCHAR2 | (50) | Compile description | |
| COMPILE_ITEMS | NUMBER | Number of items compiled | ||
| COMPILE_DATE | DATE | Compile date | ||
| COST_CODE | NUMBER | Yes | Cost code used for compile | |
| COST_TYPE | NUMBER | Cost type used | ||
| CUMULATIVE_QUANTITY | NUMBER | Total quantity of all items within this compile | ||
| CUMULATIVE_VALUE | NUMBER | Total value of all items within this compile | ||
| SCHEDULE_TYPE | NUMBER | (Not currently used) | ||
| SCHEDULE_DESIGNATOR | VARCHAR2 | (10) | MRP designator | |
| MRP_PLAN_NAME | VARCHAR2 | (10) | MRP plan name | |
| 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 defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| MRP_FORECAST_NAME | VARCHAR2 | (10) | MRP forecast-name |
Cut, paste (and edit) the following text to query this object:
SELECT COMPILE_ID
, COMPILE_NAME
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, COMPILE_TYPE
, COMPILE_STATUS
, SECONDARY_INVENTORY
, ITEM_SCOPE_CODE
, DESCRIPTION
, COMPILE_ITEMS
, COMPILE_DATE
, COST_CODE
, COST_TYPE
, CUMULATIVE_QUANTITY
, CUMULATIVE_VALUE
, SCHEDULE_TYPE
, SCHEDULE_DESIGNATOR
, MRP_PLAN_NAME
, START_DATE
, CUTOFF_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, MRP_FORECAST_NAME
FROM INV.MTL_ABC_COMPILE_HEADERS;
INV.MTL_ABC_COMPILE_HEADERS does not reference any database object
INV.MTL_ABC_COMPILE_HEADERS is referenced by following:
APPS
MTL_ABC_COMPILE_HEADERS
|
|
|
|