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

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Download
 
Related Blitz Reports
WIP Value WIP Expense Job Value CAC Manufacturing Variance Detail CAC WIP Account Value CAC Manufacturing Variance Summary CAC Inventory to G/L Reconciliation (Restricted by Org Access) CAC WIP Jobs With Complete Status But Not Ready for Close CAC WIP Period Balances to Accounting Activity Reconciliation CAC WIP Jobs With Complete Status Which Are Ready for Close
Blitz Report™

Blitz Report™ provides multiple benefits: