INV Item Relationships

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Master listing for Inventory item relationships
Run INV Item Relationships and other Oracle EBS reports with Blitz Report™ on our demo environment
select
mp.organization_code,
msiv1.concatenated_segments from_item,
msiv1.description from_item_description,
msiv2.concatenated_segments to_item,
msiv2.description to_item_description,
xxen_util.meaning(mri.relationship_type_id,'MTL_RELATIONSHIP_TYPES',700) type,
decode(mri.reciprocal_flag,'Y','Y') reciprocal,
mri.planning_enabled_flag planning_enabled,
mri.start_date,
mri.end_date,
xxen_util.user_name(mri.created_by) created_by,
xxen_util.client_time(mri.creation_date) creation_date,
xxen_util.user_name(mri.last_updated_by) last_updated_by,
xxen_util.client_time(mri.last_update_date) last_update_date
from
mtl_parameters mp,
mtl_related_items mri,
mtl_system_items_vl msiv1,
mtl_system_items_vl msiv2
where
1=1 and
mp.organization_id=msiv1.organization_id and
mp.organization_id=msiv2.organization_id and
mri.inventory_item_id=msiv1.inventory_item_id and
mri.related_item_id=msiv2.inventory_item_id
order by
mp.organization_code,
msiv1.concatenated_segments,
msiv2.concatenated_segments,
type
Parameter Name SQL text Validation
Item 
msiv1.concatenated_segments like :item_number
 LOV
Last Update Date From 
mri.last_update_date>=:last_update_date_from
 DateTime
Last Update Date To 
mri.last_update_date<=:last_update_date_to
 DateTime
Last Updated By 
mri.last_updated_by=xxen_util.user_id(:last_updated_by)
 LOV
Creation Date From 
mri.creation_date>=:creation_date_from
 DateTime
Creation Date To 
mri.creation_date<=:creation_date_to
 DateTime
Created By 
mri.created_by=xxen_util.user_id(:created_by)
 LOV
Organization Code 
mp.organization_code=:organization_code
 LOV
Download
 
Related Blitz Reports
CAC Internal Order Shipment Margin CAC Manufacturing Variance Detail CAC Invoice Price Variance CAC Manufacturing Variance Summary CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Resource Efficiency CST All Inventories Value (23) ECC Process Genealogy and Trace, Serial Numbers ECC Genealogy and Trace, Serial Numbers
Blitz Report™

Blitz Report™ provides multiple benefits: