[Home] [Help] [Dependency Information]
Object Name: | AMS_CUSTOM_SETUPS_B |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_CUSTOM_SETUPS_B |
Subobject Name: | |
Status: | VALID |
Stores the custom setups. These custom setups are used when an actvity is created in Oracle Marketing Application.
Custom setup table stores for what type of activity the custom setup is created, that is, Rollup Campaign, Execution Campaign, Event Header, Event Offer, Fund or Message.
The attributes used is a custom setup depends upon the object its being created for and media type.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_CUSTOM_SETUPS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | CUSTOM_SETUP_ID |
AMS_CUSTOM_SETUPS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | OBJECT_TYPE |
AMS_CUSTOM_SETUPS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOM_SETUP_ID | NUMBER | Yes | Unique Identifier | |
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) | This column is used for locking purposes . | |
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Media Type Code | |
MEDIA_ID | NUMBER | Media Identifier | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | This column indicates whether the Custom Setup is enabled or disabled |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Activity type code for which custom setup is being created. |
SOURCE_CODE_SUFFIX | VARCHAR2 | (3) | Suffix for generating source code | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
APPLICATION_ID | NUMBER | Unique Identifier of the application | ||
ALLOW_ESSENTIAL_GROUPING | VARCHAR2 | (1) | Flag used for Side Menu Rendering | |
USAGE | VARCHAR2 | (30) | Lite or Classic | |
MIGRATED_CUSTOM_SETUP_ID | NUMBER | (15) | Reference to the New Custom Setup Id in R12 |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOM_SETUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ACTIVITY_TYPE_CODE
, MEDIA_ID
, ENABLED_FLAG
, OBJECT_TYPE
, SOURCE_CODE_SUFFIX
, SECURITY_GROUP_ID
, APPLICATION_ID
, ALLOW_ESSENTIAL_GROUPING
, USAGE
, MIGRATED_CUSTOM_SETUP_ID
FROM AMS.AMS_CUSTOM_SETUPS_B;
AMS.AMS_CUSTOM_SETUPS_B does not reference any database object
AMS.AMS_CUSTOM_SETUPS_B is referenced by following:
|
|
|