View: IGI_COM_GL_JE_LINES_V

Product:	IGI - Public Sector Financials International
Description:	Based on GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES and GL_JE_SOURCES_TL
Implementation/DBA Data:	APPS.IGI_COM_GL_JE_LINES_V

View Text

SELECT L.ROWID ROW_ID
, H.SET_OF_BOOKS_ID
, H.JE_SOURCE
, H.PERIOD_NAME
, H.ACTUAL_FLAG
, H.BUDGET_VERSION_ID
, H.ENCUMBRANCE_TYPE_ID
, H.DESCRIPTION HEADER_DESCRIPTION
, S.USER_JE_SOURCE_NAME
, H.JE_CATEGORY
, H.NAME HEADER_NAME
, B.NAME BATCH_NAME
, B.DESCRIPTION BATCH_DESCRIPTION
, H.CURRENCY_CODE
, H.JE_BATCH_ID
, L.CODE_COMBINATION_ID LINE_CODE_COMBINATION_ID
, L.JE_LINE_NUM LINE_JE_LINE_NUM
, L.ENTERED_DR LINE_ENTERED_DR
, L.ENTERED_CR LINE_ENTERED_CR
, L.DESCRIPTION LINE_DESCRIPTION
, L.JE_HEADER_ID
, B.STATUS BATCH_STATUS
FROM GL_JE_BATCHES B
, GL_JE_HEADERS H
, GL_JE_LINES L
, GL_JE_SOURCES_TL S
WHERE B.JE_BATCH_ID = H.JE_BATCH_ID
AND S.JE_SOURCE_NAME = H.JE_SOURCE
AND H.JE_HEADER_ID = L.JE_HEADER_ID
AND H.STATUS = 'P'
AND S.LANGUAGE = USERENV('LANG')

Columns