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

VIEW: APPS.CST_EAM_ROLLUP_BY_DEPT_V

Object Details
Object Name: CST_EAM_ROLLUP_BY_DEPT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_EAM_ROLLUP_BY_DEPT_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes Group identifer identifying the batch when the rollup was performed
PERIOD_SET_NAME VARCHAR2 (15) Yes Period Set Name
PERIOD_NAME VARCHAR2 (15) Yes Period Name
PERIOD_START_DATE DATE
Yes Start Date of a particular period
NAME VARCHAR2 (80) Yes Cost Category
INV_ID NUMBER
Yes Inventory item identifier
CONCATENATED_SEGMENTS VARCHAR2 (40)
Concatenation of segments, which corresponds to Asset Group Name
ORG_ID NUMBER
Yes Organization Identifier
SERIAL_NUMBER VARCHAR2 (30) Yes Serial Number of an Asset
TOTAL NUMBER

Total Rollup Cost
MATERIAL NUMBER

Rollup Cost belonging to the cost element Material
LABOR NUMBER

Rollup Cost belonging to the cost element Labor
EQUIPMENT NUMBER

Rollup Cost belonging to the cost element Equipment
Query Text

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


SELECT GROUP_ID
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      PERIOD_START_DATE
,      NAME
,      INV_ID
,      CONCATENATED_SEGMENTS
,      ORG_ID
,      SERIAL_NUMBER
,      TOTAL
,      MATERIAL
,      LABOR
,      EQUIPMENT
FROM APPS.CST_EAM_ROLLUP_BY_DEPT_V;

Dependencies

[top of page]

APPS.CST_EAM_ROLLUP_BY_DEPT_V references the following:

SchemaAPPS
SynonymCST_EAM_ROLLUP_TEMP
ViewMFG_LOOKUPS
ViewMTL_SYSTEM_ITEMS_B_KFV
APPS.CST_EAM_ROLLUP_BY_DEPT_V is referenced by following:

SchemaAPPS
ViewCST_EAM_ROLLUP_BY_DEPT_VAR_V