GMI Warehouse Detail

➜ Back to Library
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