VIEW: APPS.GLFV_BUDGET_JOURNAL_ENTRIES

Source

View Text - Preformatted

SELECT JOURNAL_ENTRY1.JE_HEADER_ID, JOURNAL_ENTRY1.NAME, JOURNAL_ENTRY1.LEDGER_ID, LEDGER.NAME, JOURNAL_CATEGORY.USER_JE_CATEGORY_NAME, JOURNAL_SOURCE.USER_JE_SOURCE_NAME, JOURNAL_ENTRY1.PERIOD_NAME, JOURNAL_ENTRY1.CURRENCY_CODE, JOURNAL_ENTRY1.DEFAULT_EFFECTIVE_DATE, JOURNAL_ENTRY1.BUDGET_VERSION_ID, GL_BUDGET_VERSION.BUDGET_NAME, JOURNAL_ENTRY1.JE_BATCH_ID, JOURNAL_BATCH.NAME, JOURNAL_ENTRY1.ACCRUAL_REV_EFFECTIVE_DATE, JOURNAL_ENTRY1.ACCRUAL_REV_PERIOD_NAME, '_LA:JOURNAL_ENTRY1.ACCRUAL_REV_STATUS:GL_LOOKUPS:JE_REVERSAL_STATUS:MEANING', '_LA:DECODE(JOURNAL_ENTRY1.ACCRUAL_REV_CHANGE_SIGN_FLAG,''Y'', ''C'',''N'', ''S''):GL_LOOKUPS:REVERSAL_OPTION_CODE:MEANING', JOURNAL_ENTRY1.DESCRIPTION, JOURNAL_ENTRY1.CONTROL_TOTAL, JOURNAL_ENTRY1.RUNNING_TOTAL_DR, JOURNAL_ENTRY1.RUNNING_TOTAL_CR, JOURNAL_ENTRY1.EXTERNAL_REFERENCE, JOURNAL_ENTRY1.REVERSED_JE_HEADER_ID, JOURNAL_ENTRY3.NAME, JOURNAL_ENTRY1.DOC_SEQUENCE_VALUE, JOURNAL_ENTRY1.REFERENCE_DATE, JOURNAL_ENTRY1.POSTING_ACCT_SEQ_VALUE, JOURNAL_ENTRY1.CLOSE_ACCT_SEQ_VALUE, '_DF:SQLGL:GL_JE_HEADERS:JOURNAL_ENTRY1' FROM GL_JE_HEADERS JOURNAL_ENTRY1, GL_LEDGERS LEDGER, GL_BUDGET_VERSIONS GL_BUDGET_VERSION, GL_JE_BATCHES JOURNAL_BATCH, GL_JE_HEADERS JOURNAL_ENTRY3, 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_ENTRY1.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_ENTRY1.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_ENTRY1.LEDGER_ID AND ASA.SEGMENT_VALUE = SV.SEGMENT_VALUE)) AND (LEDGER.LEDGER_ID = LGR.LEDGER_ID) AND (JOURNAL_ENTRY1.BUDGET_VERSION_ID = GL_BUDGET_VERSION.BUDGET_VERSION_ID) AND (JOURNAL_ENTRY1.JE_BATCH_ID = JOURNAL_BATCH.JE_BATCH_ID) AND (JOURNAL_ENTRY1.REVERSED_JE_HEADER_ID = JOURNAL_ENTRY3.JE_HEADER_ID (+)) AND (JOURNAL_ENTRY1.ACTUAL_FLAG = 'B') AND (JOURNAL_ENTRY1.JE_CATEGORY = JOURNAL_CATEGORY.JE_CATEGORY_NAME) AND (JOURNAL_ENTRY1.JE_SOURCE = JOURNAL_SOURCE.JE_SOURCE_NAME) WITH READ ONLY

View Text - HTML Formatted

SELECT JOURNAL_ENTRY1.JE_HEADER_ID
, JOURNAL_ENTRY1.NAME
, JOURNAL_ENTRY1.LEDGER_ID
, LEDGER.NAME
, JOURNAL_CATEGORY.USER_JE_CATEGORY_NAME
, JOURNAL_SOURCE.USER_JE_SOURCE_NAME
, JOURNAL_ENTRY1.PERIOD_NAME
, JOURNAL_ENTRY1.CURRENCY_CODE
, JOURNAL_ENTRY1.DEFAULT_EFFECTIVE_DATE
, JOURNAL_ENTRY1.BUDGET_VERSION_ID
, GL_BUDGET_VERSION.BUDGET_NAME
, JOURNAL_ENTRY1.JE_BATCH_ID
, JOURNAL_BATCH.NAME
, JOURNAL_ENTRY1.ACCRUAL_REV_EFFECTIVE_DATE
, JOURNAL_ENTRY1.ACCRUAL_REV_PERIOD_NAME
, '_LA:JOURNAL_ENTRY1.ACCRUAL_REV_STATUS:GL_LOOKUPS:JE_REVERSAL_STATUS:MEANING'
, '_LA:DECODE(JOURNAL_ENTRY1.ACCRUAL_REV_CHANGE_SIGN_FLAG
, ''Y''
, ''C''
, ''N''
, ''S''):GL_LOOKUPS:REVERSAL_OPTION_CODE:MEANING'
, JOURNAL_ENTRY1.DESCRIPTION
, JOURNAL_ENTRY1.CONTROL_TOTAL
, JOURNAL_ENTRY1.RUNNING_TOTAL_DR
, JOURNAL_ENTRY1.RUNNING_TOTAL_CR
, JOURNAL_ENTRY1.EXTERNAL_REFERENCE
, JOURNAL_ENTRY1.REVERSED_JE_HEADER_ID
, JOURNAL_ENTRY3.NAME
, JOURNAL_ENTRY1.DOC_SEQUENCE_VALUE
, JOURNAL_ENTRY1.REFERENCE_DATE
, JOURNAL_ENTRY1.POSTING_ACCT_SEQ_VALUE
, JOURNAL_ENTRY1.CLOSE_ACCT_SEQ_VALUE
, '_DF:SQLGL:GL_JE_HEADERS:JOURNAL_ENTRY1'
FROM GL_JE_HEADERS JOURNAL_ENTRY1
, GL_LEDGERS LEDGER
, GL_BUDGET_VERSIONS GL_BUDGET_VERSION
, GL_JE_BATCHES JOURNAL_BATCH
, GL_JE_HEADERS JOURNAL_ENTRY3
, 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_ENTRY1.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_ENTRY1.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_ENTRY1.LEDGER_ID
AND ASA.SEGMENT_VALUE = SV.SEGMENT_VALUE))
AND (LEDGER.LEDGER_ID = LGR.LEDGER_ID)
AND (JOURNAL_ENTRY1.BUDGET_VERSION_ID = GL_BUDGET_VERSION.BUDGET_VERSION_ID)
AND (JOURNAL_ENTRY1.JE_BATCH_ID = JOURNAL_BATCH.JE_BATCH_ID)
AND (JOURNAL_ENTRY1.REVERSED_JE_HEADER_ID = JOURNAL_ENTRY3.JE_HEADER_ID (+))
AND (JOURNAL_ENTRY1.ACTUAL_FLAG = 'B')
AND (JOURNAL_ENTRY1.JE_CATEGORY = JOURNAL_CATEGORY.JE_CATEGORY_NAME)
AND (JOURNAL_ENTRY1.JE_SOURCE = JOURNAL_SOURCE.JE_SOURCE_NAME) WITH READ ONLY