Product: | AMS - Marketing |
---|---|
Description: | This view stores the value meanings for lovs based on manually entered values created in Audience Workbench. |
Implementation/DBA Data: | APPS.AMS_ATTB_LOV_VALUES_VL |
SELECT B.ROWID ROW_ID
, B.ATTB_LOV_VALUE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.REQUEST_ID
, B.PROGRAM_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_UPDATE_DATE
, B.VIEW_APPLICATION_ID
, B.ATTB_LOV_ID
, B.VALUE_CODE
, B.SECURITY_GROUP_ID
, T.VALUE_MEANING
FROM AMS_ATTB_LOV_VALUES_TL T
, AMS_ATTB_LOV_VALUES_B B
WHERE B.ATTB_LOV_VALUE_ID = T.ATTB_LOV_VALUE_ID
AND T.LANGUAGE = USERENV('LANG')