GMI ABC Rank Selection

Description
Categories: BI Publisher, Manufacturing
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 Name SQL text Validation
Non Block Sql
 
LOV Oracle
P orgn
 
Select Criteria
 
LOV Oracle
To Rank
 
LOV Oracle
From Rank
 
LOV Oracle
To_Whse
 
LOV Oracle
From_Whse
 
LOV Oracle
Order
 
LOV Oracle
Sort By
 
LOV Oracle
Ask a question