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

TABLE: AMS.AMS_ADI_CAMPAIGNS_INTERFACE

Object Details
Object Name: AMS_ADI_CAMPAIGNS_INTERFACE
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_ADI_CAMPAIGNS_INTERFACE
Subobject Name:
Status: VALID


Interface Table that captures data for marketing objects during desktop integration upload


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_ADI_CAMPAIGNS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPLOAD_BATCH_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

AMS.AMS_ADI_CAMPAIGNS_INTERFACE does not reference any database object

AMS.AMS_ADI_CAMPAIGNS_INTERFACE is referenced by following:

SchemaAMS
ViewAMS_ADI_CAMPAIGNS_INTERFACE#