CST Department Actual Cost

Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Department Actual Cost Report (XML)
Short Name: CSTRDACR_XML
DB package: BOM_CSTRDACR_XMLP_PKG
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
Parameter Name SQL text Validation
CST_SRS_RATE_TYPE
 
Number
CST_SRS_INVERSE_RATE
 
Organization ID
 
Number
Exchange Rate
 
LOV Oracle
Currency
 
LOV Oracle
Include OSP
 
LOV Oracle
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Department To
 
LOV Oracle
Department From
 
LOV Oracle
Report Type
 
LOV Oracle