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: XLA_GL_JE_AEL_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_GL_JE_AEL_V

View Text

SELECT 101 APPLICATION_ID
, 'JRNL' TRX_HDR_TABLE
, JEH.JE_HEADER_ID TRX_HDR_ID
, JEH.LEDGER_ID SET_OF_BOOKS_ID
, JEH.DATE_CREATED GL_DATE
, L.MEANING ACCT_LINE_TYPE_NAME
, JEH.PERIOD_NAME PERIOD_NAME
, JEH.STATUS STATUS
, JEH.CURRENCY_CODE CURRENCY_CODE
, L.MEANING||' '||JEL.JE_LINE_NUM AE_LINE_REFERENCE
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, JEL.ACCOUNTED_DR ACCOUNTED_DR
, JEL.ACCOUNTED_CR ACCOUNTED_CR
, L.LOOKUP_CODE ACCT_LINE_TYPE
, LPAD(JEL.JE_LINE_NUM
, 15
, '0') AE_LINE_REFERENCE_INTERNAL
FROM FND_LOOKUPS L
, GL_JE_LINES JEL
, GL_JE_HEADERS JEH
WHERE JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND L.LOOKUP_TYPE = 'XLA_VIEW_ACCOUNTING'
AND L.LOOKUP_CODE = 'LINE'

Columns

Name
APPLICATION_ID
TRX_HDR_TABLE
TRX_HDR_ID
SET_OF_BOOKS_ID
GL_DATE
ACCT_LINE_TYPE_NAME
PERIOD_NAME
STATUS
CURRENCY_CODE
AE_LINE_REFERENCE
CODE_COMBINATION_ID
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
ACCT_LINE_TYPE
AE_LINE_REFERENCE_INTERNAL