INV Item Relationships

Description

Categories
Enginatics
Repository
GitHub
Master listing for Inventory item relationships

SQL 32 lines

Parameters 8

ParameterTypeList of values SQL
ItemLOV
msiv1.concatenated_segments like :item_number
Last Update Date FromDate
mri.last_update_date>=:last_update_date_from
Last Update Date ToDate
mri.last_update_date<:last_update_date_to+1
Last Updated ByLOV
mri.last_updated_by=xxen_util.user_id(:last_updated_by)
Creation Date FromDate
mri.creation_date>=:creation_date_from
Creation Date ToDate
mri.creation_date<:creation_date_to+1
Created ByLOV
mri.created_by=xxen_util.user_id(:created_by)
Organization CodeLOV
mp.organization_code=:organization_code