[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CST_PC_ITEM_COST_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | BOM |
| FND Design Data: |  BOM.CST_PC_ITEM_COST_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
CST_PC_ITEM_COST_INTERFACE is an open interface table used for importing periodic costs.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CST_PC_ITEM_COST_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INTERFACE_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_HEADER_ID | NUMBER | Yes | Interface Header Identifier | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
| COST_GROUP | VARCHAR2 | (10) | Yes | Cost Group Name |
| COST_TYPE | VARCHAR2 | (10) | Yes | Cost Type Name |
| PERIOD_NAME | VARCHAR2 | (15) | Yes | Period name |
| PROCESS_FLAG | NUMBER | Yes | Process status flag | |
| BEGIN_LAYER_QUANTITY | NUMBER | Yes | Period Beginning Layer Quantity | |
| ISSUE_QUANTITY | NUMBER | Issue Quantity | ||
| BUY_QUANTITY | NUMBER | Buy Quantity | ||
| MAKE_QUANTITY | NUMBER | Make Quantity | ||
| INTERFACE_GROUP_ID | NUMBER | Interface Group Identifier | ||
| COST_LAYER_ID | NUMBER | Cost Layer Identifier | ||
| QUANTITY_LAYER_ID | NUMBER | Quantity Layer Identifier | ||
| PAC_PERIOD_ID | NUMBER | Periodic Period Identifier | ||
| COST_GROUP_ID | NUMBER | Cost Group Identifier | ||
| ITEM_COST | NUMBER | Item Cost | ||
| MARKET_VALUE | NUMBER | Market Value | ||
| JUSTIFICATION | VARCHAR2 | (2000) | Justification | |
| BEGIN_ITEM_COST | NUMBER | Period Begin Item Cost | ||
| ITEM_BUY_COST | NUMBER | Item Buy Cost | ||
| ITEM_MAKE_COST | NUMBER | Item Make Cost | ||
| PL_MATERIAL | NUMBER | Previous Level Material Cost | ||
| PL_MATERIAL_OVERHEAD | NUMBER | Previous Level Material Overhead Cost | ||
| PL_RESOURCE | NUMBER | Previous Level Resource Cost | ||
| PL_OUTSIDE_PROCESSING | NUMBER | Previous Level Outside Processing Cost | ||
| PL_OVERHEAD | NUMBER | Previous Level Overhead Cost | ||
| TL_MATERIAL | NUMBER | This Level Material Cost | ||
| TL_MATERIAL_OVERHEAD | NUMBER | This Level Material Overhead Cost | ||
| TL_RESOURCE | NUMBER | This Level Resource Cost | ||
| TL_OUTSIDE_PROCESSING | NUMBER | This Level Outside Processing Cost | ||
| TL_OVERHEAD | NUMBER | This Level Overhead Cost | ||
| PL_ITEM_COST | NUMBER | Previous Level Item Cost | ||
| TL_ITEM_COST | NUMBER | This Level Item Cost | ||
| UNBURDENED_COST | NUMBER | Unburdened Cost | ||
| BURDEN_COST | NUMBER | Burden Cost | ||
| MATERIAL_COST | NUMBER | Material Cost | ||
| MATERIAL_OVERHEAD_COST | NUMBER | Material Overhead Cost | ||
| RESOURCE_COST | NUMBER | Resource Cost | ||
| OVERHEAD_COST | NUMBER | Overhead Cost | ||
| OUTSIDE_PROCESSING_COST | NUMBER | Outside Processing Cost | ||
| REFERENCE | VARCHAR2 | (240) | Reference Flag | |
| ERROR_FLAG | NUMBER | Error Status Flag | ||
| ERROR_EXPLANATION | VARCHAR2 | (2000) | Error Explanation | |
| LOCK_FLAG | NUMBER | Lock Flag | ||
| 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 | |
| REQUEST_ID | NUMBER | Extended Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Extended Who column | ||
| PROGRAM_ID | NUMBER | Extended Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Extended Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| LAYER_QUANTITY | NUMBER | Layer quantity |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_HEADER_ID
, INVENTORY_ITEM_ID
, COST_GROUP
, COST_TYPE
, PERIOD_NAME
, PROCESS_FLAG
, BEGIN_LAYER_QUANTITY
, ISSUE_QUANTITY
, BUY_QUANTITY
, MAKE_QUANTITY
, INTERFACE_GROUP_ID
, COST_LAYER_ID
, QUANTITY_LAYER_ID
, PAC_PERIOD_ID
, COST_GROUP_ID
, ITEM_COST
, MARKET_VALUE
, JUSTIFICATION
, BEGIN_ITEM_COST
, ITEM_BUY_COST
, ITEM_MAKE_COST
, PL_MATERIAL
, PL_MATERIAL_OVERHEAD
, PL_RESOURCE
, PL_OUTSIDE_PROCESSING
, PL_OVERHEAD
, TL_MATERIAL
, TL_MATERIAL_OVERHEAD
, TL_RESOURCE
, TL_OUTSIDE_PROCESSING
, TL_OVERHEAD
, PL_ITEM_COST
, TL_ITEM_COST
, UNBURDENED_COST
, BURDEN_COST
, MATERIAL_COST
, MATERIAL_OVERHEAD_COST
, RESOURCE_COST
, OVERHEAD_COST
, OUTSIDE_PROCESSING_COST
, REFERENCE
, ERROR_FLAG
, ERROR_EXPLANATION
, LOCK_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAYER_QUANTITY
FROM BOM.CST_PC_ITEM_COST_INTERFACE;
BOM.CST_PC_ITEM_COST_INTERFACE does not reference any database object
BOM.CST_PC_ITEM_COST_INTERFACE is referenced by following:
BOM
CST_PC_ITEM_COST_INTERFACE#
|
|
|
|