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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Parameter Name SQL text Validation
Rule Name
 
LOV Oracle