CST Department Actual Cost

select
                bd.department_code Det_Dept,
                nvl(nvl(wdj.rebuild_serial_number, wdj.asset_number), 'Not Applicable') Asset_Num,
                we.wip_entity_name Work_Order,
                we.description Work_Ord_Desc,
                to_char(wdj.date_released, 'DD-MON-YYYY') Start_Date,
                to_char(wdj.date_completed, 'DD-MON-YYYY') Comp_Date,
                round(sum(nvl(wepb.actual_mat_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Material,
                round(sum(nvl(wepb.actual_lab_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Labor,
                round(sum(nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Equip,
                round(sum(nvl(wepb.actual_mat_cost,0) + nvl(wepb.actual_lab_cost,0) + nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Total
            from
                bom_departments bd,
                wip_eam_period_balances wepb,
                wip_discrete_jobs wdj,
                wip_entities we
            where
                wdj.organization_id = :P_ORG_ID
            and bd.department_id = wdj.owning_department
            &P_DEPT_WHERE
            and wdj.status_type in (3,4,5,12)
            and we.wip_entity_id= wdj.wip_entity_id
            and we.entity_type in (6,7)
            and wdj.wip_entity_id = wepb.wip_entity_id
            and wdj.organization_id = wepb.organization_id
            &P_PERIOD_WEPB_WHERE
            group by
                bd.department_code,
                nvl(nvl(wdj.rebuild_serial_number,wdj.asset_number),'Not Applicable'),
                we.wip_entity_name,
                we.description,
                wdj.date_released,
                wdj.date_completed
            order by Det_Dept, Asset_Num, Work_Order