VIEW: APPS.BIS_ACTUAL_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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