INV Item Default Subinventories

Description
Categories: Enginatics, Kcapps, Toolkit - Operations, Toolkit - Setup & Support
Repository: Github
Master data report of inventory item relationships including the type of relationship between the item and the subinventory.
Run INV Item Default Subinventories and other Oracle EBS reports with Blitz Report™ on our demo environment
select
msiv.concatenated_segments item,
msiv.description item_description,
xxen_util.meaning(misd.default_type,'MTL_DEFAULT_SUBINVENTORY',700) default_type,
misd.subinventory_code subinventory,
mp.organization_code,
haouv.name organization,
xxen_util.user_name(misd.created_by) created_by,
xxen_util.client_time(misd.creation_date) creation_date,
xxen_util.user_name(misd.last_updated_by) last_updated_by,
xxen_util.client_time(misd.last_update_date) last_update_date
from
hr_all_organization_units_vl haouv,
mtl_parameters mp,
mtl_item_sub_defaults misd,
mtl_system_items_vl msiv
where
1=1 and
haouv.organization_id=misd.organization_id and
mp.organization_id=misd.organization_id and
misd.inventory_item_id=msiv.inventory_item_id and
misd.organization_id=msiv.organization_id
order by
msiv.concatenated_segments,
mp.organization_code,
default_type
Parameter Name SQL text Validation
Item
msiv.concatenated_segments like :item
LOV
Subinventory
misd.subinventory_code=:subinventory_code
LOV
Organization Code
mp.organization_code=:organization_code
LOV