FND Design Data [Home] [Help]

View: GLFV_ACTUAL_JOURNAL_ENTRIES

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

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
, JE1.DEFAULT_EFFECTIVE_DATE
, '_LA:JE1.TAX_STATUS_CODE:GL_LOOKUPS:TAX_STATUS:MEANING'
, 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_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.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.ACTUAL_FLAG = 'A')
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

Columns

Name
JOURNAL_ENTRY_ID
JOURNAL_ENTRY_NAME
LEDGER_ID
LEDGER_NAME
JOURNAL_CATEGORY
JOURNAL_SOURCE
PERIOD_NAME
CURRENCY
EFFECTIVE_DATE
"_LA:TAX_STATUS"
JOURNAL_BATCH_ID
JOURNAL_BATCH_NAME
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_TYPE
CURRENCY_CONVERSION_DATE
EXTERNAL_REFERENCE
PRIMARY_JOURNAL_ENTRY_ID
PRIMARY_JOURNAL_ENTRY_NAME
REVERSED_JOURNAL_ENTRY_ID
REVERSED_JOURNAL_ENTRY_NAME
DOCUMENT_NUMBER
ORIGINATING_BAL_SEG_VALUE
REFERENCE_DATE
POSTING_ACCT_SEQ_VALUE
CLOSE_ACCT_SEQ_VALUE
_DF