CST Discrete Job Value Report - Average/FIFO/LIFO Costing

Description
Categories: BI Publisher
Imported from BI Publisher
Description: WIP Discrete Job Value Report - Average/FIFO/LIFO Costing
Application: Bills of Material
Source: Discrete Job Value Report - Average/FIFO/LIFO Costing (XML)
Short Name: CSTRDJVA_XML
DB package: BOM_CSTRDJVA_XMLP_PKG
Run CST Discrete Job Value Report - Average/FIFO/LIFO Costing and other Oracle EBS reports with Blitz Report™ on our demo environment
select 
       wdj.wip_entity_id cum_entity_id,
       wdj.organization_id cum_org_id,
       ml_elem_type.meaning elem_var_type,
       null acct_no,
       sum(round(decode(ml_elem_type.lookup_code,
            1, nvl(wpb.pl_material_in,0),
            2, nvl(wpb.pl_material_overhead_in,0),
            3, (nvl(wpb.pl_resource_in,0) + nvl(wpb.tl_resource_in,0)),
            4, (nvl(wpb.pl_outside_processing_in,0) + 
                  nvl(wpb.tl_outside_processing_in,0)),
            5, (nvl(wpb.pl_overhead_in,0) + nvl(wpb.tl_overhead_in,0)),
            NULL)*:lp_exchange_rate, :PRECISION))                                  costs_in,
       sum(round(decode(ml_elem_type.lookup_code, 
            1, (nvl(wpb.pl_material_out,0) + nvl(wpb.tl_material_out,0)),   
            2, (nvl(wpb.pl_material_overhead_out,0) + 
                  nvl(wpb.tl_material_overhead_out,0)), 
            3, (nvl(wpb.pl_resource_out,0) + nvl(wpb.tl_resource_out,0)), 
            4, (nvl(wpb.pl_outside_processing_out,0) + 
                  nvl(wpb.tl_outside_processing_out,0)), 
            5, (nvl(wpb.pl_overhead_out,0) + nvl(wpb.tl_overhead_out,0)), 
            NULL)*:lp_exchange_rate, :PRECISION))                                 costs_out,
       sum(round(decode(ml_elem_type.lookup_code,  
            1, (nvl(wpb.pl_material_var,0) + nvl(wpb.tl_material_var,0)),    
            2, (nvl(wpb.pl_material_overhead_var,0) + 
                  nvl(wpb.tl_material_overhead_var,0)),  
            3, (nvl(wpb.pl_resource_var,0) + nvl(wpb.tl_resource_var,0)),  
            4, (nvl(wpb.pl_outside_processing_var,0) + 
                  nvl(wpb.tl_outside_processing_var,0)),             
            5, (nvl(wpb.pl_overhead_var,0) + nvl(wpb.tl_overhead_var,0)),  
            NULL)*:lp_exchange_rate, :PRECISION))                                 costs_var,
       sum(round(decode(ml_elem_type.lookup_code,
            1, (nvl(wpb.pl_material_in,0) - 
                nvl(wpb.pl_material_out,0) - nvl(wpb.tl_material_out,0)),
            2, (nvl(wpb.pl_material_overhead_in,0) -
                nvl(wpb.pl_material_overhead_out,0) - 
                nvl(wpb.tl_material_overhead_out,0)),
            3, (nvl(wpb.pl_resource_in,0) + nvl(wpb.tl_resource_in,0) - 
                nvl(wpb.pl_resource_out,0) - nvl(wpb.tl_resource_out,0)),
            4, (nvl(wpb.pl_outside_processing_in,0) + 
                nvl(wpb.tl_outside_processing_in,0) -
                nvl(wpb.pl_outside_processing_out,0) - 
                nvl(wpb.tl_outside_processing_out,0)),
            5, (nvl(wpb.pl_overhead_in,0) + nvl(wpb.tl_overhead_in,0) -
                nvl(wpb.pl_overhead_out,0) - nvl(wpb.tl_overhead_out,0)),  
            NULL)*:lp_exchange_rate, :PRECISION))                                period_act,
       sum(round(decode(ml_elem_type.lookup_code,  
            6, nvl(wpb.tl_material_var,0) + 
               nvl(wpb.tl_material_overhead_var,0) +
               nvl(wpb.pl_material_var,0) +
               nvl(wpb.pl_material_overhead_var,0) + 
               nvl(wpb.pl_resource_var,0) + nvl(wpb.pl_overhead_var,0) +
               nvl(wpb.pl_outside_processing_var,0),
            7, nvl(wpb.tl_resource_var,0),
            8, nvl(wpb.tl_outside_processing_var,0),
            9, nvl(wpb.tl_overhead_var,0),
            NULL)*:lp_exchange_rate, :PRECISION))                               single_level, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_ACCT1
from
     wip_period_balances wpb,
     wip_discrete_jobs wdj,
     gl_code_combinations gcc,
     mfg_lookups ml_elem_type
where
          wdj.wip_entity_id = wpb.wip_entity_id
and    wpb.organization_id = :org_id
and   ml_elem_type.lookup_type = 'WIP_ELEMENT_VAR_TYPE'
and   decode(ml_elem_type.lookup_code, 
             1, wdj.material_account,
             2, wdj.material_overhead_account,
             3, wdj.resource_account,
             4, wdj.outside_processing_account,
             5, wdj.overhead_account,
             6, wdj.material_variance_account,
             7, wdj.resource_variance_account,
             8, wdj.outside_proc_variance_account,
             9, wdj.overhead_variance_account) = gcc.code_combination_id 
 and wdj.wip_entity_id=:parent_entity_id 
 and wdj.organization_id=:parent_org_id
group by wdj.wip_entity_id,
          wdj.organization_id ,
         ml_elem_type.meaning,
         fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),
         ml_elem_type.lookup_code
order by ml_elem_type.lookup_code
Parameter Name SQL text Validation
Job Selection
 
LOV Oracle
Cost Group
 
LOV Oracle
Sort By
 
LOV Oracle
Report Type
 
LOV Oracle
Class Type
 
LOV Oracle
Include Bulk
 
LOV Oracle
Include Vendor
 
LOV Oracle
Classes From
 
LOV Oracle
To
 
LOV Oracle
Jobs From
 
LOV Oracle
To 2
 
LOV Oracle
Status
 
LOV Oracle
Assemblies From
 
Char
To 3
 
Char
Currency
 
LOV Oracle
Exchange Rate
 
LOV Oracle
Blitz Report™