VIEW: APPS.GLBV_JOURNAL_LINES

Source

View Text - Preformatted

SELECT JOURNAL_LINE.JE_HEADER_ID, JOURNAL_ENTRY.NAME, JOURNAL_LINE.JE_LINE_NUM, JOURNAL_LINE.LEDGER_ID, JOURNAL_LINE.CODE_COMBINATION_ID, 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 FROM GL_JE_LINES JOURNAL_LINE, GL_JE_HEADERS JOURNAL_ENTRY WHERE JOURNAL_LINE.JE_HEADER_ID = JOURNAL_ENTRY.JE_HEADER_ID AND '_SEC:GL:JOURNAL_LINE.LEDGER_ID,JOURNAL_LINE.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT JOURNAL_LINE.JE_HEADER_ID
, JOURNAL_ENTRY.NAME
, JOURNAL_LINE.JE_LINE_NUM
, JOURNAL_LINE.LEDGER_ID
, JOURNAL_LINE.CODE_COMBINATION_ID
, 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
FROM GL_JE_LINES JOURNAL_LINE
, GL_JE_HEADERS JOURNAL_ENTRY
WHERE JOURNAL_LINE.JE_HEADER_ID = JOURNAL_ENTRY.JE_HEADER_ID
AND '_SEC:GL:JOURNAL_LINE.LEDGER_ID
, JOURNAL_LINE.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY