XLA Complete Multiperiod Accounting

Description
Categories: BI Publisher
Application: Subledger Accounting
Source: Complete Multiperiod Accounting
Short Name: XLARPMPA
DB package: XLA_MULTIPERIOD_RPRTG_PKG
               SELECT TABLE1.EVENT_ID
                     ,TABLE1.EVENT_CLASS
                     ,TABLE1.EVENT_TYPE
                     ,TABLE1.EVENT_NUMBER
                     ,TABLE1.EVENT_DATE
                     ,TABLE1.AE_HEADER_ID
                     ,TABLE1.LEDGER
                     ,TABLE1.GL_DATE
                     ,TABLE1.LEDGER_CURRENCY
                     ,TABLE1.AAD_NAME
                     ,TABLE1.AAD_VERSION
                     ,TABLE1.DESCRIPTION
                     ,TABLE1.JOURNAL_ENTRY_STATUS
                     ,TABLE1.MPA_TYPE
                     ,TABLE1.ACOUNTING_SEQUENCE_NAME
                     ,TABLE1.ACOUNTING_SEQUENCE_VERSION
                     ,TABLE1.ACCOUNTING_SEQUENCE_NUMBER
                     ,TABLE1.REPORTING_SEQUENCE_NAME
                     ,TABLE1.REPORTING_SEQUENCE_VERSION
                     ,TABLE1.REPORTING_SEQUENCE_NUMBER
                     ,TABLE1.DOCUMENT_SEQUENCE_NAME
                     ,TABLE1.DOCUMENT_SEQUENCE_VALUE
                     ,TABLE1.AE_LINE_NUM
                     ,TABLE1.ACCOUNTING_CLASS
                     ,TABLE1.LINE_NUMBER
                     ,TABLE1.ACCOUNT
                     ,TABLE1.CURRENCY
                     ,TABLE1.ENTERED_DEBIT
                     ,TABLE1.ENTERED_CREDIT
                     ,TABLE1.ACCOUNTED_DEBIT
                     ,TABLE1.ACCOUNTED_CREDIT
                     ,TABLE1.TOTAL_ACCTED_DEBITS
                     ,TABLE1.TOTAL_ACCTED_CREDITS
                     ,TABLE1.ERROR_NUMBER
                     ,TABLE1.ERROR_MESSAGE
                     ,substr(USERIDS,1,instr(USERIDS,'|',1,1)-1)                                                    USER_TRX_IDENTIFIER_NAME_1
                     ,substr(USERIDS,instr(USERIDS,'|',1,1)+1,(instr(USERIDS,'|',1,2)-1-instr(USERIDS,'|',1,1)))    USER_TRX_IDENTIFIER_VALUE_1
                     ,substr(USERIDS,instr(USERIDS,'|',1,2)+1,(instr(USERIDS,'|',1,3)-1-instr(USERIDS,'|',1,2)))    USER_TRX_IDENTIFIER_NAME_2
                     ,substr(USERIDS,instr(USERIDS,'|',1,3)+1,(instr(USERIDS,'|',1,4)-1-instr(USERIDS,'|',1,3)))    USER_TRX_IDENTIFIER_VALUE_2
                     ,substr(USERIDS,instr(USERIDS,'|',1,4)+1,(instr(USERIDS,'|',1,5)-1-instr(USERIDS,'|',1,4)))    USER_TRX_IDENTIFIER_NAME_3
                     ,substr(USERIDS,instr(USERIDS,'|',1,5)+1,(instr(USERIDS,'|',1,6)-1-instr(USERIDS,'|',1,5)))    USER_TRX_IDENTIFIER_VALUE_3
                     ,substr(USERIDS,instr(USERIDS,'|',1,6)+1,(instr(USERIDS,'|',1,7)-1-instr(USERIDS,'|',1,6)))    USER_TRX_IDENTIFIER_NAME_4
                     ,substr(USERIDS,instr(USERIDS,'|',1,7)+1,(instr(USERIDS,'|',1,8)-1-instr(USERIDS,'|',1,7)))    USER_TRX_IDENTIFIER_VALUE_4
                     ,substr(USERIDS,instr(USERIDS,'|',1,8)+1,(instr(USERIDS,'|',1,9)-1-instr(USERIDS,'|',1,8)))    USER_TRX_IDENTIFIER_NAME_5
                     ,substr(USERIDS,instr(USERIDS,'|',1,9)+1,(instr(USERIDS,'|',1,10)-1-instr(USERIDS,'|',1,9)))   USER_TRX_IDENTIFIER_VALUE_5
                     ,substr(USERIDS,instr(USERIDS,'|',1,10)+1,(instr(USERIDS,'|',1,11)-1-instr(USERIDS,'|',1,10))) USER_TRX_IDENTIFIER_NAME_6
                     ,substr(USERIDS,instr(USERIDS,'|',1,11)+1,(instr(USERIDS,'|',1,12)-1-instr(USERIDS,'|',1,11))) USER_TRX_IDENTIFIER_VALUE_6
                     ,substr(USERIDS,instr(USERIDS,'|',1,12)+1,(instr(USERIDS,'|',1,13)-1-instr(USERIDS,'|',1,12))) USER_TRX_IDENTIFIER_NAME_7
                     ,substr(USERIDS,instr(USERIDS,'|',1,13)+1,(instr(USERIDS,'|',1,14)-1-instr(USERIDS,'|',1,13))) USER_TRX_IDENTIFIER_VALUE_7
                     ,substr(USERIDS,instr(USERIDS,'|',1,14)+1,(instr(USERIDS,'|',1,15)-1-instr(USERIDS,'|',1,14))) USER_TRX_IDENTIFIER_NAME_8
                     ,substr(USERIDS,instr(USERIDS,'|',1,15)+1,(instr(USERIDS,'|',1,16)-1-instr(USERIDS,'|',1,15))) USER_TRX_IDENTIFIER_VALUE_8
                     ,substr(USERIDS,instr(USERIDS,'|',1,16)+1,(instr(USERIDS,'|',1,17)-1-instr(USERIDS,'|',1,16))) USER_TRX_IDENTIFIER_NAME_9
                     ,substr(USERIDS,instr(USERIDS,'|',1,17)+1,(instr(USERIDS,'|',1,18)-1-instr(USERIDS,'|',1,17))) USER_TRX_IDENTIFIER_VALUE_9
                     ,substr(USERIDS,instr(USERIDS,'|',1,18)+1,(instr(USERIDS,'|',1,19)-1-instr(USERIDS,'|',1,18))) USER_TRX_IDENTIFIER_NAME_10
                     ,substr(USERIDS,instr(USERIDS,'|',1,19)+1,(length(USERIDS)-instr(USERIDS,'|',1,19)))           USER_TRX_IDENTIFIER_VALUE_10
                 FROM (&C_ERRORS_COLS_QUERY
                       &p_trx_identifiers
                       &C_ERRORS_FROM_QUERY
                       &C_ERRORS_WHR_QUERY
                       &xah_appl_filter
                       &acct_batch_filter
                       &xae_appl_filter
                       &ent_appl_filter
                       &xal_appl_filter) TABLE1
                 WHERE :P_REPORT <> 'N'
Parameter Name SQL text Validation
Ledger
 
LOV Oracle
Process Category
 
LOV Oracle
End GL Date
 
Date
Errors Only
 
LOV Oracle
Report
 
LOV Oracle
Transfer to General Ledger
 
LOV Oracle
Post in Generate Ledger
 
LOV Oracle
General Ledger Batch Name
 
XLA_SRS_SUBLEDGERS
 
LOV Oracle
User JE Source
 
XLA_SRS_NO_VALIDATION
 
Ledger Name
 
Process Category Name
 
Errors Only Flag
 
XLA_SRS_ACCOUNTING_MODE_DUMMY
 
XLA_SRS_NO_VALIDATION
 
Report Style
 
Transfer to General Ledger Flag
 
XLA_SRS_NO_VALIDATION
 
Post in General Ledger Flag