CST Elemental Cost

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Elemental Cost Report
Application: Bills of Material
Source: Elemental Cost Report (XML)
Short Name: CSTRELCRG_XML
DB package: BOM_CSTRELCR_XMLP_PKG
Run CST Elemental Cost and other Oracle EBS reports with Blitz Report™ on our demo environment
select
                   null item_data,
                   null cat_data,
                   mc.description cat_desc,
                   msi.description item_desc,
                   msi.primary_uom_code,
                   round(cic.material_cost * :P_EXCHANGE_RATE , :ext_precision_saved)  material_cost,
                   round(cic.material_overhead_cost * :P_EXCHANGE_RATE, :ext_precision_saved) mat_ovhd,
                   round(cic.resource_cost * :P_EXCHANGE_RATE, :ext_precision_saved) resrc_cost,
                   round(cic.outside_processing_cost * :P_EXCHANGE_RATE, :ext_precision_saved) out_proc,
                   round(cic.overhead_cost * :P_EXCHANGE_RATE, :ext_precision_saved) ovhd_cost,
                   round(cic.item_cost* :P_EXCHANGE_RATE , :ext_precision_saved) unit_cost,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEXPAD_ITEM,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEXPAD_CAT,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_CAT,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_ITEM,
                --BOM_CSTRELCR_XMLP_PKG.order_func(:C_FLEXPAD_ITEM, :C_FLEXPAD_CAT) C_ORDER,
                BOM_CSTRELCR_XMLP_PKG.order_func(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE')) C_ORDER
            from mtl_system_items_vl msi,
                 mtl_parameters mp,
                 mtl_item_categories mic,
                 mtl_categories mc,
                 cst_item_costs cic
            where msi.organization_id = :org_id
            and   mp.organization_id = :org_id
            and   cic.cost_type_id = :cost_type_id
            and   cic.inventory_item_id = msi.inventory_item_id
            and   cic.organization_id = mp.cost_organization_id
            and   mic.inventory_item_id = cic.inventory_item_id
            and   mic.organization_id = :org_id
            and   mic.category_id  = mc.category_id
            and   mic.category_set_id = :P_CATEGORY_SET
            and   &P_WHERE_ITEM
            and   &P_WHERE_CAT
            and   &WHERE_ZERO
            group by
                  &P_FLEXDATA_ITEM, &P_FLEXDATA_CAT,
                  mic.category_id, msi.description,
                  msi.primary_uom_code, cic.material_cost,
                  cic.material_overhead_cost, cic.resource_cost,
                  cic.outside_processing_cost, cic.overhead_cost,
                  cic.item_cost, mc.description,
                  fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'),
				  fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE'),
				  fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'),
                  fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')
            order by C_ORDER, cat_desc, C_FLEXPAD_ITEM
Parameter Name SQL text Validation
Report Sort Option 
 
 LOV Oracle
Zero Cost Only 
 
 LOV Oracle
Cost Type 
 
 LOV Oracle
Item From 
 
 Char
To 
 
 Char
Category Set 
 
 LOV Oracle
Category From 
 
 Char
To 2 
 
 Char
Currency 
 
 LOV Oracle
Exchange Rate 
 
 LOV Oracle
Download
Related Blitz Reports
CST Detailed Item Cost INV Onhand Quantities XXT OF: PO Headers and Lines CAC Inventory Pending Cost Adjustment PO Receiving Transactions Pipeline CAC Calculate ICP PII Item Costs CAC Intercompany SO Price List vs. Item Cost Comparison CAC ICP PII Inventory and Intransit Value (Period-End) CAC Inventory and Intransit Value (Period-End)
Blitz Report™

Blitz Report™ provides multiple benefits: