This content has been marked as final. Show 2 replies
trigger = when-validate-record
not exists (select 1 from mtl_system_items msi, mtl_parameters mp
where mp.organization_code = :dest_org
and mp.organization_id = msi.organization_id
and msi.segment1 = :item_number)
Action = message
type = error
message text = Item not assigned to dest. org.
Thanks Sandeep !! This helped me a lot..