DBA Data[Home] [Help] [Dependency Information]

TABLE: BOM.CST_ITEM_COSTS_EFC

Object Details
Object Name: CST_ITEM_COSTS_EFC
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_ITEM_COSTS_EFC
Subobject Name:
Status: VALID


CST_ITEM_COSTS_EFC is used exclusively as an archive table
for the "Euro as a functional currency" project. It mirrors the table
CST_ITEM_COSTS prior to conversion to the euro currency.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RESOURCE_COST NUMBER

Resource Cost
ORGANIZATION_ID NUMBER
Yes Organization Identifier
PL_ITEM_COST NUMBER

Previous Level Item Cost
PL_RESOURCE NUMBER

Previous Level Resource
UNBURDENED_COST NUMBER

Unburdened Cost
TL_ITEM_COST NUMBER

This Level Item Cost
OVERHEAD_COST NUMBER

Overhead Cost
COST_TYPE_ID NUMBER
Yes Cost Type Identifier
ITEM_COST NUMBER

Item Cost
MATERIAL_COST NUMBER

Material Cost
TL_RESOURCE NUMBER

This Level Resource
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
PL_OVERHEAD NUMBER

Previous Level Overhead
PL_MATERIAL NUMBER

Previous Level Material
TL_OVERHEAD NUMBER

This Level Overhead
TL_MATERIAL NUMBER

This Level Material
OUTSIDE_PROCESSING_COST NUMBER

Outside Processing Cost
PL_OUTSIDE_PROCESSING NUMBER

Previous Level Outside Processing
MATERIAL_OVERHEAD_COST NUMBER

Material Overhead Cost
PL_MATERIAL_OVERHEAD NUMBER

Previous Level Material Overhead
BURDEN_COST NUMBER

Burden Cost
TL_OUTSIDE_PROCESSING NUMBER

This Level Outside Processing
TL_MATERIAL_OVERHEAD NUMBER

This Level Material Overhead
SET_OF_BOOKS_ID NUMBER

Set of Books Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_COST
,      ORGANIZATION_ID
,      PL_ITEM_COST
,      PL_RESOURCE
,      UNBURDENED_COST
,      TL_ITEM_COST
,      OVERHEAD_COST
,      COST_TYPE_ID
,      ITEM_COST
,      MATERIAL_COST
,      TL_RESOURCE
,      INVENTORY_ITEM_ID
,      PL_OVERHEAD
,      PL_MATERIAL
,      TL_OVERHEAD
,      TL_MATERIAL
,      OUTSIDE_PROCESSING_COST
,      PL_OUTSIDE_PROCESSING
,      MATERIAL_OVERHEAD_COST
,      PL_MATERIAL_OVERHEAD
,      BURDEN_COST
,      TL_OUTSIDE_PROCESSING
,      TL_MATERIAL_OVERHEAD
,      SET_OF_BOOKS_ID
FROM BOM.CST_ITEM_COSTS_EFC;

Dependencies

[top of page]

BOM.CST_ITEM_COSTS_EFC does not reference any database object

BOM.CST_ITEM_COSTS_EFC is referenced by following:

SchemaBOM
ViewCST_ITEM_COSTS_EFC#