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
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 |