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

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

View Text

SELECT TLV.INDICATOR_ID INDICATOR_ID
, AV.TARGET_LEVEL_ID TARGET_LEVEL_ID
, AV.ORGANIZATION_ID ORGANIZATION_ID
, AV.RESPONSIBILITY_ID RESPONSIBILITY_ID
, TLV.INDICATOR_NAME INDICATOR_NAME
, TLV.NAME TARGET_LEVEL_NAME
, ORG.NAME ORGANIZATION_NAME
, AV.ACTUAL_VALUE ACTUAL_VALUE
, AV.DIMENSION1_LEVEL_VALUE DIMENSION1_LEVEL_VALUE
, AV.DIMENSION2_LEVEL_VALUE DIMENSION2_LEVEL_VALUE
, AV.DIMENSION3_LEVEL_VALUE DIMENSION3_LEVEL_VALUE
, AV.DIMENSION4_LEVEL_VALUE DIMENSION4_LEVEL_VALUE
, AV.DIMENSION5_LEVEL_VALUE DIMENSION5_LEVEL_VALUE
, AV.CREATION_DATE
, AV.CREATED_BY
, AV.LAST_UPDATE_DATE
, AV.LAST_UPDATED_BY
, AV.LAST_UPDATE_LOGIN
FROM BIS_ACTUAL_VALUES AV
, BIS_TARGET_LEVELS_V TLV
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE AV.TARGET_LEVEL_ID = TLV.TARGET_LEVEL_ID
AND AV.ORGANIZATION_ID = ORG.ORGANIZATION_ID

Columns

Name
INDICATOR_ID
TARGET_LEVEL_ID
ORGANIZATION_ID
RESPONSIBILITY_ID
INDICATOR_NAME
TARGET_LEVEL_NAME
ORGANIZATION_NAME
ACTUAL_VALUE
DIMENSION1_LEVEL_VALUE
DIMENSION2_LEVEL_VALUE
DIMENSION3_LEVEL_VALUE
DIMENSION4_LEVEL_VALUE
DIMENSION5_LEVEL_VALUE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN