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_PERIOD_VALUE_TEMP

Object Details

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

CST_PERIOD_VALUE_TEMP is a temporary table used by the
View WIP Value Summary window. It sums up all of the cost in
WIP_PERIOD_BALANCES between two accounting periods that belong to a
specific WIP discrete job or repetitive schedule.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PERIOD_VALUE_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SESSION_ID
CST_PERIOD_VALUE_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	WIP_ENTITY_ID

Columns

Name	Datatype	Mandatory	Comments
SESSION_ID	NUMBER	Yes	ORACLE session identifier
WIP_ENTITY_ID	NUMBER	Yes	WIP job or repetitive assembly identifier
LINE_ID	NUMBER		WIP repetitive line identifier
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
COST_ELEMENT_ID	NUMBER	Yes	Cost element identifier
VALUATION_ACCOUNT	NUMBER	Yes	WIP valuation account identifier
TL_VALUE_IN	NUMBER		This level cost incurred
PL_VALUE_IN	NUMBER		Previous level cost incurred
TL_VALUE_OUT	NUMBER		This level cost relieved
PL_VALUE_OUT	NUMBER		Previous level cost relieved
VALUE_IN	NUMBER		Total cost incurred
VALUE_OUT	NUMBER		Total cost relieved
VARIANCE	NUMBER		Total variance
NET_ACTIVITY	NUMBER		Cost incurred minus cost relieved
VAR	NUMBER		Total variance

Query Text

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


SELECT SESSION_ID
,      WIP_ENTITY_ID
,      LINE_ID
,      ORGANIZATION_ID
,      COST_ELEMENT_ID
,      VALUATION_ACCOUNT
,      TL_VALUE_IN
,      PL_VALUE_IN
,      TL_VALUE_OUT
,      PL_VALUE_OUT
,      VALUE_IN
,      VALUE_OUT
,      VARIANCE
,      NET_ACTIVITY
,      VAR
FROM BOM.CST_PERIOD_VALUE_TEMP;

Dependencies

[top of page]

BOM.CST_PERIOD_VALUE_TEMP does not reference any database object

BOM.CST_PERIOD_VALUE_TEMP is referenced by following:

APPS: CST_PERIOD_VALUE_TEMP