XLA Complete Multiperiod Accounting

Description
Categories: BI Publisher
Imported from 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
 
Char