GMI Inventory Location Detail

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

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