eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BOM.CST_EAM_ROLLUP_COSTS

Object Details

Object Name:	CST_EAM_ROLLUP_COSTS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_EAM_ROLLUP_COSTS
Subobject Name:
Status:	VALID

This temporary table stores the cumulative cost details of the hierarchies stored in CST_EAM_HIEARCHY_SNAPSHOT.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_EAM_ROLLUP_COSTS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	GROUP_ID OBJECT_ID OBJECT_TYPE MAINT_COST_CATEGORY PERIOD_SET_NAME PERIOD_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER	(15)	Yes	An identifier for the hierarchy that this record corresponds to
OBJECT_TYPE	NUMBER	(15)		The entity type of the current node
OBJECT_ID	NUMBER	(15)	Yes	The entity type of the current node
ACCT_PERIOD_ID	NUMBER	(15)
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Period Set Name
PERIOD_NAME	VARCHAR2	(15)	Yes	Period Name
MAINT_COST_CATEGORY	NUMBER	(15)	Yes	The maintenance cost category
ACTUAL_MAT_COST	NUMBER			The actual material cost of this entity and its descendants
ACTUAL_LAB_COST	NUMBER			The actual labor cost of this entity and its descendants
ACTUAL_EQP_COST	NUMBER			The actual equipment cost of this entity and its descendants
ESTIMATED_MAT_COST	NUMBER			The estimated material cost of this entity and its descendants
ESTIMATED_LAB_COST	NUMBER			The estimated labor cost of this entity and its descendants
ESTIMATED_EQP_COST	NUMBER			The estimated equipment cost of this entity and its descendants
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATION_BY	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column

Query Text

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


SELECT GROUP_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      ACCT_PERIOD_ID
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      MAINT_COST_CATEGORY
,      ACTUAL_MAT_COST
,      ACTUAL_LAB_COST
,      ACTUAL_EQP_COST
,      ESTIMATED_MAT_COST
,      ESTIMATED_LAB_COST
,      ESTIMATED_EQP_COST
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATION_BY
,      PROGRAM_APPLICATION_ID
FROM BOM.CST_EAM_ROLLUP_COSTS;

Dependencies

[top of page]

BOM.CST_EAM_ROLLUP_COSTS does not reference any database object

BOM.CST_EAM_ROLLUP_COSTS is referenced by following:

APPS: CST_EAM_ROLLUP_COSTS