Can you help with the query to get the code associated to each service in Service Catalog 12.7.
There are three places where you can define a code, in the service details, service option group details and service option element 'Options' tab. On a high level you can obtain the same via the following:
select offering_name,code from usm_offering where code!=''
select * from usm_rate_plan where code!='' and rate_plan_name='<service option group name>'
select * from usm_rate_definition where code !=''
Thank you Jason, it helps..
No problem, glad it helped!
Retrieving data ...