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_OP_COST_DETAILS_V

Object Details

Object Name:	WIP_EAM_OP_COST_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_OP_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
DEPARTMENT_CODE	VARCHAR2	(10)	Yes	Code for owning department of the work order
OPERATION_SEQ_NUM	NUMBER			Operation sequence number
PERIOD_START_DATE	DATE		Yes	Accounting period start date
MAINT_COST_CATEGORY	NUMBER		Yes	Maintenance cost category
WIP_ENTITY_ID	NUMBER		Yes	Work order identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ACTUAL_MAT_COST	NUMBER			Actual material cost
ACTUAL_LAB_COST	NUMBER			Actual lab cost
ACTUAL_EQP_COST	NUMBER			Actual equipment cost
SYSTEM_ESTIMATED_MAT_COST	NUMBER			System estimated material cost
SYSTEM_ESTIMATED_LAB_COST	NUMBER			System estimated labor cost
SYSTEM_ESTIMATED_EQP_COST	NUMBER			System estimated equipment cost
MANUAL_ESTIMATED_MAT_COST	NUMBER			Manual estimated material cost
MANUAL_ESTIMATED_LAB_COST	NUMBER			Manual estimated labor cost
MANUAL_ESTIMATED_EQP_COST	NUMBER			Manual estimated equipment cost
VARIANCE_MAT_COST	NUMBER			Variance material cost
VARIANCE_LAB_COST	NUMBER			Variance labor cost
VARIANCE_EQP_COST	NUMBER			Variance equipment cost
TOTAL_ACTUAL_COST	NUMBER			Total actual cost
TOTAL_SYSTEM_ESTIMATED_COST	NUMBER			Total system estimated cost
TOTAL_VARIANCE_COST	NUMBER			Total variance cost

Query Text

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


SELECT DEPARTMENT_CODE
,      OPERATION_SEQ_NUM
,      PERIOD_START_DATE
,      MAINT_COST_CATEGORY
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      ACTUAL_MAT_COST
,      ACTUAL_LAB_COST
,      ACTUAL_EQP_COST
,      SYSTEM_ESTIMATED_MAT_COST
,      SYSTEM_ESTIMATED_LAB_COST
,      SYSTEM_ESTIMATED_EQP_COST
,      MANUAL_ESTIMATED_MAT_COST
,      MANUAL_ESTIMATED_LAB_COST
,      MANUAL_ESTIMATED_EQP_COST
,      VARIANCE_MAT_COST
,      VARIANCE_LAB_COST
,      VARIANCE_EQP_COST
,      TOTAL_ACTUAL_COST
,      TOTAL_SYSTEM_ESTIMATED_COST
,      TOTAL_VARIANCE_COST
FROM APPS.WIP_EAM_OP_COST_DETAILS_V;

Dependencies

[top of page]

APPS.WIP_EAM_OP_COST_DETAILS_V references the following:

APPS: BOM_DEPARTMENTS; WIP_EAM_PERIOD_BALANCES

APPS.WIP_EAM_OP_COST_DETAILS_V is not referenced by any database object