[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:
|
|
|