INV Item Default Subinventories

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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
Download
 
Related Blitz Reports
CAC Calculate Average Item Costs INV Item Default Locators CAC Receiving Account Detail CAC WIP Material Usage with Configuration and Lot Variances CAC Material Account Summary CAC WIP Account Summary CAC Receiving Account Summary CAC Missing Receiving Accounting Transactions ECC Discrete Manufacturing, Components
Blitz Report™

Blitz Report™ provides multiple benefits: