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

VIEW: APPS.CST_EAM_ASSET_BY_DEPT_VAR_V

Object Details
Object Name: CST_EAM_ASSET_BY_DEPT_VAR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_EAM_ASSET_BY_DEPT_VAR_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
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

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)
Serial Number of an Asset
TOTAL NUMBER

Total Cost
MATERIAL NUMBER

Cost belonging to the cost element Material
LABOR NUMBER

Cost belonging to the cost element Labor
EQUIPMENT NUMBER

Cost belonging to the cost element Equipment
Query Text

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


SELECT 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_ASSET_BY_DEPT_VAR_V;

Dependencies

[top of page]

APPS.CST_EAM_ASSET_BY_DEPT_VAR_V references the following:

SchemaAPPS
ViewCST_EAM_ASSET_BY_DEPT_EST_V
ViewCST_EAM_ASSET_BY_DEPT_V

APPS.CST_EAM_ASSET_BY_DEPT_VAR_V is not referenced by any database object