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]

VIEW: APPS.WIP_EAM_COST_DETAILS_V

Object Details

Object Name:	WIP_EAM_COST_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_COST_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MAINT_COST_CATEGORY	NUMBER			Maintenance cost category code
COST_CATEGORY_MEANING	VARCHAR2	(80)	Yes	Maintenance cost category
WIP_ENTITY_ID	NUMBER			Work order identifier
ORGANIZATION_ID	NUMBER			Organization identifier
PERIOD_START_DATE	DATE			Start date of an accounting period
PERIOD_SET_NAME	VARCHAR2	(15)		Period set name
PERIOD_NAME	VARCHAR2	(15)		Period name
ACTUAL_TOTAL_COST	NUMBER			Actual total cost which is the sum of material, labor and equipment cost
ACTUAL_MATERIAL_COST	NUMBER			Actual material cost
ACTUAL_LABOR_COST	NUMBER			Actual labor cost
ACTUAL_EQUIPMENT_COST	NUMBER			Actual equipment cost
ESTIMATED_TOTAL_COST	NUMBER			Estimated total cost is the sum total of estimated material, labor and equipment costs
ESTIMATED_MATERIAL_COST	NUMBER			Estimated material cost
ESTIMATED_LABOR_COST	NUMBER			Estimated labor cost
ESTIMATED_EQUIPMENT_COST	NUMBER			Estimated equipment cost
VARIANCE_TOTAL_COST	NUMBER			Variance total cost
VARIANCE_MATERIAL_COST	NUMBER			Variance material cost
VARIANCE_LABOR_COST	NUMBER			Variance labor cost
VARIANCE_EQUIPMENT_COST	NUMBER			Variance equipment cost

Query Text

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


SELECT MAINT_COST_CATEGORY
,      COST_CATEGORY_MEANING
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      PERIOD_START_DATE
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      ACTUAL_TOTAL_COST
,      ACTUAL_MATERIAL_COST
,      ACTUAL_LABOR_COST
,      ACTUAL_EQUIPMENT_COST
,      ESTIMATED_TOTAL_COST
,      ESTIMATED_MATERIAL_COST
,      ESTIMATED_LABOR_COST
,      ESTIMATED_EQUIPMENT_COST
,      VARIANCE_TOTAL_COST
,      VARIANCE_MATERIAL_COST
,      VARIANCE_LABOR_COST
,      VARIANCE_EQUIPMENT_COST
FROM APPS.WIP_EAM_COST_DETAILS_V;

Dependencies

[top of page]

APPS.WIP_EAM_COST_DETAILS_V references the following:

APPS: MFG_LOOKUPS; WIP_EAM_PERIOD_BALANCES

APPS.WIP_EAM_COST_DETAILS_V is not referenced by any database object