GMI Inventory Location Detail

➜ Back to Library
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
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
Download
Related Blitz Reports
GMI Lot Inventory GMI Warehouse Inventory GMI Inventory Transfer GMI Inventory Transfer Report By Batch GMI Daily Item Usage GMI Inventory Edit Journal GML PO/Stock Return History GML Bill Of Lading GML Unallocated Orders Report (OPM - OM)
Blitz Report™

Blitz Report™ provides multiple benefits: