[Home] [Help]
View: AMS_IBA_OP_PROMPT_VL
Product: | AMS - Marketing |
Description: | Lists the explicit rating prompts |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OPMB.PROMPT_ID PROMPT_ID
, OPMB.SCORE SCORE
, OPMT.PROMPT_TEXT PROMPT_TEXT
, OPMB.ICON_FILE_NAME ICON_FILE_NAME
, OPMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OPMB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, OPMB.CREATED_BY
, OPMB.CREATION_DATE
, OPMB.LAST_UPDATED_BY
, OPMB.LAST_UPDATE_DATE
, OPMB.LAST_UPDATE_LOGIN
FROM AMS_IBA_OP_PROMPT_B OPMB
, AMS_IBA_OP_PROMPT_TL OPMT
WHERE OPMB.PROMPT_ID = OPMT.PROMPT_ID
AND OPMT.LANGUAGE = USERENV('LANG')
Columns
Name |
PROMPT_ID |
SCORE |
PROMPT_TEXT |
ICON_FILE_NAME |
OBJECT_VERSION_NUMBER |
SECURITY_GROUP_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |