GMI Warehouse Detail
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Warehouse Detail Report of OPM IC
Application: Process Manufacturing Inventory
Source: Warehouse Detail Report (XML)
Short Name: RIWHM_XML
DB package: GMI_RIWHM_XMLP_PKG
Description: Warehouse Detail Report of OPM IC
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 | |
---|---|---|---|
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 |