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)
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)
|
|
|