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
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
Ledger/Ledger Set
:p_ledger_id = :p_ledger_id
LOV Oracle
Period From
:p_period_from = :p_period_from
LOV Oracle
Period To
:p_period_to = :p_period_to
LOV Oracle
Account Flexfield From
 
Account Flexfield To
 
P_COA_ID
:p_coa_id = :p_coa_id
Period From
SELECT to_char(glp.start_date,'YYYY-MM-DD')  FROM gl_periods glp, gl_ledgers gl WHERE  gl.ledger_id = 976 AND glp.period_set_name = gl.period_set_name AND glp.period_name = :period_from
Period To
SELECT to_char(glp.end_date,'YYYY-MM-DD')  FROM gl_periods glp, gl_ledgers gl WHERE  gl.ledger_id = 976 AND glp.period_set_name = gl.period_set_name AND glp.period_name = :period_to