View: JE_NO_GEI_SREPORT_V

Product:	JE - European Localizations
Description:	View contains accounting info based on GL_CODE_COMBINATIONS and GL_BALANCES. View is recreated at runtime.
Implementation/DBA Data:	APPS.JE_NO_GEI_SREPORT_V

View Text

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

Columns