AR Accounting Rules Listing

select  rr.name name,
        l1.meaning type,
         nvl(gpt.user_period_type,
                    l2.meaning)  frequency,
        rr.description  description,
        nvl(rr.occurrences,0)  num_periods,
        l3.meaning  status,
        rr.rule_id rule_id
from    ra_rules rr,
        ar_lookups l1,
        ar_lookups l2,
        ar_lookups l3,
        gl_period_types gpt
where   l1.lookup_code     = rr.type
and     l1.lookup_type     = 'RULE_TYPE'
and     l2.lookup_code(+)  = rr.frequency
and     l2.lookup_type(+)  = 'SCHEDULE_PERIOD'
and     gpt.period_type(+) = rr.frequency
and     l3.lookup_code     = rr.status
and     l3.lookup_type     = 'CODE_STATUS'
order by rr.name