GMI Warehouse Detail

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Process Manufacturing Inventory
Source
Warehouse Detail Report (XML)
Short Name
RIWHM_XML
DB package
GMI_RIWHM_XMLP_PKG
Imported from BI Publisher
Warehouse Detail Report of OPM IC

SQL 6 lines

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

Parameters 11

ParameterTypeList of values SQL
OrganizationLOV Oracle
Sort ByLOV Oracle
Order ByLOV Oracle
From WhseLOV Oracle
To WhseLOV Oracle
From DescriptionLOV Oracle
To DescriptionLOV Oracle
From RegionLOV Oracle
To RegionLOV Oracle
From ClassLOV Oracle
To ClassLOV Oracle