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

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 	 
	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: