XLA Validate Application Accounting Definitions - draft

Description
Categories: BI Publisher
Columns: Application Name, Amb Context Dsp, Amb Context Code, Product Rule Code, Product Rule Name, Product Rule Type Code, Product Rule Type Dsp, Line Definition Owner Code, Line Definition Owner, Line Definition Code ...
Application: Subledger Accounting
Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABACR_XML
DB package: XLA_XLAABACR_XMLP_PKG
select *
from (
select
 app.application_name
,lk11.meaning amb_context_dsp
,err.amb_context_code
,err.product_rule_code
,prt.name product_rule_name
,err.product_rule_type_code
,lk4.meaning product_rule_type_dsp
,err.line_definition_owner_code
,lk12.meaning line_definition_owner
,err.line_definition_code
,xld.name line_definition_name
,err.category_sequence_num
,err.message_category_code
,lk2.meaning message_category_dsp
,msg.message_number
,err.message_type_flag
,lk1.meaning message_type_dsp
,ect.event_class_code
,ect.name event_class_name
,ett.event_type_code
,ett.name event_type_name
,err.description_code
,dt.name description_name
,err.description_type_code
,lk5.meaning description_type_dsp
,err.extract_object_name
,err.extract_object_type_code
,lk3.meaning extract_object_type_dsp
,err.source_code
,st.name source_name
,err.source_type_code
,lk9.meaning source_type_dsp
,err.analytical_criterion_code
,act.name analytical_criterion_name
,err.analytical_criterion_type_code
,lk6.meaning analytical_criterion_type_dsp
,err.accounting_line_code
,acb.name accounting_line_name
,err.accounting_line_type_code
,lk7.meaning accounting_line_type_dsp
,err.mapping_set_code
,mst.name mapping_set_name
,err.segment_rule_code
,srt.name segment_rule_name
,err.segment_rule_type_code
,lk8.meaning segment_rule_type_dsp
,err.accounting_source_code
,err.mapping_group_code
,lk10.meaning mapping_group_dsp
,ast1.name accounting_source_name
,err.mpa_accounting_line_code
,malt.name mpa_accounting_line_name
,err.mpa_accounting_line_type_code
,lk13.meaning mpa_accounting_line_type_dsp
,msg.message_text
from
 xla_amb_setup_errors  err
,xla_product_rules_tl     prt
,xla_line_definitions_tl   xld
,xla_event_classes_tl   ect
,xla_event_types_tl      ett
,xla_descriptions_tl       dt
,xla_analytical_hdrs_tl  act
,xla_acct_line_types_tl acb
,xla_acct_line_types_tl malt
,xla_sources_tl            st
,xla_acct_attributes_tl ast1
,xla_mapping_sets_tl   mst
,xla_seg_rules_tl         srt
,fnd_new_messages    msg
,fnd_application_vl       app
,xla_lookups                 lk1
,xla_lookups                 lk2
,xla_lookups                 lk3
,xla_lookups                 lk4
,xla_lookups                 lk5
,xla_lookups                 lk6
,xla_lookups                 lk7
,xla_lookups                 lk8
,xla_lookups                 lk9
,xla_lookups                 lk10
,xla_lookups                 lk11
,xla_lookups                 lk12
,xla_lookups                 lk13
where
    msg.message_name		= err.message_name
and msg.application_id 		= 602
and msg.language_code                             = USERENV('LANG')
and app.application_id		= err.application_id
and prt.application_id(+) 		= err.application_id
and prt.amb_context_code(+)		= err.amb_context_code
and prt.product_rule_code(+)		= err.product_rule_code
and prt.product_rule_type_code(+)	= err.product_rule_type_code
and prt.language(+) 			= USERENV('LANG')
and xld.application_id(+)		= err.application_id
and xld.amb_context_code(+) 		= err.amb_context_code
and xld.event_class_code(+) 		= err.event_class_code
and xld.event_type_code(+) 		= err.event_type_code
and xld.line_definition_owner_code(+) 	= err.line_definition_owner_code
and xld.line_definition_code(+) 		= err.line_definition_code
and xld.language(+) 			= USERENV('LANG')
and ect.application_id(+)        		= err.application_id
and ect.event_class_code(+) 		= err.event_class_code
and ect.language(+)              		= USERENV('LANG')
and ett.application_id(+)        		= err.application_id
and ett.event_class_code (+) 		= err.event_class_code
and ett.event_type_code(+) 		= err.event_type_code
and ett.language(+)              		= USERENV('LANG')
and dt.application_id(+)         		= err.application_id
and dt.amb_context_code (+) 		= err.amb_context_code
and dt.description_type_code(+) 	= err.description_type_code
and dt.description_code(+)  		= err.description_code
and dt.language(+)   			= USERENV('LANG')
and st.application_id(+)  		= err.application_id
and st.source_type_code(+)  		= err.source_type_code
and st.source_code(+)  		= err.source_code
and st.language(+)  			= USERENV('LANG')
and ast1.accounting_attribute_code(+)	= err.accounting_source_code
and ast1.language(+)  			= USERENV('LANG')
and acb.application_id(+) 		= err.application_id
and acb.event_class_code(+)  		= err.event_class_code
and acb.amb_context_code (+) 		= err.amb_context_code
and acb.accounting_line_type_code(+)	= err.accounting_line_type_code
and acb.accounting_line_code(+) 	= err.accounting_line_code
and acb.language(+)              		= USERENV('LANG')
and malt.application_id(+) 		= err.application_id
and malt.event_class_code(+)  		= err.event_class_code
and malt.amb_context_code (+) 	= err.amb_context_code
and malt.accounting_line_type_code(+)	= err.mpa_accounting_line_type_code
and malt.accounting_line_code(+) 	= err.mpa_accounting_line_code
and malt.language(+)              		= USERENV('LANG')
and act.analytical_criterion_code(+)	= err.analytical_criterion_code
and act.analytical_criterion_type_code(+)	= err.analytical_criterion_type_code
and act.amb_context_code(+)  		= err.amb_context_code
and act.language(+)   		= USERENV('LANG')
and mst.mapping_set_code(+)		= err.mapping_set_code
and mst.amb_context_code(+) 		= err.amb_context_code
and mst.language(+)              		= USERENV('LANG')
and srt.application_id(+)        		= err.application_id
and srt.amb_context_code(+)   	 	= err.amb_context_code
and srt.segment_rule_type_code(+)	= err.segment_rule_type_code
and srt.segment_rule_code(+)   	= err.segment_rule_code
and srt.language(+)              		= USERENV('LANG')
and lk1.lookup_code              		= err.message_type_flag
and lk1.lookup_type              		= 'XLA_ERROR_TYPE'
and lk2.lookup_code              		= err.message_category_code
and lk2.lookup_type              		= 'XLA_AB_MESSAGE_CATEGORY'
and lk3.lookup_code(+)           		= err.extract_object_type_code
and lk3.lookup_type(+)           		= 'XLA_EXTRACT_OBJECT_TYPE'
and lk4.lookup_code(+)           		= err.product_rule_type_code
and lk4.lookup_type(+)          		= 'XLA_OWNER_TYPE'
and lk5.lookup_code(+)           		= err.description_type_code
and lk5.lookup_type(+)           		= 'XLA_OWNER_TYPE'
and lk6.lookup_code(+)           		= err.analytical_criterion_type_code
and lk6.lookup_type(+)          		= 'XLA_OWNER_TYPE'
and lk7.lookup_code(+)           		= err.accounting_line_type_code
and lk7.lookup_type(+)           		= 'XLA_OWNER_TYPE'
and lk8.lookup_code(+)           		= err.segment_rule_type_code
and lk8.lookup_type(+)           		= 'XLA_OWNER_TYPE'
and lk9.lookup_code(+)           		= err.source_type_code
and lk9.lookup_type(+)           		= 'XLA_SOURCE_TYPE'
and lk10.lookup_code(+)         		= err.mapping_group_code
and lk10.lookup_type(+)         		= 'XLA_ACCT_ATTR_ASSGN_GROUP'
and lk11.lookup_code              		= err.amb_context_code
and lk11.lookup_type              		= 'XLA_AMB_CONTEXT_TYPE'
and lk12.lookup_code(+)          		= err.line_definition_owner_code
and lk12.lookup_type(+)          		= 'XLA_OWNER_TYPE'
and lk13.lookup_code(+)           		= err.mpa_accounting_line_type_code
and lk13.lookup_type(+)           		= 'XLA_OWNER_TYPE'
and err.amb_context_code                         = NVL(FND_PROFILE.value('XLA_AMB_CONTEXT'),'DEFAULT')
&CP_QUERY
&CP_JLD_SELECT
&CP_JLD_FROM
&CP_JLD_WHERE
&CP_JLD_WHERE2
) Q
order by application_name, product_rule_name, product_rule_type_dsp, line_definition_name, line_definition_owner