GMI Lot Status Master

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Inventory
Source: Lot Status Master Report (XML)
Short Name: RILSM_XML
DB package: GMI_RILSM_XMLP_PKG
select 
	lot_status 	Status,
	status_desc 	Description , 
	qchold_res_code	Reason_Code,
	Nettable_Ind 	Nettable,
	order_proc_ind 	Order_Proc,
	prod_ind 		Production,
	shipping_ind 	shipping,
	rejected_ind 	Rejected
from  	ic_lots_sts
where 	lot_status >= NVL(:From_Status,'0')
and 	lot_status<= NVL(:To_Status ,'zzzz')
and     	delete_mark=DECODE(:select_criteria,'All',delete_mark,'Deleted',1,0)
order by 	lot_status  &ORDERCF
Parameter Name SQL text Validation
Non Block Sql
 
LOV Oracle
P orgn
 
User Id
 
Number
Order By
 
LOV Oracle
Select Criteria
 
LOV Oracle
To Status
 
LOV Oracle
From Status
 
LOV Oracle