View: BIS_LATEST_ACTUAL_VALUES_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.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