AR Ordering and Grouping Rules Listing

select gr1.name groupring_rule_name,
           gr1.description grouping_rule_desc,
           gr1.start_date,
           gr1.end_date,
           ord.name ordering_rule_name,
          al.meaning type,
          gc.description column_name
from   ra_grouping_rules gr1,
       ra_line_ordering_rules ord,
       ra_grouping_trx_types gt,
       ra_group_bys gb,
       ra_group_by_columns gc,
       ar_lookups al
where  gr1.ordering_rule_id     = ord.ordering_rule_id(+)
and    gr1.grouping_rule_id     = gt.grouping_rule_id(+)
and    gt.grouping_trx_type_id = gb.grouping_trx_type_id(+)
and    gb.column_id            = gc.column_id
and    al.lookup_type          = 'GROUPING_TRX_TYPE'
and    al.lookup_code          = gt.class
&LP_GROUPING_LOW
&LP_GROUPING_HIGH
--order by 1,2,3,4,5,6,7
ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC