[Home] [Help]
View: AMS_CLIK_THRU_ACTIONS_VL
Product: | AMS - Marketing |
Description: | View on top of AMS_CLIK_THRU_ACTIONS_B and AMS_CLIK_THRU_ACTIONS_TL. |
Implementation/DBA Data: |
APPS.AMS_CLIK_THRU_ACTIONS_VL
|
View Text
SELECT B.APPLICABLE_FOR
, B.DYNAMIC_PARAMS_FLAG
, B.ADHOC_PARAMS_FLAG
, B.SECURITY_GROUP_ID
, B.CREATED_BY
, T.ACTION_CODE_MEANING
, B.ACTION_ID
, B.ACTION_CODE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
, T.DESCRIPTION
, B.NEW_JAVA_CLASS_NAME
, B.DEPENDS_ON_APP
, B.APPLICATION_ID
, B.ENABLED_FLAG
FROM AMS_CLIK_THRU_ACTIONS_TL T
, AMS_CLIK_THRU_ACTIONS_B B
WHERE B.ACTION_ID = T.ACTION_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
APPLICABLE_FOR |
DYNAMIC_PARAMS_FLAG |
ADHOC_PARAMS_FLAG |
SECURITY_GROUP_ID |
CREATED_BY |
ACTION_NAME |
ACTION_ID |
ACTION_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATION_DATE |
OBJECT_VERSION_NUMBER |
DESCRIPTION |
NEW_JAVA_CLASS_NAME |
DEPENDS_ON_APP |
APPLICATION_ID |
ENABLED_FLAG |