[Home] [Help]
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
Name |
ROW_ID |
JE_HEADER_ID |
JE_LINE_NUM |
PERIOD_NAME |
CODE_COMBINATION_ID |
BATCH_NAME |
JE_BATCH_ID |
JOURNAL_ENTRY |
JE_SOURCE |
DESCRIPTION |
ACCOUNTED_DR |
ACCOUNTED_CR |