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

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BISBV_TARGET_LEVELS

View Text

SELECT BIS_TARGET_LEVELS.TARGET_LEVEL_ID
, BIS_TARGET_LEVELS.SHORT_NAME
, BIS_TARGET_LEVELS_TL.NAME
, BIS_TARGET_LEVELS_TL.DESCRIPTION
, BIS_TARGET_LEVELS.INDICATOR_ID
, BIS_TARGET_LEVELS.ORG_LEVEL_ID
, BIS_TARGET_LEVELS.TIME_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID
, BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID
, BIS_TARGET_LEVELS.WF_ITEM_TYPE
, BIS_TARGET_LEVELS.WF_PROCESS
, BIS_TARGET_LEVELS.DEFAULT_ROLE_ID
, BIS_TARGET_LEVELS.DEFAULT_ROLE
, BIS_TARGET_LEVELS.DEFAULT_COMPUTING_FUNCTION_ID
, BIS_TARGET_LEVELS.REPORT_FUNCTION_ID
, BIS_TARGET_LEVELS_TL.UNIT_OF_MEASURE
, BIS_TARGET_LEVELS.SYSTEM_FLAG
FROM BIS_TARGET_LEVELS BIS_TARGET_LEVELS
, BIS_TARGET_LEVELS_TL BIS_TARGET_LEVELS_TL
WHERE BIS_TARGET_LEVELS.TARGET_LEVEL_ID = BIS_TARGET_LEVELS_TL.TARGET_LEVEL_ID
AND BIS_TARGET_LEVELS_TL.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns

Name
TARGET_LEVEL_ID
TARGET_LEVEL_SHORT_NAME
TARGET_LEVEL_NAME
DESCRIPTION
MEASURE_ID
ORG_LEVEL_ID
TIME_LEVEL_ID
DIMENSION1_LEVEL_ID
DIMENSION2_LEVEL_ID
DIMENSION3_LEVEL_ID
DIMENSION4_LEVEL_ID
DIMENSION5_LEVEL_ID
DIMENSION6_LEVEL_ID
DIMENSION7_LEVEL_ID
WORKFLOW_ITEM_TYPE
WORKFLOW_PROCESS_SHORT_NAME
DEFAULT_NOTIFY_RESP_ID
DEFAULT_NOTIFY_RESP_SHORT_NAME
COMPUTING_FUNCTION_ID
REPORT_FUNCTION_ID
UNIT_OF_MEASURE
SYSTEM_FLAG