GMI Lot Status Master

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Lot Status Master Report of OPM IC
Application: Process Manufacturing Inventory
Source: Lot Status Master Report (XML)
Short Name: RILSM_XML
DB package: GMI_RILSM_XMLP_PKG
Run GMI Lot Status Master and other Oracle EBS reports with Blitz Report™ on our demo environment
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
From Status 
 
 LOV Oracle
To Status 
 
 LOV Oracle
Select Criteria 
 
 LOV Oracle
Order By 
 
 LOV Oracle
Download
Related Blitz Reports
MSC Pegging Hierarchy GMI Cycle Count Forms GMI Inventory Edit Journal GMI Lot Master GMI Lot Inventory GMI Inventory Transfer GML PO/Stock Return History CAC Intercompany SO Price List vs. Item Cost Comparison GMI Inventory Transfer Report By Batch
Blitz Report™

Blitz Report™ provides multiple benefits: