eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GLBV_JOURNAL_ENTRIES

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT JOURNAL_ENTRY.JE_HEADER_ID
, JOURNAL_ENTRY.NAME
, JOURNAL_ENTRY.LEDGER_ID
, JOURNAL_CATEGORY.USER_JE_CATEGORY_NAME
, JOURNAL_SOURCE.USER_JE_SOURCE_NAME
, JOURNAL_ENTRY.PERIOD_NAME
, JOURNAL_ENTRY.CURRENCY_CODE
, '_LA:JOURNAL_ENTRY.ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION'
, JOURNAL_ENTRY.DEFAULT_EFFECTIVE_DATE
, '_LA:JOURNAL_ENTRY.TAX_STATUS_CODE:GL_LOOKUPS:TAX_STATUS:MEANING'
, JOURNAL_ENTRY.ENCUMBRANCE_TYPE_ID
, JOURNAL_ENTRY.BUDGET_VERSION_ID
, JOURNAL_ENTRY.JE_BATCH_ID
, JOURNAL_ENTRY.ACCRUAL_REV_EFFECTIVE_DATE
, JOURNAL_ENTRY.ACCRUAL_REV_PERIOD_NAME
, '_LA:JOURNAL_ENTRY.ACCRUAL_REV_STATUS:GL_LOOKUPS:JE_REVERSAL_STATUS:MEANING'
, '_LA:DECODE(JOURNAL_ENTRY.ACCRUAL_REV_CHANGE_SIGN_FLAG
, ''Y''
, ''C''
, ''N''
, ''S''):GL_LOOKUPS:REVERSAL_OPTION_CODE:MEANING'
, JOURNAL_ENTRY.DESCRIPTION
, JOURNAL_ENTRY.CONTROL_TOTAL
, JOURNAL_ENTRY.RUNNING_TOTAL_DR
, JOURNAL_ENTRY.RUNNING_TOTAL_CR
, JOURNAL_ENTRY.RUNNING_TOTAL_ACCOUNTED_DR
, JOURNAL_ENTRY.RUNNING_TOTAL_ACCOUNTED_CR
, JOURNAL_ENTRY.CURRENCY_CONVERSION_RATE
, JOURNAL_ENTRY.CURRENCY_CONVERSION_TYPE
, JOURNAL_ENTRY.CURRENCY_CONVERSION_DATE
, JOURNAL_ENTRY.EXTERNAL_REFERENCE
, JOURNAL_ENTRY.PARENT_JE_HEADER_ID
, JOURNAL_ENTRY.REVERSED_JE_HEADER_ID
, JOURNAL_ENTRY.DOC_SEQUENCE_VALUE
, JOURNAL_ENTRY.ORIGINATING_BAL_SEG_VALUE
, JOURNAL_ENTRY.REFERENCE_DATE
, JOURNAL_ENTRY.POSTING_ACCT_SEQ_VALUE
, JOURNAL_ENTRY.CLOSE_ACCT_SEQ_VALUE
FROM GL_JE_HEADERS JOURNAL_ENTRY
, GL_JE_CATEGORIES JOURNAL_CATEGORY
, GL_JE_SOURCES JOURNAL_SOURCE
, GL_ACCESS_SETS ACC
, GL_ACCESS_SET_LEDGERS LGR
WHERE ACC.ACCESS_SET_ID = GL_SECURITY_PKG.LOGIN_ACCESS_ID
AND LGR.ACCESS_SET_ID = ACC.ACCESS_SET_ID
AND LGR.LEDGER_ID = JOURNAL_ENTRY.LEDGER_ID
AND (ACC.SECURITY_SEGMENT_CODE = 'F' OR LGR.ACCESS_PRIVILEGE_CODE = 'F' OR EXISTS (SELECT 'ACCESS TO BSV/MSV'
FROM GL_JE_SEGMENT_VALUES SV
, GL_ACCESS_SET_ASSIGNMENTS ASA
WHERE SV.JE_HEADER_ID = JOURNAL_ENTRY.JE_HEADER_ID
AND SV.SEGMENT_TYPE_CODE = ACC.SECURITY_SEGMENT_CODE
AND ASA.ACCESS_SET_ID = ACC.ACCESS_SET_ID
AND ASA.LEDGER_ID = JOURNAL_ENTRY.LEDGER_ID
AND ASA.SEGMENT_VALUE = SV.SEGMENT_VALUE))
AND (JOURNAL_ENTRY.JE_CATEGORY = JOURNAL_CATEGORY.JE_CATEGORY_NAME)
AND (JOURNAL_ENTRY.JE_SOURCE = JOURNAL_SOURCE.JE_SOURCE_NAME) WITH READ ONLY

Columns

Name
JOURNAL_ENTRY_ID
JOURNAL_ENTRY_NAME
LEDGER_ID
JOURNAL_CATEGORY
JOURNAL_SOURCE
PERIOD_NAME
CURRENCY
"_LA:BALANCE_TYPE"
EFFECTIVE_DATE
"_LA:TAX_STATUS"
ENCUMBRANCE_TYPE_ID
BUDGET_VERSION_ID
JOURNAL_BATCH_ID
REVERSAL_DATE
REVERSAL_PERIOD
"_LA:REVERSE_STATUS_FLAG"
"_LA:REVERSAL_METHOD"
DESCRIPTION
CONTROL_TOTAL
ENTERED_JOURNAL_TOTAL_DR
ENTERED_JOURNAL_TOTAL_CR
CONVERTED_JOURNAL_TOTAL_DR
CONVERTED_JOURNAL_TOTAL_CR
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_TYPE_CODE
CURRENCY_CONVERSION_DATE
EXTERNAL_REFERENCE
PRIMARY_JOURNAL_ENTRY_ID
REVERSED_JOURNAL_ENTRY_ID
DOCUMENT_NUMBER
ORIGINATING_BAL_SEG_VALUE
REFERENCE_DATE
POSTING_ACCT_SEQ_VALUE
CLOSE_ACCT_SEQ_VALUE