Reports2017-11-18T12:27:27+00:00

INV Item Default Locators

Description
Categories: Enginatics, Logistics, Manufacturing
Inventory items default locators for shipping, receiving or move order receipt transactions

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,
mild.creation_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
Organization Code
mp.organization_code=:organization_code
LOV
Item
msiv.concatenated_segments like :item
LOV
Subinventory
mild.subinventory_code=:subinventory_code
LOV