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