INV Item statuses

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item statuses report
Application: Inventory
Source: Item statuses report (XML)
Short Name: INVIRDIS_XML
DB package: INV_INVIRDIS_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Display and Break on Category
 
LOV Oracle
Category Set
 
LOV Oracle
Categories From
 
Char
To
 
Char
Items From
 
Char
To 2
 
Char
Status Effective Date
 
Date
Item Status
 
LOV Oracle