CST Work Order Cost

Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Work Order Cost Report (XML)
Short Name: CSTRWOCR_XML
DB package: BOM_CSTRWOCR_XMLP_PKG
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
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
Cost Ceiling
 
Number
Department To
 
LOV Oracle
Department From
 
LOV Oracle
Report Type
 
LOV Oracle
Ask a question