PA AutoAccounting Rule Definitions
Description
- Categories
- BI Publisher
- Application
- Projects
- Source
- IMP: AutoAccounting Rule Definitions (XML)
- Short Name
- PAXAARUL_XML
- DB package
- PA_PAXAARUL_XMLP_PKG
SQL 16 lines
SELECT r.rule_id rule_id1_a , r.constant_value , p.parameter_name , r.select_statement , rt.meaning segment_value_source , ls.segment_value_lookup_set_name lookup_set FROM pa_lookups rt , pa_segment_value_lookup_sets ls , pa_parameters p , pa_rules r WHERE rt.lookup_code = r.rule_type and rt.lookup_type = 'SEGMENT VALUE SOURCE' and p.parameter_id(+) = r.key_parameter_id and ls.segment_value_lookup_set_id(+) = r.segment_value_lookup_set_id and r.rule_id=:rule_id |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Rule Name | LOV Oracle |