eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GL_JE_HEADERS_LOV_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT H.JE_HEADER_ID JE_HEADER_ID
, H.JE_BATCH_ID JE_BATCH_ID
, H.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, H.NAME NAME
, H.DESCRIPTION DESCRIPTION
, B.NAME BATCH_NAME
, H.ACTUAL_FLAG ACTUAL_FLAG
, H.PERIOD_NAME PERIOD_NAME
FROM GL_JE_HEADERS H
, GL_JE_BATCHES B
WHERE B.JE_BATCH_ID = H.JE_BATCH_ID + 0

Columns

Name
JE_HEADER_ID
JE_BATCH_ID
SET_OF_BOOKS_ID
NAME
DESCRIPTION
BATCH_NAME
ACTUAL_FLAG
PERIOD_NAME