CST Item Cost Reports

Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Item Cost Reports (XML)
Short Name: CSTRFICRG_XML
DB package: BOM_CSTRFICR_XMLP_PKG
select
                   null item_data,
                   null cat_data,
                   msi.description item_desc,
                   msi.primary_uom_code uom_code,
                   msi.inventory_item_status_code inv_stt_code,
                   &QRY_COLUMN1 column1_data,
                   &QRY_COLUMN2 column2_data,
                   round(sum(decode(cdcv.level_type,1,cdcv.item_cost,0)),
                                                    :ext_precision_saved) this_level,
                   round(sum(decode(cdcv.level_type, 2,cdcv.item_cost,0)),
                                                    :ext_precision_saved) prev_level,
                   round(sum(cdcv.item_cost), :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_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_ITEM,
                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,
                --BOM_CSTRFICR_XMLP_PKG.order_func(:C_FLEXPAD_ITEM, :C_FLEXPAD_CAT) C_ORDER
                BOM_CSTRFICR_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,
                 cst_detail_cost_view cdcv,
                 mtl_parameters mp,
                 mtl_categories mc,
                 mtl_item_categories mic
            where mp.organization_id = :org_id
            and   msi.organization_id = :org_id
            and   cdcv.inventory_item_id = msi.inventory_item_id
            and   cdcv.organization_id = mp.cost_organization_id
            and   cdcv.cost_type_id = :cost_type_id
            and   mic.inventory_item_id = cdcv.inventory_item_id
            and   mic.organization_id = :org_id
            and   mic.category_set_id = :P_CATEGORY_SET
            and   mic.category_id = mc.category_id
            and   mc.structure_id = :P_STRUCT_NUM
            and   &P_WHERE_ITEM
            and   &P_WHERE_CAT
            group by
                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_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', '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'),
                  msi.description,
                  msi.primary_uom_code,
                  msi.inventory_item_status_code,
                  &QRY_COLUMN1, &QRY_COLUMN2
            order by 15
Parameter Name SQL text Validation
View Cost Privilege
 
Number
Category Structure
 
Number
Organization Id
 
Number
Report Template
 
LOV Oracle
Flexfield Option
 
LOV Oracle
Report Name
 
LOV Oracle
To
 
Category From
 
Category Set
 
LOV Oracle
To
 
Item From
 
Cost Type
 
LOV Oracle
CST_SRS_BOM_OR_ENG
 
Report Sort Option
 
LOV Oracle