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

Product:	JE - European Localizations
Description:	Norwegian Investment Tax multilingual view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.ROWID ROW_ID
, B.SET_OF_BOOKS_ID
, B.APPLICATION_COLUMN_NAME
, B.SEGMENT_NAME
, B.ID_FLEX_NUM
, B.FOR_SEGMENT_VALUE
, B.INV_CODE_COMBINATION_ID
, B.TAX_RATE
, T.DESCRIPTION
, B.LAST_UPDATE_DATE
, B.INACTIVE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.TAX_CODE_ALLOWED FROM JE_NO_INVEST_SETUP_B B
, JE_NO_INVEST_SETUP_TL T
WHERE B.SEGMENT_NAME = T.SEGMENT_NAME AND B.FOR_SEGMENT_VALUE = T.FOR_SEGMENT_VALUE AND B.TAX_CODE_ALLOWED = T.TAX_CODE_ALLOWED AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
SET_OF_BOOKS_ID
APPLICATION_COLUMN_NAME
SEGMENT_NAME
ID_FLEX_NUM
FOR_SEGMENT_VALUE
INV_CODE_COMBINATION_ID
TAX_RATE
DESCRIPTION
LAST_UPDATE_DATE
INACTIVE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
TAX_CODE_ALLOWED