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

➜ Back to Library
Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Discrete Job Value Report - Average/FIFO/LIFO Costing (XML)
Short Name: CSTRDJVA_XML
DB package: BOM_CSTRDJVA_XMLP_PKG 
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
CST_SRS_RATE_TYPE 
 
 Number
CST_SRS_INVERSE_RATE 
 
Submitted by 
 
Quantity Precision 
 
 Number
Account Period Id 
 
 Number
Account Structure 
 
 Number
Organization Id 
 
 Number
CST_SRS_COST_GROUP_DUMMY 
 
 Number
CST_SRS_JOB_SEL_DUMMY 
 
 Number
Exchange Rate 
 
 LOV Oracle
Currency 
 
 LOV Oracle
To 
 
Assemblies From 
 
Status 
 
 LOV Oracle
To 
 
 LOV Oracle
Jobs From 
 
 LOV Oracle
To 
 
 LOV Oracle
Classes From 
 
 LOV Oracle
Include Vendor 
 
 LOV Oracle
Include Bulk 
 
 LOV Oracle
Class Type 
 
 LOV Oracle
Report Type 
 
 LOV Oracle
Sort By 
 
 LOV Oracle
Cost Group 
 
 LOV Oracle
Job Selection 
 
 LOV Oracle
Ask a question
Download
Related Blitz Reports
WIP Value WIP Expense Job Value WIP Accounts Distribution Detail Report CST Periodic WIP Distribution Details CST Activity Cause CST Work Order Cost WIP Account Distribution (1) WIP Discrete Job Data Inventory Reconciliation
Related Topics
CST Period Close Subinventory ValueCST Periodic Accrual ReconciliationCST Activity CauseCST Periodic WIP Distribution DetailsCST Periodic Material and Receiving Distribution DetailsCST Inventory SubledgerCST Inventory Subledger (1)CST Create Accounting - Cost ManagementCST Historical Inventory Standard Cost Adjustment Report - Warehouse ManagementCST Inventory Master Book
Blitz Report In Action