INV Item categories

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Item categories report (XML)
Short Name: INVIRCAT_XML
DB package: INV_INVIRCAT_XMLP_PKG
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 Structure
 
Number
Sort By
 
Number
Organization
 
Number
To
 
Items From
 
To
 
Categories From
 
Category Set
 
LOV Oracle
Ask a question