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.

VIEW: APPS.GLFV_JOURNAL_ENTRIES

Source

View Text - Preformatted


SELECT JE1.JE_HEADER_ID, JE1.NAME, JE1.LEDGER_ID, LEDGER.NAME, JOURNAL_CATEGORY.USER_JE_CATEGORY_NAME, JOURNAL_SOURCE.USER_JE_SOURCE_NAME, JE1.PERIOD_NAME, JE1.CURRENCY_CODE, '_LA:JE1.ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION', JE1.DEFAULT_EFFECTIVE_DATE, '_LA:JE1.TAX_STATUS_CODE:GL_LOOKUPS:TAX_STATUS:MEANING', JE1.ENCUMBRANCE_TYPE_ID, GL_ENCUMBRANCE_TYPE.ENCUMBRANCE_TYPE, JE1.BUDGET_VERSION_ID, GL_BUDGET_VERSION.BUDGET_NAME, JE1.JE_BATCH_ID, JOURNAL_BATCH.NAME, JE1.ACCRUAL_REV_EFFECTIVE_DATE, JE1.ACCRUAL_REV_PERIOD_NAME, '_LA:JE1.ACCRUAL_REV_STATUS:GL_LOOKUPS:JE_REVERSAL_STATUS:MEANING', '_LA:DECODE(JE1.ACCRUAL_REV_CHANGE_SIGN_FLAG,''Y'', ''C'',''N'', ''S''):GL_LOOKUPS:REVERSAL_OPTION_CODE:MEANING', JE1.DESCRIPTION, JE1.CONTROL_TOTAL, JE1.RUNNING_TOTAL_DR, JE1.RUNNING_TOTAL_CR, JE1.RUNNING_TOTAL_ACCOUNTED_DR, JE1.RUNNING_TOTAL_ACCOUNTED_CR, JE1.CURRENCY_CONVERSION_RATE, JE1.CURRENCY_CONVERSION_TYPE, GL_CONVERSION_TYPE.USER_CONVERSION_TYPE, JE1.CURRENCY_CONVERSION_DATE, JE1.EXTERNAL_REFERENCE, JE1.PARENT_JE_HEADER_ID, JE2.NAME, JE1.REVERSED_JE_HEADER_ID, JE3.NAME, JE1.DOC_SEQUENCE_VALUE, JE1.ORIGINATING_BAL_SEG_VALUE, JE1.REFERENCE_DATE, JE1.POSTING_ACCT_SEQ_VALUE, JE1.CLOSE_ACCT_SEQ_VALUE, '_DF:SQLGL:GL_JE_HEADERS:JE1' FROM GL_JE_HEADERS JE1, GL_LEDGERS LEDGER, GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPE, GL_BUDGET_VERSIONS GL_BUDGET_VERSION, GL_JE_BATCHES JOURNAL_BATCH, GL_JE_HEADERS JE2, GL_JE_HEADERS JE3, GL_JE_CATEGORIES JOURNAL_CATEGORY, GL_JE_SOURCES JOURNAL_SOURCE, GL_DAILY_CONVERSION_TYPES GL_CONVERSION_TYPE, 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 = JE1.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 = JE1.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 = JE1.LEDGER_ID AND ASA.SEGMENT_VALUE = SV.SEGMENT_VALUE)) AND (LEDGER.LEDGER_ID = LGR.LEDGER_ID) AND (JE1.ENCUMBRANCE_TYPE_ID = GL_ENCUMBRANCE_TYPE.ENCUMBRANCE_TYPE_ID (+)) AND (JE1.BUDGET_VERSION_ID = GL_BUDGET_VERSION.BUDGET_VERSION_ID (+)) AND (JE1.JE_BATCH_ID = JOURNAL_BATCH.JE_BATCH_ID ) AND (JE1.PARENT_JE_HEADER_ID = JE2.JE_HEADER_ID (+)) AND (JE1.REVERSED_JE_HEADER_ID = JE3.JE_HEADER_ID (+)) AND (JE1.JE_CATEGORY = JOURNAL_CATEGORY.JE_CATEGORY_NAME) AND (JE1.JE_SOURCE = JOURNAL_SOURCE.JE_SOURCE_NAME) AND (JE1.CURRENCY_CONVERSION_TYPE = GL_CONVERSION_TYPE.CONVERSION_TYPE) WITH READ ONLY

View Text - HTML Formatted

SELECT JE1.JE_HEADER_ID
, JE1.NAME
, JE1.LEDGER_ID
, LEDGER.NAME
, JOURNAL_CATEGORY.USER_JE_CATEGORY_NAME
, JOURNAL_SOURCE.USER_JE_SOURCE_NAME
, JE1.PERIOD_NAME
, JE1.CURRENCY_CODE
, '_LA:JE1.ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION'
, JE1.DEFAULT_EFFECTIVE_DATE
, '_LA:JE1.TAX_STATUS_CODE:GL_LOOKUPS:TAX_STATUS:MEANING'
, JE1.ENCUMBRANCE_TYPE_ID
, GL_ENCUMBRANCE_TYPE.ENCUMBRANCE_TYPE
, JE1.BUDGET_VERSION_ID
, GL_BUDGET_VERSION.BUDGET_NAME
, JE1.JE_BATCH_ID
, JOURNAL_BATCH.NAME
, JE1.ACCRUAL_REV_EFFECTIVE_DATE
, JE1.ACCRUAL_REV_PERIOD_NAME
, '_LA:JE1.ACCRUAL_REV_STATUS:GL_LOOKUPS:JE_REVERSAL_STATUS:MEANING'
, '_LA:DECODE(JE1.ACCRUAL_REV_CHANGE_SIGN_FLAG
, ''Y''
, ''C''
, ''N''
, ''S''):GL_LOOKUPS:REVERSAL_OPTION_CODE:MEANING'
, JE1.DESCRIPTION
, JE1.CONTROL_TOTAL
, JE1.RUNNING_TOTAL_DR
, JE1.RUNNING_TOTAL_CR
, JE1.RUNNING_TOTAL_ACCOUNTED_DR
, JE1.RUNNING_TOTAL_ACCOUNTED_CR
, JE1.CURRENCY_CONVERSION_RATE
, JE1.CURRENCY_CONVERSION_TYPE
, GL_CONVERSION_TYPE.USER_CONVERSION_TYPE
, JE1.CURRENCY_CONVERSION_DATE
, JE1.EXTERNAL_REFERENCE
, JE1.PARENT_JE_HEADER_ID
, JE2.NAME
, JE1.REVERSED_JE_HEADER_ID
, JE3.NAME
, JE1.DOC_SEQUENCE_VALUE
, JE1.ORIGINATING_BAL_SEG_VALUE
, JE1.REFERENCE_DATE
, JE1.POSTING_ACCT_SEQ_VALUE
, JE1.CLOSE_ACCT_SEQ_VALUE
, '_DF:SQLGL:GL_JE_HEADERS:JE1'
FROM GL_JE_HEADERS JE1
, GL_LEDGERS LEDGER
, GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPE
, GL_BUDGET_VERSIONS GL_BUDGET_VERSION
, GL_JE_BATCHES JOURNAL_BATCH
, GL_JE_HEADERS JE2
, GL_JE_HEADERS JE3
, GL_JE_CATEGORIES JOURNAL_CATEGORY
, GL_JE_SOURCES JOURNAL_SOURCE
, GL_DAILY_CONVERSION_TYPES GL_CONVERSION_TYPE
, 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 = JE1.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 = JE1.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 = JE1.LEDGER_ID
AND ASA.SEGMENT_VALUE = SV.SEGMENT_VALUE))
AND (LEDGER.LEDGER_ID = LGR.LEDGER_ID)
AND (JE1.ENCUMBRANCE_TYPE_ID = GL_ENCUMBRANCE_TYPE.ENCUMBRANCE_TYPE_ID (+))
AND (JE1.BUDGET_VERSION_ID = GL_BUDGET_VERSION.BUDGET_VERSION_ID (+))
AND (JE1.JE_BATCH_ID = JOURNAL_BATCH.JE_BATCH_ID )
AND (JE1.PARENT_JE_HEADER_ID = JE2.JE_HEADER_ID (+))
AND (JE1.REVERSED_JE_HEADER_ID = JE3.JE_HEADER_ID (+))
AND (JE1.JE_CATEGORY = JOURNAL_CATEGORY.JE_CATEGORY_NAME)
AND (JE1.JE_SOURCE = JOURNAL_SOURCE.JE_SOURCE_NAME)
AND (JE1.CURRENCY_CONVERSION_TYPE = GL_CONVERSION_TYPE.CONVERSION_TYPE) WITH READ ONLY