XX Account Analysis
Description
Categories: BI Publisher
Application: Subledger Accounting
Source: XX Account Analysis Report
Short Name: XXXLAAARPT
DB package: XLA_ACCT_ANALYSIS_RPT_PKG
Source: XX Account Analysis Report
Short Name: XXXLAAARPT
DB package: XLA_ACCT_ANALYSIS_RPT_PKG
SELECT GL_DATE ,CREATED_BY ,CREATION_DATE ,LAST_UPDATE_DATE ,GL_TRANSFER_DATE ,REFERENCE_DATE ,COMPLETED_DATE ,TRANSACTION_NUMBER ,TRANSACTION_DATE ,ACCOUNTING_SEQUENCE_NAME ,ACCOUNTING_SEQUENCE_VERSION ,ACCOUNTING_SEQUENCE_NUMBER ,REPORTING_SEQUENCE_NAME ,REPORTING_SEQUENCE_VERSION ,REPORTING_SEQUENCE_NUMBER ,DOCUMENT_CATEGORY ,DOCUMENT_SEQUENCE_NAME ,DOCUMENT_SEQUENCE_NUMBER ,GL_DOCUMENT_SEQUENCE_NAME ,GL_DOCUMENT_SEQUENCE_NUMBER ,APPLICATION_ID ,APPLICATION_NAME ,HEADER_ID ,HEADER_DESCRIPTION ,FUND_STATUS ,JE_CATEGORY_NAME ,JE_SOURCE_NAME ,EVENT_ID ,EVENT_DATE ,EVENT_NUMBER ,EVENT_CLASS_CODE ,EVENT_CLASS_NAME ,EVENT_TYPE_CODE ,EVENT_TYPE_NAME ,GL_BATCH_NAME ,POSTED_DATE ,GL_JE_NAME ,GL_LINE_NUMBER ,LINE_NUMBER ,ORIG_LINE_NUMBER ,ACCOUNTING_CLASS_CODE ,ACCOUNTING_CLASS_NAME ,LINE_DESCRIPTION ,ENTERED_CURRENCY ,CONVERSION_RATE ,CONVERSION_RATE_DATE ,CONVERSION_RATE_TYPE_CODE ,CONVERSION_RATE_TYPE ,ENTERED_DR ,ENTERED_CR ,UNROUNDED_ACCOUNTED_DR ,UNROUNDED_ACCOUNTED_CR ,ACCOUNTED_DR ,ACCOUNTED_CR ,STATISTICAL_AMOUNT ,RECONCILIATION_REFERENCE ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,PARTY_TYPE_CODE ,PARTY_TYPE ,PARTY_NUMBER ,PARTY_NAME ,PARTY_TYPE_TAXPAYER_ID ,PARTY_TAX_REGISTRATION_NUMBER ,PARTY_SITE_NUMBER ,PARTY_SITE_NAME ,PARTY_SITE_TAX_RGSTN_NUMBER ,USER_TRX_IDENTIFIER_NAME_1 ,USER_TRX_IDENTIFIER_VALUE_1 ,USER_TRX_IDENTIFIER_NAME_2 ,USER_TRX_IDENTIFIER_VALUE_2 ,USER_TRX_IDENTIFIER_NAME_3 ,USER_TRX_IDENTIFIER_VALUE_3 ,USER_TRX_IDENTIFIER_NAME_4 ,USER_TRX_IDENTIFIER_VALUE_4 ,USER_TRX_IDENTIFIER_NAME_5 ,USER_TRX_IDENTIFIER_VALUE_5 ,USER_TRX_IDENTIFIER_NAME_6 ,USER_TRX_IDENTIFIER_VALUE_6 ,USER_TRX_IDENTIFIER_NAME_7 ,USER_TRX_IDENTIFIER_VALUE_7 ,USER_TRX_IDENTIFIER_NAME_8 ,USER_TRX_IDENTIFIER_VALUE_8 ,USER_TRX_IDENTIFIER_NAME_9 ,USER_TRX_IDENTIFIER_VALUE_9 ,USER_TRX_IDENTIFIER_NAME_10 ,USER_TRX_IDENTIFIER_VALUE_10 ,LEGAL_ENTITY_ID ,LEGAL_ENTITY_NAME ,LE_ADDRESS_LINE_1 ,LE_ADDRESS_LINE_2 ,LE_ADDRESS_LINE_3 ,LE_CITY ,LE_REGION_1 ,LE_REGION_2 ,LE_REGION_3 ,LE_POSTAL_CODE ,LE_COUNTRY ,LE_REGISTRATION_NUMBER ,LE_REGISTRATION_EFFECTIVE_FROM ,LE_BR_DAILY_INSCRIPTION_NUMBER ,LE_BR_DAILY_INSCRIPTION_DATE ,LE_BR_DAILY_ENTITY ,LE_BR_DAILY_LOCATION ,LE_BR_DIRECTOR_NUMBER ,LE_BR_ACCOUNTANT_NUMBER ,LE_BR_ACCOUNTANT_NAME ,LEDGER_ID ,LEDGER_SHORT_NAME ,LEDGER_DESCRIPTION ,LEDGER_NAME ,LEDGER_CURRENCY ,PERIOD_YEAR ,PERIOD_NUMBER ,PERIOD_NAME ,PERIOD_START_DATE ,PERIOD_END_DATE ,BALANCE_TYPE_CODE ,BALANCE_TYPE ,BUDGET_NAME ,ENCUMBRANCE_TYPE ,SLA_BEGIN_BALANCE_DR ,SLA_BEGIN_BALANCE_CR ,SLA_PERIOD_NET_DR ,SLA_PERIOD_NET_CR ,BEGIN_BALANCE_DR ,BEGIN_BALANCE_CR ,PERIOD_NET_DR ,PERIOD_NET_CR ,CODE_COMBINATION_ID ,ACCOUNTING_CODE_COMBINATION ,CODE_COMBINATION_DESCRIPTION ,CONTROL_ACCOUNT_FLAG ,CONTROL_ACCOUNT ,BALANCING_SEGMENT ,NATURAL_ACCOUNT_SEGMENT ,COST_CENTER_SEGMENT ,MANAGEMENT_SEGMENT ,INTERCOMPANY_SEGMENT ,BALANCING_SEGMENT_DESC ,NATURAL_ACCOUNT_DESC ,COST_CENTER_DESC ,MANAGEMENT_SEGMENT_DESC ,INTERCOMPANY_SEGMENT_DESC ,SEGMENT1 ,SEGMENT2 ,SEGMENT3 ,SEGMENT4 ,SEGMENT5 ,SEGMENT6 ,SEGMENT7 ,SEGMENT8 ,SEGMENT9 ,SEGMENT10 ,SEGMENT11 ,SEGMENT12 ,SEGMENT13 ,SEGMENT14 ,SEGMENT15 ,SEGMENT16 ,SEGMENT17 ,SEGMENT18 ,SEGMENT19 ,SEGMENT20 ,SEGMENT21 ,SEGMENT22 ,SEGMENT23 ,SEGMENT24 ,SEGMENT25 ,SEGMENT26 ,SEGMENT27 ,SEGMENT28 ,SEGMENT29 ,SEGMENT30 ,BEGIN_RUNNING_TOTAL_CR ,BEGIN_RUNNING_TOTAL_DR ,END_RUNNING_TOTAL_CR ,END_RUNNING_TOTAL_DR ,JE_SOURCE_PERIOD_DR ,JE_SOURCE_PERIOD_CR FROM xxen_account_analysis WHERE 1=1 and gl_date between '&P_GL_DATE_FROM' and '&P_GL_DATE_TO' and segment1 || '-' || segment2 || '-' || segment3 || '-' || segment4 || '-' || segment5 between :P_ACCOUNT_FLEXFIELD_FROM and :P_ACCOUNT_FLEXFIELD_TO |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Period From |
|
LOV Oracle | |
| Period To |
|
LOV Oracle | |
| Account Flexfield From |
|
Char | |
| Account Flexfield To |
|
Char |
