Product: | WIP - Work in Process |
---|---|
Description: | Cost information by operation |
Implementation/DBA Data: | APPS.WIP_EAM_OP_COST_DETAILS_V |
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