VIEW: APPS.WIP_EAM_OP_COST_DETAILS_V

Source

View Text - Preformatted

SELECT bd.department_code, wepb.operation_seq_num, wepb.period_start_date, wepb.maint_cost_category, wepb.wip_entity_id, wepb.organization_id, SUM(wepb.actual_mat_cost), SUM(wepb.actual_lab_cost), SUM(wepb.actual_eqp_cost), SUM(wepb.system_estimated_mat_cost) , SUM(wepb.system_estimated_lab_cost), SUM(wepb.system_estimated_eqp_cost), SUM(wepb.manual_estimated_mat_cost), SUM(wepb.manual_estimated_lab_cost), SUM(wepb.manual_estimated_eqp_cost), (- SUM(wepb.actual_mat_cost) + SUM(wepb.system_estimated_mat_cost)), (- SUM(wepb.actual_lab_cost) + SUM(wepb.system_estimated_lab_cost)), (- SUM(wepb.actual_eqp_cost) + SUM(wepb.system_estimated_eqp_cost)), (SUM(wepb.actual_mat_cost) + SUM(wepb.actual_lab_cost) + SUM(wepb.actual_eqp_cost)), (SUM(wepb.system_estimated_mat_cost) + SUM(wepb.system_estimated_lab_cost) + SUM(wepb.system_estimated_eqp_cost)), ( - SUM(wepb.actual_mat_cost) - SUM(wepb.actual_lab_cost) - SUM(wepb.actual_eqp_cost) + SUM(wepb.system_estimated_mat_cost) + SUM(wepb.system_estimated_lab_cost) + SUM(wepb.system_estimated_eqp_cost)) FROM wip_eam_period_balances wepb, bom_departments bd WHERE bd.department_id = wepb.owning_dept_id GROUP BY wepb.operation_seq_num, bd.department_code, wepb.period_start_date, wepb.maint_cost_category, wepb.wip_entity_id, wepb.organization_id

View Text - HTML Formatted

SELECT BD.DEPARTMENT_CODE
, WEPB.OPERATION_SEQ_NUM
, WEPB.PERIOD_START_DATE
, WEPB.MAINT_COST_CATEGORY
, WEPB.WIP_ENTITY_ID
, WEPB.ORGANIZATION_ID
, SUM(WEPB.ACTUAL_MAT_COST)
, SUM(WEPB.ACTUAL_LAB_COST)
, SUM(WEPB.ACTUAL_EQP_COST)
, SUM(WEPB.SYSTEM_ESTIMATED_MAT_COST)
, SUM(WEPB.SYSTEM_ESTIMATED_LAB_COST)
, SUM(WEPB.SYSTEM_ESTIMATED_EQP_COST)
, SUM(WEPB.MANUAL_ESTIMATED_MAT_COST)
, SUM(WEPB.MANUAL_ESTIMATED_LAB_COST)
, SUM(WEPB.MANUAL_ESTIMATED_EQP_COST)
, (- SUM(WEPB.ACTUAL_MAT_COST) + SUM(WEPB.SYSTEM_ESTIMATED_MAT_COST))
, (- SUM(WEPB.ACTUAL_LAB_COST) + SUM(WEPB.SYSTEM_ESTIMATED_LAB_COST))
, (- SUM(WEPB.ACTUAL_EQP_COST) + SUM(WEPB.SYSTEM_ESTIMATED_EQP_COST))
, (SUM(WEPB.ACTUAL_MAT_COST) + SUM(WEPB.ACTUAL_LAB_COST) + SUM(WEPB.ACTUAL_EQP_COST))
, (SUM(WEPB.SYSTEM_ESTIMATED_MAT_COST) + SUM(WEPB.SYSTEM_ESTIMATED_LAB_COST) + SUM(WEPB.SYSTEM_ESTIMATED_EQP_COST))
, ( - SUM(WEPB.ACTUAL_MAT_COST) - SUM(WEPB.ACTUAL_LAB_COST) - SUM(WEPB.ACTUAL_EQP_COST) + SUM(WEPB.SYSTEM_ESTIMATED_MAT_COST) + SUM(WEPB.SYSTEM_ESTIMATED_LAB_COST) + SUM(WEPB.SYSTEM_ESTIMATED_EQP_COST))
FROM WIP_EAM_PERIOD_BALANCES WEPB
, BOM_DEPARTMENTS BD
WHERE BD.DEPARTMENT_ID = WEPB.OWNING_DEPT_ID GROUP BY WEPB.OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE
, WEPB.PERIOD_START_DATE
, WEPB.MAINT_COST_CATEGORY
, WEPB.WIP_ENTITY_ID
, WEPB.ORGANIZATION_ID