GMI Inventory Location Detail
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inventory Location Detail Report of OPM IC
Application: Process Manufacturing Inventory
Source: Inventory Location Detail Report (XML)
Short Name: RILOC_XML
DB package: GMI_RILOC_XMLP_PKG
Description: Inventory Location Detail Report of OPM IC
Application: Process Manufacturing Inventory
Source: Inventory Location Detail Report (XML)
Short Name: RILOC_XML
DB package: GMI_RILOC_XMLP_PKG
select whse_code Whse, Location, loct_desc Description, Capacity, capacity_um from ic_loct_mst where &LexPrmCP and delete_mark = decode(:select_criteria,'Active',0,'Deleted',1,'All',delete_mark,0) and location!= (select fnd_profile.value_WNPS('IC$DEFAULT_LOCT') from dual) and whse_code in (select whse_code from ic_whse_mst a, sy_orgn_usr b where a.orgn_code=b.orgn_code and b.user_id=:user_id and a.delete_mark=0 and a.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 Location | LOV Oracle | ||
To Location | LOV Oracle | ||
Select Criteria | LOV Oracle | ||
DebugFlag | Char |