Reports 2017-11-18T12:27:27+00:00

INV Item Relationships

Description
Categories: Enginatics, Manufacturing
Inventory item relationships

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,
mri.creation_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 Number
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 in (select fu.user_id from fnd_user fu where fu.user_name=: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 in (select fu.user_id from fnd_user fu where fu.user_name=:created_by)
LOV
Organization Code
mp.organization_code=:organization_code
LOV