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

Copy

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

Download

Related Blitz Reports

GMI Inventory Transfer GML Ship Picklist GMI Cycle Count Forms GMI Daily Transaction Detail GMI Inventory Transfer Report By Batch GMI Daily Item Usage GMI Inventory Location Detail GMI Lot Inventory GMI Inventory Edit Journal GMI ABC Rank Selection