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

TABLE: BOM.CST_EAM_ACTIVITY_ESTIMATES

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


CST_EAM_ACTIVITY_ESTIMATES contains results from the EAM cost estimation process for EAM activities.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_EAM_ACTIVITY_ESTIMATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_ESTIMATE_RECORD_ID
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ESTIMATE_RECORD_ID NUMBER
Yes Activity Estimate Record Identifier
RECORD_TYPE VARCHAR2 (1) Yes Record Type
ORGANIZATION_ID NUMBER

Organization Identifier
ACTIVITY_ITEM_ID NUMBER

Activity Inventory Item Identifier
EAM_COST_ELEMENT NUMBER

EAM Cost Element
MAINT_COST_CATEGORY NUMBER

Maintenance Cost Category
COST_VALUE NUMBER

Cost Value
Query Text

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


SELECT ACTIVITY_ESTIMATE_RECORD_ID
,      RECORD_TYPE
,      ORGANIZATION_ID
,      ACTIVITY_ITEM_ID
,      EAM_COST_ELEMENT
,      MAINT_COST_CATEGORY
,      COST_VALUE
FROM BOM.CST_EAM_ACTIVITY_ESTIMATES;

Dependencies

[top of page]

BOM.CST_EAM_ACTIVITY_ESTIMATES does not reference any database object

BOM.CST_EAM_ACTIVITY_ESTIMATES is referenced by following:

SchemaAPPS
SynonymCST_EAM_ACTIVITY_ESTIMATES