AR Ordering and Grouping Rules Listing

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Ordering and Grouping Rules Listing (XML)
Short Name: ARXGRL_XML
DB package: AR_ARXGRL_XMLP_PKG
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
Parameter Name SQL text Validation
Grouping Rule Name High
 
LOV Oracle
Grouping Rule Name Low
 
LOV Oracle
Ordering Rule Name High
 
LOV Oracle
Ordering Rule Name Low
 
LOV Oracle
Create Grouping Rules Report
 
LOV Oracle
Create Ordering Rules Report
 
LOV Oracle