INV Item statuses

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Item statuses report (XML)
Short Name: INVIRDIS_XML
DB package: INV_INVIRDIS_XMLP_PKG
SELECT    decode(:P_break_id, 1,&P_cat_flex,'All Categories')
				C_cat_flex,
 	null		C_item_flex,
	msi.INVENTORY_ITEM_ID   	item_id,      
              msi.DESCRIPTION         	description,
	mpis.STATUS_CODE       	status_name,
         mpis.EFFECTIVE_DATE, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_field', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_cat_field, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_pad', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_cat_pad, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_pad', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_item_pad
FROM     
             MTL_SYSTEM_ITEMS_FVL  msi,  
             mtl_item_categories       mic,  mtl_categories mc,
             mtl_pending_item_status   	mpis
 WHERE   msi.ORGANIZATION_ID  = :C_morg_id
AND        mpis.ORGANIZATION_ID(+) = :C_morg_id
AND        msi.inventory_item_id = mpis.inventory_item_id (+)
AND  msi.inventory_item_id = mic.inventory_item_id
AND  mic.category_set_id =  :P_cat_set_id
AND   mic.organization_id = :C_morg_id 
AND   mic.category_id = mc.category_id
AND        &P_item_where
AND        &P_cat_where   &C_where_status  &C_where_stat_eff
&P_order_by
Parameter Name SQL text Validation
Category Structure
 
Number
Organization
 
Number
Item Status
 
LOV Oracle
Status Effective Date
 
Date
To
 
Items From
 
To
 
Categories From
 
Category Set
 
LOV Oracle
Display and Break on Category
 
LOV Oracle