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

TABLE: BOM.CST_PAC_ITEM_COSTS_EFC

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


CST_PAC_ITEM_COSTS_EFC is used exclusively as an archive table
for the "Euro as a functional currency" project. It mirrors the table
CST_PAC_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
MARKET_VALUE NUMBER

Market Value
RESOURCE_COST NUMBER

Resource Cost
COST_LAYER_ID NUMBER
Yes Cost Layer Identifier
PL_ITEM_COST NUMBER

Previous Level Item Cost
PAC_PERIOD_ID NUMBER
Yes Periodic Actual Costing Period Identifier
PL_RESOURCE NUMBER

Previous Level Resource
UNBURDENED_COST NUMBER

Unburdened Cost
ITEM_MAKE_COST NUMBER

Item Make Cost
TL_ITEM_COST NUMBER

This Level Item Cost
OVERHEAD_COST NUMBER

Overhead Cost
ITEM_COST NUMBER

Item Cost
MATERIAL_COST NUMBER

Material Cost
TL_RESOURCE NUMBER

This Level Resource
PL_OVERHEAD NUMBER

Previous Level Overhead
PL_MATERIAL NUMBER

Previous Level Material
BEGIN_ITEM_COST NUMBER

Begin Item Cost
TL_OVERHEAD NUMBER

This Level Overhead
TL_MATERIAL NUMBER

This Level Material
OUTSIDE_PROCESSING_COST NUMBER

Outside Processing Cost
COST_GROUP_ID NUMBER
Yes Cost Group Identifier
PL_OUTSIDE_PROCESSING NUMBER

Previous Level Outside Processing
MATERIAL_OVERHEAD_COST NUMBER

Material Overhead Cost
ITEM_BUY_COST NUMBER

Item Buy 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 MARKET_VALUE
,      RESOURCE_COST
,      COST_LAYER_ID
,      PL_ITEM_COST
,      PAC_PERIOD_ID
,      PL_RESOURCE
,      UNBURDENED_COST
,      ITEM_MAKE_COST
,      TL_ITEM_COST
,      OVERHEAD_COST
,      ITEM_COST
,      MATERIAL_COST
,      TL_RESOURCE
,      PL_OVERHEAD
,      PL_MATERIAL
,      BEGIN_ITEM_COST
,      TL_OVERHEAD
,      TL_MATERIAL
,      OUTSIDE_PROCESSING_COST
,      COST_GROUP_ID
,      PL_OUTSIDE_PROCESSING
,      MATERIAL_OVERHEAD_COST
,      ITEM_BUY_COST
,      PL_MATERIAL_OVERHEAD
,      BURDEN_COST
,      TL_OUTSIDE_PROCESSING
,      TL_MATERIAL_OVERHEAD
,      SET_OF_BOOKS_ID
FROM BOM.CST_PAC_ITEM_COSTS_EFC;

Dependencies

[top of page]

BOM.CST_PAC_ITEM_COSTS_EFC does not reference any database object

BOM.CST_PAC_ITEM_COSTS_EFC is referenced by following:

SchemaAPPS
SynonymCST_PAC_ITEM_COSTS_EFC