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
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 |
