XLA Export Application Accounting Definitions - draft

Description
Categories: BI Publisher
Columns: Product Rule Code, Product Rule Name, Product Rule Owner, Version To ...
Application: Subledger Accounting
Source: Export Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use
Short Name: XLAALEXP_XML
DB package: XLA_XLAALEXP_XMLP_PKG
select
 log.product_rule_code
,tw.name product_rule_name
,lk.meaning product_rule_owner
,log.version_to version_to
from
 xla_aad_loader_logs log
join xla_lookups lk
on lk.lookup_type = 'XLA_OWNER_TYPE'
and lk.lookup_code = log.product_rule_type_code
join xla_product_rules_tl tw
on tw.language = USERENV('LANG')
and tw.application_id = log.application_id
and tw.amb_context_code = log.amb_context_code
and tw.product_rule_type_code = log.product_rule_type_code
and tw.product_rule_code = log.product_rule_code
where log.log_type_code = 'EXPORTED_AAD'
and log.request_id = :P_CONC_REQUEST_ID
order by tw.name
Parameter Name SQL text Validation
AMB Context
 
LOV Oracle
Destination File Pathname
 
Versioning Mode
 
LOV Oracle
User Version
 
Comment
 
Application
 
LOV Oracle