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.

VIEW: APPS.XLA_GL_JE_AEL_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'