[Home] [Help] [Dependency Information]
Object Name: | AMS_ADI_CAMPAIGNS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_ADI_CAMPAIGNS_INTERFACE |
Subobject Name: | |
Status: | VALID |
Interface Table that captures data for marketing objects during desktop integration upload
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_ADI_CAMPAIGNS_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPLOAD_BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UPLOAD_BATCH_ID | NUMBER | Yes | Identifier for each uploaded batch | |
OPERATION_TYPE | VARCHAR2 | (30) | Yes | Indicates type of upload operation |
OPERATION_STATUS | VARCHAR2 | (30) | Yes | Indicates whether upload operation is success or failure |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Type of marketing object |
OBJECT_ID | NUMBER | Marketing object identifier | ||
OBJECT_NAME | VARCHAR2 | (240) | Marketing Object Name | |
SOURCE_CODE | VARCHAR2 | (30) | Source code of marketing object | |
PARENT_OBJECT_TYPE | VARCHAR2 | (30) | Object type of parent | |
PARENT_OBJECT_ID | NUMBER | Identifier of parent object | ||
ERROR_MESSAGE | VARCHAR2 | (4000) | Error Message | |
UI_INSTANCE_ID | NUMBER | Identifier that references the spreadsheet | ||
START_DATE | DATE | The start date when marketing initiative starts | ||
END_DATE | DATE | The date when marketing initiative ends | ||
START_TIME | VARCHAR2 | (30) | The time when marketing initiative starts | |
END_TIME | VARCHAR2 | (30) | The time when marketing initiative ends | |
TIME_FORMAT | VARCHAR2 | (30) | The format used to enter the time | |
TEMPLATE_ID | NUMBER | Custom setup identifier | ||
ACTIVITY_ID | NUMBER | Channel identifier | ||
ACTUAL_ACTIVITY_ID | NUMBER | Activity Id | ||
MARKETING_MEDIUM_ID | NUMBER | Marketing medium identifier | ||
PURPOSE | VARCHAR2 | (30) | Purpose of the marketing initiative | |
COUNTRY_ID | NUMBER | Country identifier | ||
OWNER_USER_ID | NUMBER | Resource identifier | ||
TIMEZONE_ID | NUMBER | Timezone identifier | ||
CURRENCY_CODE | VARCHAR2 | (30) | Currency code | |
OBJECTIVE | VARCHAR2 | (4000) | Marketing objective | |
APPROVAL_ACTION_CODE | VARCHAR2 | (30) | Indicates whether this object should be submitted for approval or not | |
USER_STATUS_ID | NUMBER | User status identifier | ||
STATUS_CODE | VARCHAR2 | (30) | System Status Code | |
REP_SCHED_FREQ_CODE | VARCHAR2 | (30) | Code that identifies repeating schedule frequency | |
REP_SCHED_FREQUENCY | NUMBER | Repeating frequency of a schedule | ||
REP_SCHED_TG_EXCLUDE_FLAG | VARCHAR2 | (1) | Flag indicates whether repeating schedule should target all memebers or only new members | |
PRODUCT_ID1 | NUMBER | Inventory Item Identifier | ||
PRODUCT_ID2 | NUMBER | Inventory Item Identifier | ||
PRODUCT_CATEGORY_ID1 | NUMBER | Product category identifier | ||
PRODUCT_CATEGORY_ID2 | NUMBER | Product category identifier | ||
COVER_LETTER_ID | NUMBER | Content Item identifier for cover letter | ||
COLLAB_CITEM_ID1 | NUMBER | Collaboration Content Item identifier | ||
COLLAB_CITEM_ID2 | NUMBER | Collaboration Content Item identifier | ||
COLLAB_CITEM_ID3 | NUMBER | Collaboration Content Item identifier | ||
COLLAB_SCRIPT_ID | NUMBER | Collaboration Script identifier | ||
NOTES | VARCHAR2 | (4000) | Notes | |
PRETTY_URL_WEBSITE | VARCHAR2 | (2000) | Landing page URL | |
ADDITIONAL_URL_PARAM | VARCHAR2 | (2000) | Additional URL Parameter for Landing Page URL | |
WP_APPLICATION_ID | NUMBER | Hosting Application Identiifer where web placement runs | ||
WP_PLACEMENT_ID | NUMBER | Placement Identifier | ||
WP_PLACEMENT_TITLE | VARCHAR2 | (1000) | Placement title | |
WP_CITEM_ID | NUMBER | Content item identifier associated with web placement | ||
CTD_ACTION | NUMBER | Click Through Action identifier | ||
CTD_URL_TEXT | VARCHAR2 | (256) | Indicates URL | |
CTD_PARAM1 | NUMBER | Click Through Parameter identifier | ||
CTD_PARAM2 | NUMBER | Click Through Parameter identifier | ||
CTD_PARAM3 | NUMBER | Click Through Parameter identifier | ||
CTD_PARAM4 | NUMBER | Click Through Parameter identifier | ||
CTD_ADHOC_PARAM1 | VARCHAR2 | (100) | Web Script adhoc parameter code | |
CTD_ADHOC_PARAM_VAL1 | VARCHAR2 | (255) | Web Script adhoc parameter value | |
CTD_ADHOC_PARAM2 | VARCHAR2 | (100) | Web Script adhoc parameter code | |
CTD_ADHOC_PARAM_VAL2 | VARCHAR2 | (255) | Web Script adhoc parameter value corresponding to the code | |
CTD_ADHOC_PARAM3 | VARCHAR2 | (100) | Web Script adhoc parameter code | |
CTD_ADHOC_PARAM_VAL3 | VARCHAR2 | (255) | Web Script adhoc parameter value corresponding to the code | |
CTD_ADHOC_PARAM4 | VARCHAR2 | (100) | Web Script adhoc parameter code | |
CTD_ADHOC_PARAM_VAL4 | VARCHAR2 | (255) | Web Script adhoc parameter value corresponding to the code | |
CTD_ADHOC_PARAM5 | VARCHAR2 | (100) | Web Script adhoc parameter code | |
CTD_ADHOC_PARAM_VAL5 | VARCHAR2 | (255) | Web Script adhoc parameter value corresponding to the code | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Descriptive flexfiled structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ACTIVITY_ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Descriptive flexfiled structure defining column for Activity. | |
ACTIVITY_ATTRIBUTE1 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE2 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE3 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE4 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE5 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE6 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE7 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE8 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE9 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE10 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE11 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE12 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE13 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE14 | VARCHAR2 | (150) | Flexfield segment for activity | |
ACTIVITY_ATTRIBUTE15 | VARCHAR2 | (150) | Flexfield segment for activity | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Indicates object version number of marketing object being modified | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT UPLOAD_BATCH_ID
, OPERATION_TYPE
, OPERATION_STATUS
, OBJECT_TYPE
, OBJECT_ID
, OBJECT_NAME
, SOURCE_CODE
, PARENT_OBJECT_TYPE
, PARENT_OBJECT_ID
, ERROR_MESSAGE
, UI_INSTANCE_ID
, START_DATE
, END_DATE
, START_TIME
, END_TIME
, TIME_FORMAT
, TEMPLATE_ID
, ACTIVITY_ID
, ACTUAL_ACTIVITY_ID
, MARKETING_MEDIUM_ID
, PURPOSE
, COUNTRY_ID
, OWNER_USER_ID
, TIMEZONE_ID
, CURRENCY_CODE
, OBJECTIVE
, APPROVAL_ACTION_CODE
, USER_STATUS_ID
, STATUS_CODE
, REP_SCHED_FREQ_CODE
, REP_SCHED_FREQUENCY
, REP_SCHED_TG_EXCLUDE_FLAG
, PRODUCT_ID1
, PRODUCT_ID2
, PRODUCT_CATEGORY_ID1
, PRODUCT_CATEGORY_ID2
, COVER_LETTER_ID
, COLLAB_CITEM_ID1
, COLLAB_CITEM_ID2
, COLLAB_CITEM_ID3
, COLLAB_SCRIPT_ID
, NOTES
, PRETTY_URL_WEBSITE
, ADDITIONAL_URL_PARAM
, WP_APPLICATION_ID
, WP_PLACEMENT_ID
, WP_PLACEMENT_TITLE
, WP_CITEM_ID
, CTD_ACTION
, CTD_URL_TEXT
, CTD_PARAM1
, CTD_PARAM2
, CTD_PARAM3
, CTD_PARAM4
, CTD_ADHOC_PARAM1
, CTD_ADHOC_PARAM_VAL1
, CTD_ADHOC_PARAM2
, CTD_ADHOC_PARAM_VAL2
, CTD_ADHOC_PARAM3
, CTD_ADHOC_PARAM_VAL3
, CTD_ADHOC_PARAM4
, CTD_ADHOC_PARAM_VAL4
, CTD_ADHOC_PARAM5
, CTD_ADHOC_PARAM_VAL5
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ACTIVITY_ATTRIBUTE_CATEGORY
, ACTIVITY_ATTRIBUTE1
, ACTIVITY_ATTRIBUTE2
, ACTIVITY_ATTRIBUTE3
, ACTIVITY_ATTRIBUTE4
, ACTIVITY_ATTRIBUTE5
, ACTIVITY_ATTRIBUTE6
, ACTIVITY_ATTRIBUTE7
, ACTIVITY_ATTRIBUTE8
, ACTIVITY_ATTRIBUTE9
, ACTIVITY_ATTRIBUTE10
, ACTIVITY_ATTRIBUTE11
, ACTIVITY_ATTRIBUTE12
, ACTIVITY_ATTRIBUTE13
, ACTIVITY_ATTRIBUTE14
, ACTIVITY_ATTRIBUTE15
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM AMS.AMS_ADI_CAMPAIGNS_INTERFACE;
AMS.AMS_ADI_CAMPAIGNS_INTERFACE does not reference any database object
AMS.AMS_ADI_CAMPAIGNS_INTERFACE is referenced by following:
|
|
|