INV Item statuses

➜ Back to Library
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
Run INV Item statuses and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
ECC Procurement, Purchase Orders EAM Work Orders ECC Procurement, Agreements ECC Project Procurement, Item Summary PO Headers and Lines 11i XXT OF: PO Headers and Lines ECC Procurement, Indirect Procurement, SQL4 ECC Procurement, Indirect Procurement, SQL1 CAC Calculate ICP PII Item Costs
Blitz Report™

Blitz Report™ provides multiple benefits: