GMI Lot Status Master
Description
- Categories
- BI Publisher
- Application
- Process Manufacturing Inventory
- Source
- Lot Status Master Report (XML)
- Short Name
- RILSM_XML
- DB package
- GMI_RILSM_XMLP_PKG
Imported from BI Publisher
Lot Status Master Report of OPM IC
Lot Status Master Report of OPM IC
SQL 15 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| From Status | LOV Oracle | |
| To Status | LOV Oracle | |
| Select Criteria | LOV Oracle | |
| Order By | LOV Oracle |