eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_CLIK_THRU_ACTIONS_VL

Object Details

Object Name:	AMS_CLIK_THRU_ACTIONS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_CLIK_THRU_ACTIONS_VL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

MultiLingual view (a language resolved view of the data.)

View on top of AMS_CLIK_THRU_ACTIONS_B and AMS_CLIK_THRU_ACTIONS_TL.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICABLE_FOR	VARCHAR2	(1000)		A comma separated list of the object types associated with the Object used in Execution that support this Action. If the value is NULL, Action applies to all type of Objects. Typical Object Types are Email, Web Add and Web Promotion.
DYNAMIC_PARAMS_FLAG	VARCHAR2	(1)	Yes	Indicates whether the Action Parameters are dynamic.
ADHOC_PARAMS_FLAG	VARCHAR2	(1)	Yes	Indicates whether the Action has adhoc parameters. If there are adhoc parameters, the UI will accept the Parameter Name and Values for upto a specific number of Parameters.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
ACTION_NAME	VARCHAR2	(240)	Yes
ACTION_ID	NUMBER		Yes
ACTION_CODE	VARCHAR2	(30)	Yes	Code associated with the Click Through Action.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for optimistic locking.
DESCRIPTION	VARCHAR2	(2000)		Description of the Action.
NEW_JAVA_CLASS_NAME	VARCHAR2	(1000)
DEPENDS_ON_APP	VARCHAR2	(100)		Application Short Name associated with the Application that this Action depends on.
APPLICATION_ID	NUMBER		Yes	Application ID of the Application that created this Action.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the Action is enabled.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.AMS_CLIK_THRU_ACTIONS_VL;

Dependencies

[top of page]

APPS.AMS_CLIK_THRU_ACTIONS_VL references the following:

APPS: AMS_CLIK_THRU_ACTIONS_B; AMS_CLIK_THRU_ACTIONS_TL

APPS.AMS_CLIK_THRU_ACTIONS_VL is referenced by following:

APPS: AMS_CTD_ASSOC_V