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

VIEW: APPS.CST_EAM_ASSET_BY_DEPT_EST_V

Object Details
Object Name: CST_EAM_ASSET_BY_DEPT_EST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_EAM_ASSET_BY_DEPT_EST_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_EST_V;

Dependencies

[top of page]

APPS.CST_EAM_ASSET_BY_DEPT_EST_V references the following:

SchemaAPPS
SynonymCST_EAM_ASSET_PER_BALANCES
ViewMFG_LOOKUPS
ViewMTL_SYSTEM_ITEMS_B_KFV
APPS.CST_EAM_ASSET_BY_DEPT_EST_V is referenced by following:

SchemaAPPS
ViewCST_EAM_ASSET_BY_DEPT_VAR_V