[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.WIP_EAM_OP_COST_DETAILS_V is not referenced by any database object
|
|
|