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


TABLE: BOM.CST_LAYER_COST_DETAILS_EFC

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


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


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LEVEL_TYPE NUMBER
Yes Level Type
LAYER_ID NUMBER
Yes Layer Id
COST_ELEMENT_ID NUMBER
Yes Cost Element Id
ITEM_COST NUMBER
Yes Item Cost
SET_OF_BOOKS_ID NUMBER

Set Of Books Identifier
Query Text

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


SELECT LEVEL_TYPE
,      LAYER_ID
,      COST_ELEMENT_ID
,      ITEM_COST
,      SET_OF_BOOKS_ID
FROM BOM.CST_LAYER_COST_DETAILS_EFC;

Dependencies

[top of page]

BOM.CST_LAYER_COST_DETAILS_EFC does not reference any database object

BOM.CST_LAYER_COST_DETAILS_EFC is referenced by following:

SchemaAPPS
SynonymCST_LAYER_COST_DETAILS_EFC