INV Item Default Locators

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github
Master data report of Inventory Items and the default locators for shipping, receiving or move order receipt transactions
Run INV Item Default Locators and other Oracle EBS reports with Blitz Report™ on our demo environment
select
msiv.concatenated_segments item,
msiv.description item_description,
xxen_util.meaning(mild.default_type,'MTL_DEFAULT_LOCATORS',700) default_type,
mil.subinventory_code subinventory,
inv_project.get_locator(mil.inventory_location_id,mil.organization_id) locator,
mil.description locator_description,
mp.organization_code,
haouv.name organization,
xxen_util.user_name(mild.created_by) created_by,
xxen_util.client_time(mild.creation_date) creation_date,
xxen_util.user_name(mild.last_updated_by) last_updated_by,
xxen_util.client_time(mild.last_update_date) last_update_date
from
hr_all_organization_units_vl haouv,
mtl_parameters mp,
mtl_item_loc_defaults mild,
mtl_system_items_vl msiv,
mtl_item_locations mil
where
1=1 and
haouv.organization_id=mild.organization_id and
mp.organization_id=mild.organization_id and
mild.inventory_item_id=msiv.inventory_item_id and
mild.organization_id=msiv.organization_id and
mild.organization_id=mil.organization_id and
mild.locator_id=mil.inventory_location_id
order by
msiv.concatenated_segments,
mp.organization_code,
default_type
Parameter Name SQL text Validation
Item
msiv.concatenated_segments like :item
LOV
Subinventory
mild.subinventory_code=:subinventory_code
LOV
Organization Code
mp.organization_code=:organization_code
LOV