VIEW: APPS.IGI_EER_JE_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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