GMI ABC Rank Selection

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: ABC Rank Selection Report of OPM PI
Application: Process Manufacturing Inventory
Source: ABC Rank Selection Report (XML)
Short Name: PIR01_XML
DB package: GMI_PIR01_XMLP_PKG
Run GMI ABC Rank Selection and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 	 
	r.whse_code,
	r.abc_code,
	r.rank_desc,
	r.cnt_intrvl,
	r.percent_warn,
	r.percent_reject,
	r.value_warn,
	r.value_reject,
	r.acceptwarn_ind,
	r.acceptreject_ind,
	r.delete_mark,
	w.whse_name
FROM		ic_rank_mst r,ic_whse_mst w
WHERE		r.whse_code = w.whse_code
AND		 &RangeCF
AND		 	        r.delete_mark=decode(:select_criteria,'1',0,'2',1,'3',r.delete_mark,0)
ORDER BY  &OrdCF
Parameter Name SQL text Validation
Sort By 
 
 LOV Oracle
Order 
 
 LOV Oracle
From_Whse 
 
 LOV Oracle
To_Whse 
 
 LOV Oracle
From Rank 
 
 LOV Oracle
To Rank 
 
 LOV Oracle
Select Criteria 
 
 LOV Oracle
Download
Related Blitz Reports
GMI Inventory Transfer GML Sales Order Audit Trail GMI Inventory Location Detail GML Unallocated Orders GMI Lot Inventory GMI Daily Transaction Detail GMI Warehouse Detail GMI Inventory Transfer Report By Batch GMI Cycle Count Forms
Blitz Report™

Blitz Report™ provides multiple benefits: