GMI Warehouse Detail

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Inventory
Source: Warehouse Detail Report (XML)
Short Name: RIWHM_XML
DB package: GMI_RIWHM_XMLP_PKG
select whse_code,whse_name,region_code,whse_contact,whse_phone,whse_class
from ic_whse_mst
where &LexPrmCP
and orgn_code=:p_orgn 
order by &LexOrdCF
Parameter Name SQL text Validation
Non Block Sql
 
LOV Oracle
User Id
 
Number
To Class
 
LOV Oracle
From Class
 
LOV Oracle
To Region
 
LOV Oracle
From Region
 
LOV Oracle
To Description
 
LOV Oracle
From Description
 
LOV Oracle
To Whse
 
LOV Oracle
From Whse
 
LOV Oracle
Order By
 
LOV Oracle
Sort By
 
LOV Oracle
Organization
 
LOV Oracle