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
Application: Subledger Accounting
Source: Complete Multiperiod Accounting
Short Name: XLARPMPA
DB package: XLA_MULTIPERIOD_RPRTG_PKG
Run
XLA Complete Multiperiod Accounting and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |