View: GLFV_JOURNAL_LINES

Product:	GL - General Ledger
Description:	General Ledger journal lines record debit or credit amounts to General Ledger accounts, or use formulas to calculate journal amounts for General Ledger accounts.
Implementation/DBA Data:	APPS.GLFV_JOURNAL_LINES

View Text

SELECT JOURNAL_LINE.JE_HEADER_ID
, JOURNAL_ENTRY.NAME
, JOURNAL_LINE.JE_LINE_NUM
, JOURNAL_LINE.LEDGER_ID
, LEDGER.NAME
, JOURNAL_LINE.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, JOURNAL_LINE.PERIOD_NAME
, JOURNAL_LINE.EFFECTIVE_DATE
, JOURNAL_LINE.ENTERED_DR
, JOURNAL_LINE.ENTERED_CR
, JOURNAL_LINE.ACCOUNTED_DR
, JOURNAL_LINE.ACCOUNTED_CR
, JOURNAL_LINE.DESCRIPTION
, JOURNAL_LINE.STAT_AMOUNT
, JOURNAL_LINE.SUBLEDGER_DOC_SEQUENCE_VALUE
, JOURNAL_LINE.REFERENCE_1
, JOURNAL_LINE.REFERENCE_2
, JOURNAL_LINE.REFERENCE_3
, JOURNAL_LINE.REFERENCE_4
, JOURNAL_LINE.REFERENCE_5
, JOURNAL_LINE.REFERENCE_6
, JOURNAL_LINE.REFERENCE_7
, JOURNAL_LINE.REFERENCE_8
, JOURNAL_LINE.REFERENCE_9
, JOURNAL_LINE.REFERENCE_10
, '_DF:SQLGL:GL_JE_LINES:JOURNAL_LINE'
, '_DF:SQLGL:GL_JE_LINES_TAX:JOURNAL_LINE'
FROM GL_LEDGERS LEDGER
, GL_JE_LINES JOURNAL_LINE
, GL_JE_HEADERS JOURNAL_ENTRY
, GL_CODE_COMBINATIONS GCC
WHERE (JOURNAL_LINE.LEDGER_ID = LEDGER.LEDGER_ID)
AND (JOURNAL_LINE.JE_HEADER_ID = JOURNAL_ENTRY.JE_HEADER_ID)
AND (JOURNAL_LINE.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID)
AND '_SEC:GL:JOURNAL_LINE.LEDGER_ID
, JOURNAL_LINE.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY

Columns