XLA Create and Assign Sources - draft

Description
Categories: BI Publisher
Columns: Application Name, Event Class Code, Event Class Name, Category Sequence Num, Message Category Code, Message Category Dsp, Message Number, Message Type Flag, Message Type Dsp, Extract Object Name ...
Application: Subledger Accounting
Source: Create and Assign Sources (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABASR_XML
DB package: XLA_XLAABASR_XMLP_PKG
select 
 app.application_name
,ect.event_class_code
,ect.name event_class_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
,err.extract_object_name
,err.extract_object_type_code
,lk3.meaning extract_object_type_dsp
,err.source_code
,err.source_type_code
,st.name source_name
,err.accounting_source_code
,err.mapping_group_code
,ast.name accounting_source_name
,msg.message_text
,lk4.meaning mapping_group_dsp
,err.extract_column_name
,err.language
,lk5.meaning source_type_dsp
from    
 xla_amb_setup_errors        err
,xla_event_classes_tl        ect
,xla_sources_tl              st
,xla_acct_attributes_tl        ast
,fnd_new_messages            msg
,fnd_application_vl          app
,xla_lookups                 lk1
,xla_lookups                 lk2
,xla_lookups                 lk3
,xla_lookups                 lk4
,xla_lookups                 lk5
where   
    msg.message_name           = err.message_name
and msg.application_id               = 602
and app.application_id           = err.application_id
and ect.application_id           = err.application_id
and ect.entity_code              = err.entity_code
and ect.event_class_code         = err.event_class_code
and ect.language                 = USERENV('LANG')
and st.application_id(+)               = err.source_application_id
and st.source_type_code(+)       = err.source_type_code
and st.source_code(+)            = err.source_code
and st.language(+)               = USERENV('LANG')
and ast.accounting_attribute_code(+)= err.accounting_source_code
and ast.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.mapping_group_code
and lk4.lookup_type(+)           = 'XLA_ACCT_ATTR_ASSGN_GROUP'
and lk5.lookup_code(+)            = err.source_type_code
and lk5.lookup_type(+)            = 'XLA_SOURCE_TYPE'
and err.application_id              = :P_APPLICATION_ID
&CP_QUERY
order by 1,3,4,6,5,7,19,9,22,21,20
Parameter Name SQL text Validation
Mode
 
LOV Oracle
Event Class
 
LOV Oracle
XLA_SRS_SUBLEDGERS
 
LOV Oracle
Entity Code
 
Report Only Mode