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


TABLE: BOM.CST_ACTIVITY_COSTS_EFC

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


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

Unit Cost
ORGANIZATION_ID NUMBER
Yes Organization Identifier
ACTIVITY_ID NUMBER
Yes Activity Identifier
TOTAL_COST NUMBER

Total Cost
COST_TYPE_ID NUMBER
Yes Cost Type Identifier
SET_OF_BOOKS_ID NUMBER

Set Of Books Identifier
Query Text

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


SELECT UNIT_COST
,      ORGANIZATION_ID
,      ACTIVITY_ID
,      TOTAL_COST
,      COST_TYPE_ID
,      SET_OF_BOOKS_ID
FROM BOM.CST_ACTIVITY_COSTS_EFC;

Dependencies

[top of page]

BOM.CST_ACTIVITY_COSTS_EFC does not reference any database object

BOM.CST_ACTIVITY_COSTS_EFC is referenced by following:

SchemaAPPS
SynonymCST_ACTIVITY_COSTS_EFC