CST Discrete Job Value Report - Average/FIFO/LIFO Costing
Description
Categories: BI Publisher
Columns: Cum Entity Id, Cum Org Id, Elem Var Type, Acct No, Costs In, Costs Out, Costs Var, Period Act, Single Level, C Flexfield Acct1 ...
Columns: Cum Entity Id, Cum Org Id, Elem Var Type, Acct No, Costs In, Costs Out, Costs Var, Period Act, Single Level, C Flexfield Acct1 ...
Application: Bills of Material
Source: Discrete Job Value Report - Average/FIFO/LIFO Costing (XML)
Short Name: CSTRDJVA_XML
DB package: BOM_CSTRDJVA_XMLP_PKG
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 | |
---|---|---|---|
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 | LOV Oracle | ||
Status | LOV Oracle | ||
Assemblies From | |||
To | |||
Currency | LOV Oracle | ||
Exchange Rate | LOV Oracle | ||
CST_SRS_JOB_SEL_DUMMY | Number | ||
CST_SRS_COST_GROUP_DUMMY | Number | ||
Organization Id | Number | ||
Account Structure | Number | ||
Account Period Id | Number | ||
Quantity Precision | Number | ||
Submitted by | |||
CST_SRS_INVERSE_RATE | |||
CST_SRS_RATE_TYPE | Number |