View: GLBV_ENCUMB_JOURNAL_ENTRIES

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GLBV_ENCUMB_JOURNAL_ENTRIES

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.DEFAULT_EFFECTIVE_DATE
, JOURNAL_ENTRY.ENCUMBRANCE_TYPE_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.EXTERNAL_REFERENCE
, JOURNAL_ENTRY.PARENT_JE_HEADER_ID
, JOURNAL_ENTRY.REVERSED_JE_HEADER_ID
, JOURNAL_ENTRY.DOC_SEQUENCE_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)
AND (JOURNAL_ENTRY.ACTUAL_FLAG = 'E') WITH READ ONLY

Columns