[Home] [Help]
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
Name |
AUTHORITY_TYPE |
PERIOD |
ACTUAL_FLAG |
ACCOUNT_NUMBER |
BALANCE |
TEMPLATE_ID |
PERIOD_NUM |
PERIOD_YEAR |