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
Run
GMI Inventory Location Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |