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
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 NameSQL textValidation
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 (1) GML Unallocated Orders GMI Lot Inventory GMI Daily Transaction Detail GMI Warehouse Detail COPY OF: CAC OPM Batch Material Summary GMI Inventory Transfer Report By Batch GMI Cycle Count Forms GMI Inventory Transfer
Blitz Report™