[Home] [Help] [Dependency Information]
Object Name: | AMS_CLIK_THRU_ACTIONS_B |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_CLIK_THRU_ACTIONS_B |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_CLIK_THRU_ACTIONS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_ID | NUMBER | Yes | Primary Key. | |
ACTION_CODE | VARCHAR2 | (30) | Yes | Code associated with the Click Through Action. |
EXECUTABLE_NAME | VARCHAR2 | (1000) | Name of the Web Executable file associated with the Click Through Destination. | |
SERVER_URL | VARCHAR2 | (1000) | Users can specify their own Javascript validations. | |
PROFILE_FOR_SERVER_URL | VARCHAR2 | (100) | Holds the name of the Profile that defines the Server URL associated with the Click Through Action. | |
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. | |
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. | |
TRACK_FLAG | VARCHAR2 | (1) | Yes | Indicates whether theClick Through Destination needs to be Tracked in the Interaction History. |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the Action is enabled. |
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. |
JAVA_CLASS_NAME | VARCHAR2 | (1000) | The Java Class that is responsbile for calculating the Complete URL for this Action. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | This column is used for optimistic locking. |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
NEW_JAVA_CLASS_NAME | VARCHAR2 | (1000) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_ID
, ACTION_CODE
, EXECUTABLE_NAME
, SERVER_URL
, PROFILE_FOR_SERVER_URL
, DEPENDS_ON_APP
, APPLICATION_ID
, APPLICABLE_FOR
, TRACK_FLAG
, ENABLED_FLAG
, DYNAMIC_PARAMS_FLAG
, ADHOC_PARAMS_FLAG
, JAVA_CLASS_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, NEW_JAVA_CLASS_NAME
FROM AMS.AMS_CLIK_THRU_ACTIONS_B;
AMS.AMS_CLIK_THRU_ACTIONS_B does not reference any database object
AMS.AMS_CLIK_THRU_ACTIONS_B is referenced by following:
|
|
|