item number need generated by item category number
Dear Oracle experts,
currently ,our client need the item number(mtl_system_items_b.SEGMENT1) generated by item category code, it means the item number should be make up of item category code and a serial number.
is there any solution can do it?
Thank you