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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
:p_period_from = :p_period_from
LOV Oracle
Period To
:p_period_to = :p_period_to
LOV Oracle
Account Flexfield From
 
Char
Account Flexfield To
 
Char