PA AutoAccounting Rule Definitions

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: IMP: AutoAccounting Rule Definitions (XML)
Short Name: PAXAARUL_XML
DB package: PA_PAXAARUL_XMLP_PKG
Run PA AutoAccounting Rule Definitions and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
CAC Receiving Account Detail No SLA GL Account Analysis (Distributions) COPY OF: GL Account Analysis GL Account Analysis CAC Receiving Account Summary No SLA CAC WIP Account Value CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Material Usage with Configuration and Lot Variances CAC WIP Resource Efficiency
Blitz Report™

Blitz Report™ provides multiple benefits: