[Home] [Help]
View: BIS_LATEST_ACTUAL_VALUES_V
View Text
SELECT A1.ORGANIZATION_ID
, A1.TARGET_LEVEL_ID
, A1.ACTUAL_VALUE
, A1.LAST_UPDATE_DATE
FROM BIS_ACTUAL_VALUES A1
WHERE A1.LAST_UPDATE_DATE = (SELECT MAX(A2.LAST_UPDATE_DATE)
FROM BIS_ACTUAL_VALUES A2
WHERE A2.TARGET_LEVEL_ID = A1.TARGET_LEVEL_ID
AND A2.ORGANIZATION_ID = A1.ORGANIZATION_ID)
Columns
Name |
ORGANIZATION_ID |
TARGET_LEVEL_ID |
ACTUAL_VALUE |
LAST_UPDATE_DATE |