View: IGI_EER_JE_LINES_V

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

View Text

SELECT JEL.ROWID ROW_ID
, JEL.JE_HEADER_ID
, JEL.JE_LINE_NUM
, JEL.PERIOD_NAME
, JEL.CODE_COMBINATION_ID
, BAT.NAME BATCH_NAME
, BAT.JE_BATCH_ID JE_BATCH_ID
, HDR.NAME JOURNAL_ENTRY
, HDR.JE_SOURCE
, JEL.DESCRIPTION
, JEL.ACCOUNTED_DR
, JEL.ACCOUNTED_CR
FROM GL_JE_BATCHES BAT
, GL_JE_HEADERS HDR
, GL_JE_LINES JEL
WHERE HDR.JE_HEADER_ID = JEL.JE_HEADER_ID
AND HDR.JE_BATCH_ID = BAT.JE_BATCH_ID

Columns