CST Work Order Cost

select
                bd.department_code WD_Dept,
                we.wip_entity_name WD_Work_Order,
                msi.concatenated_segments WD_Ass_Act,
                we.description WD_Work_Ord_Desc,
                to_char(wdj.date_released, 'DD-MON-YYYY') WD_Start_Date,
                to_char(wdj.date_completed, 'DD-MON-YYYY') WD_Compl_Date,
                ml.meaning WD_Cost_Category,
                round(sum(nvl(wepb.system_estimated_mat_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Mat,
                round(sum(nvl(wepb.actual_mat_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Mat,
                round(sum(nvl(wepb.system_estimated_lab_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Lab,
                round(sum(nvl(wepb.actual_lab_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Lab,
                round(sum(nvl(wepb.system_estimated_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Eqp,
                round(sum(nvl(wepb.actual_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Eqp,
                 round(sum(nvl(wepb.system_estimated_mat_cost,0) + nvl(wepb.system_estimated_lab_cost,0) + nvl(wepb.system_estimated_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Total,
                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) * :P_ROUND_UNIT WD_Act_Total
            from
                bom_departments bd,
                wip_eam_period_balances wepb,
                wip_discrete_jobs wdj,
                wip_entities we,
                mtl_system_items_kfv msi,
                mfg_lookups ml
            where
                wdj.organization_id = :P_ORG_ID
            and bd.department_id = wdj.owning_department
            &P_DEPT_WHERE
            and we.wip_entity_id= wdj.wip_entity_id
            and we.entity_type in (6,7)
            and wdj.status_type in (3,4,5,12)
            and wdj.organization_id = msi.organization_id(+)
            and wdj.primary_item_id = msi.inventory_item_id(+)
            &P_PERIOD_WEPB_WHERE
            and ml.lookup_type = 'BOM_EAM_COST_CATEGORY'
            and ml.lookup_code = wepb.maint_cost_category
            and wdj.wip_entity_id = wepb.wip_entity_id
            and wdj.organization_id = wepb.organization_id
            and wdj.scheduled_completion_date >= wepb.period_start_date
            group by
                bd.department_code,
                we.wip_entity_name,
                we.description,
                msi.concatenated_segments,
                wdj.date_released,
                wdj.date_completed,
                ml.meaning
            order by WD_Dept, WD_Work_Order