View: GL_BUDGET_JOURNALS_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_BUDGET_JOURNALS_V

View Text

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

Columns