AR Ordering and Grouping Rules Listing
Description
Categories: BI Publisher
Application: Receivables
Source: Ordering and Grouping Rules Listing (XML)
Short Name: ARXGRL_XML
DB package: AR_ARXGRL_XMLP_PKG
Source: Ordering and Grouping Rules Listing (XML)
Short Name: ARXGRL_XML
DB package: AR_ARXGRL_XMLP_PKG
Run
AR Ordering and Grouping Rules Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Create Ordering Rules Report |
|
LOV Oracle | |
Create Grouping Rules Report |
|
LOV Oracle | |
Ordering Rule Name Low |
|
LOV Oracle | |
Ordering Rule Name High |
|
LOV Oracle | |
Grouping Rule Name Low |
|
LOV Oracle | |
Grouping Rule Name High |
|
LOV Oracle |