XLA Subledger Multiperiod Accounting and Accrual Reversal

Description
Categories: BI Publisher
Application: Subledger Accounting
Source: Subledger Multiperiod Accounting and Accrual Reversal Report
Short Name: XLARPMPX
DB package: XLA_MPA_ACCRUAL_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  :L_RUN_REPORT <> 'N' --added for bug8977840
Parameter Name SQL text Validation
XLA_SRS_SUBLEDGERS
 
LOV Oracle
Application Name
 
Source Application
 
LOV Oracle
Sorce Application Name
 
XLA_SRS_NO_VALIDATION
 
Ledger Name
 
Process Category Name
 
Create Accounting
 
LOV Oracle
Create Accounting Flag
 
XLA_SRS_NO_VALIDATION
 
Mode
 
LOV Oracle
XLA_SRS_ACCOUNTING_MODE_DUMMY
 
Errors Only
 
LOV Oracle
Errors Only Flag
 
XLA_SRS_NO_VALIDATION
 
Report
 
LOV Oracle
Report Style
 
Transfer to General Ledger
 
LOV Oracle
Transfer to GL Flag
 
XLA_SRS_NO_VALIDATION
 
Post in General Ledger
 
LOV Oracle
Post to GL Flag