VIEW: APPS.GL_BUDGET_JOURNALS_V

Source

View Text - Preformatted

SELECT jeh.ledger_id LEDGER_ID, jeb.name BATCH_NAME, jeb.description BATCH_DESCRIPTION, jeb.default_period_name DEFAULT_PERIOD_NAME, jeb.je_batch_id JE_BATCH_ID, jeh.name JE_NAME, jeh.description JE_DESCRIPTION, jeh.je_header_id JE_HEADER_ID, jeh.period_name JE_PERIOD_NAME, jeh.currency_code CURRENCY_CODE, jeh.status JE_STATUS, jeh.budget_version_id JE_BUDGET_VERSION_ID, jel.je_line_num JE_LINE_NUM, jel.description JE_LINE_DESCRIPTION, jel.period_name JE_LINE_PERIOD_NAME, jel.code_combination_id CODE_COMBINATION_ID, jel.entered_dr ENTERED_DR, jel.entered_cr ENTERED_CR, jel.accounted_dr ACCOUNTED_DR, jel.accounted_cr ACCOUNTED_CR, jel.reference_1 REFERENCE_1, jel.reference_2 REFERENCE_2, jel.reference_3 REFERENCE_3, jel.reference_4 REFERENCE_4, jel.reference_5 REFERENCE_5, jel.stat_amount STAT_AMOUNT, jeb.posted_date POSTED_DATE, lk1.meaning STATUS_VERIFIED, jes.user_je_source_name USER_JE_SOURCE_NAME, jec.user_je_category_name USER_JE_CATEGORY_NAME, jel.rowid ROW_ID, jel.creation_date CREATION_DATE, jel.created_by CREATED_BY, jel.last_update_date LAST_UPDATE_DATE, jel.last_updated_by LAST_UPDATED_BY, jel.last_update_login LAST_UPDATE_LOGIN FROM gl_lookups lk1, gl_je_categories jec, gl_je_sources jes, gl_je_lines jel, gl_je_headers jeh, gl_je_batches jeb WHERE jel.je_header_id = jeh.je_header_id AND jeh.je_batch_id = jeb.je_batch_id AND jeh.actual_flag = 'B' AND jeh.status = 'P' AND lk1.lookup_type = 'YES/NO' AND lk1.lookup_code = jeb.status_verified AND jes.je_source_name = jeh.je_source AND jec.je_category_name = jeh.je_category

View Text - HTML Formatted

SELECT JEH.LEDGER_ID LEDGER_ID
, JEB.NAME BATCH_NAME
, JEB.DESCRIPTION BATCH_DESCRIPTION
, JEB.DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME
, JEB.JE_BATCH_ID JE_BATCH_ID
, JEH.NAME JE_NAME
, JEH.DESCRIPTION JE_DESCRIPTION
, JEH.JE_HEADER_ID JE_HEADER_ID
, JEH.PERIOD_NAME JE_PERIOD_NAME
, JEH.CURRENCY_CODE CURRENCY_CODE
, JEH.STATUS JE_STATUS
, JEH.BUDGET_VERSION_ID JE_BUDGET_VERSION_ID
, JEL.JE_LINE_NUM JE_LINE_NUM
, JEL.DESCRIPTION JE_LINE_DESCRIPTION
, JEL.PERIOD_NAME JE_LINE_PERIOD_NAME
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, JEL.ACCOUNTED_DR ACCOUNTED_DR
, JEL.ACCOUNTED_CR ACCOUNTED_CR
, JEL.REFERENCE_1 REFERENCE_1
, JEL.REFERENCE_2 REFERENCE_2
, JEL.REFERENCE_3 REFERENCE_3
, JEL.REFERENCE_4 REFERENCE_4
, JEL.REFERENCE_5 REFERENCE_5
, JEL.STAT_AMOUNT STAT_AMOUNT
, JEB.POSTED_DATE POSTED_DATE
, LK1.MEANING STATUS_VERIFIED
, JES.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, JEC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, JEL.ROWID ROW_ID
, JEL.CREATION_DATE CREATION_DATE
, JEL.CREATED_BY CREATED_BY
, JEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JEL.LAST_UPDATED_BY LAST_UPDATED_BY
, JEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM GL_LOOKUPS LK1
, GL_JE_CATEGORIES JEC
, GL_JE_SOURCES JES
, GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_JE_BATCHES JEB
WHERE JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND JEH.JE_BATCH_ID = JEB.JE_BATCH_ID
AND JEH.ACTUAL_FLAG = 'B'
AND JEH.STATUS = 'P'
AND LK1.LOOKUP_TYPE = 'YES/NO'
AND LK1.LOOKUP_CODE = JEB.STATUS_VERIFIED
AND JES.JE_SOURCE_NAME = JEH.JE_SOURCE
AND JEC.JE_CATEGORY_NAME = JEH.JE_CATEGORY