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

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 GMI Inventory Transfer Report By Batch GMI Daily Transaction Detail GML Ship Picklist GML Unallocated Orders Report (OPM - OM) GMI Cycle Count Forms GMI Daily Item Usage GMI Lot Inventory GMI Warehouse Inventory GML Sales Order Audit Trail