INV Item Relationships

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_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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