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.JE_NO_GEI_SREPORT_V

Source

View Text - Preformatted


SELECT gcc.segment4 authority_type ,gbs.period_name period ,gbs.actual_flag actual_flag ,gcc.segment2 account_number ,(gbs.period_net_dr - gbs.period_net_cr) balance ,gbs.template_id template_id , gbs.period_num period_num , gbs.period_year period_year from gl_code_combinations gcc , gl_balances gbs , gl_sets_of_books gso WHERE gbs.code_combination_id = gcc.code_combination_id and gbs.ledger_id = gso.set_of_books_id and gso.currency_code = gbs.currency_code

View Text - HTML Formatted

SELECT GCC.SEGMENT4 AUTHORITY_TYPE
, GBS.PERIOD_NAME PERIOD
, GBS.ACTUAL_FLAG ACTUAL_FLAG
, GCC.SEGMENT2 ACCOUNT_NUMBER
, (GBS.PERIOD_NET_DR - GBS.PERIOD_NET_CR) BALANCE
, GBS.TEMPLATE_ID TEMPLATE_ID
, GBS.PERIOD_NUM PERIOD_NUM
, GBS.PERIOD_YEAR PERIOD_YEAR
FROM GL_CODE_COMBINATIONS GCC
, GL_BALANCES GBS
, GL_SETS_OF_BOOKS GSO
WHERE GBS.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND GBS.LEDGER_ID = GSO.SET_OF_BOOKS_ID
AND GSO.CURRENCY_CODE = GBS.CURRENCY_CODE