GMI Warehouse Detail
Description
Categories: BI Publisher
Application: Process Manufacturing Inventory
Source: Warehouse Detail Report (XML)
Short Name: RIWHM_XML
DB package: GMI_RIWHM_XMLP_PKG
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 | |
---|---|---|---|
Organization | LOV Oracle | ||
Sort By | LOV Oracle | ||
Order By | LOV Oracle | ||
From Whse | LOV Oracle | ||
To Whse | LOV Oracle | ||
From Description | LOV Oracle | ||
To Description | LOV Oracle | ||
From Region | LOV Oracle | ||
To Region | LOV Oracle | ||
From Class | LOV Oracle | ||
To Class | LOV Oracle | ||
User Id | Number | ||
Non Block Sql | LOV Oracle |