FND Design Data [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: ViewAPPS.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