Hi Lindsay.
A query that partly answers your question is this:
select o.offering_id,o.offering_name
from usm_offering o
where o.offering_name = 'User Administration'
select i.parent_id,i.rate_plan_id
from usm_offering_ratedef_inclusion i
where i.parent_id = 10141
select *
from usm_rate_definition rd
where rd.rate_plan_id = 10121
select * from usm_offering where offering_name = 'User Administration'
> check the content of the 'path' column.
Joined:
select o.offering_id,o.offering_name,
i.parent_id,i.rate_plan_id,
rd.item_id,rd.rate_plan_id,rd.item_text
from usm_offering o,usm_offering_ratedef_inclusion i,usm_rate_definition rd
where o.offering_name = 'User Administration'
and i.parent_id = o.offering_id
and rd.rate_plan_id = i.rate_plan_id
Next step is to find the relationship between the form and the above 'objects'.
I hope this helps you further (somewhat)? Kind regards, Louis.