INV Item categories

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item categories report
Application: Inventory
Source: Item categories report (XML)
Short Name: INVIRCAT_XML
DB package: INV_INVIRCAT_XMLP_PKG
Run INV Item categories and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT
   null    item_flexdata,
   msi.description     item_description,
   micat.inventory_item_id            item_id,
   mcats.category_set_name   catg_set_name,
   mcats.structure_id           catg_struct_num,
  null   catg_flexdata,
   mcat.category_id                     catg_id,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE,
--fnd_flex_xml_publisher_apis.process_kff_combination_1('C_CATG_VALUE', 'INV', 'MICAT',  mcats.structure_id , micat.ORGANIZATION_ID, micat.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_CATG_VALUE
fnd_flex_xml_publisher_apis.process_kff_combination_1('c_catg_value', 'INV', 'MCAT', mcat.STRUCTURE_ID, NULL, mcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_CATG_VALUE
FROM
   mtl_system_items_vl         msi,
   mtl_category_sets         mcats,
   mtl_categories            mcat ,
   mtl_item_categories       micat
WHERE
&P_CATG_WHERE
and  micat.category_id = mcat.category_id
and  micat.category_set_id = mcats.category_set_id
and  (:P_CATG_SET_ID IS NULL  OR
          MICAT.CATEGORY_SET_ID  =  :P_CATG_SET_ID)
 and  &P_ITEM_WHERE
and msi.organization_id = micat.organization_id
and  micat.organization_id = :P_org
and micat.inventory_item_id =  msi.inventory_item_id
order by
&P_ITEM_ORDER_BY, mcats.category_set_name, &P_CATG_ORDER_BY
Parameter Name SQL text Validation
Category Set 
 
 LOV Oracle
Categories From 
 
 Char
To 
 
 Char
Items From 
 
 Char
To 2 
 
 Char
Download
 
Related Blitz Reports
CST Detailed Item Cost CAC Calculate ICP PII Item Costs CAC Intercompany SO Price List vs. Item Cost Comparison CAC Receiving Account Summary No SLA CAC Receiving Account Detail No SLA CAC ICP PII Inventory and Intransit Value (Period-End) CST Item Costs CAC Inventory and Intransit Value (Period-End) CST Item Cost Reports
Blitz Report™

Blitz Report™ provides multiple benefits: