Query to get row sets, column sets, and row orders

-- FSG ROW SETS AND COLUMN SETS --
SELECT fst.id_flex_structure_name "COA"
, decode(rw.axis_set_type,'R','ROW SET','C','COLUMN SET','##') "ROW/COLUMN"
, rw.name"SET NAME"
, rw.axis_set_id
,rw.creation_date
FROM rg_report_axis_sets_v rw, fnd_id_flex_structures_v fst
WHERE rw.structure_id = fst.id_flex_num
AND substr(fst.id_flex_structure_name,1,2) in ('DC')
ORDER BY 1,2,3;

-- CONTENT SETS --
SELECT fst.id_flex_structure_name "COA"
, cs.name
, cs.content_set_id
FROM rg_report_content_sets cs, fnd_id_flex_structures_v fst
WHERE cs.structure_id = fst.id_flex_num
AND substr(fst.id_flex_structure_name,1,2) in ('DC');

-- ROW ORDERS --
SELECT fst.id_flex_structure_name "COA"
, ro.name "ROW ORDER"
, ro.description "DESCRIPTION"
, ro.structure_id
, ro.row_order_id
FROM rg_row_orders ro, fnd_id_flex_structures_v fst
WHERE ro.structure_id = fst.id_flex_num
AND substr(fst.id_flex_structure_name,1,2) in ('DC')
ORDER BY ro.name;