Reports2017-11-18T12:27:27+00:00

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
By continuing to use the site, you agree to the use of cookies. Accept