Skip to content

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

VIEW: AMS.AMS_ADI_CAMPAIGNS_INTERFACE#

Object Details
Object Name: AMS_ADI_CAMPAIGNS_INTERFACE#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
UPLOAD_BATCH_ID NUMBER
Yes
OPERATION_TYPE VARCHAR2 (30) Yes
OPERATION_STATUS VARCHAR2 (30) Yes
OBJECT_TYPE VARCHAR2 (30) Yes
OBJECT_ID NUMBER

OBJECT_NAME VARCHAR2 (240)
SOURCE_CODE VARCHAR2 (30)
PARENT_OBJECT_TYPE VARCHAR2 (30)
PARENT_OBJECT_ID NUMBER

ERROR_MESSAGE VARCHAR2 (4000)
UI_INSTANCE_ID NUMBER

START_DATE DATE

END_DATE DATE

START_TIME VARCHAR2 (30)
END_TIME VARCHAR2 (30)
TIME_FORMAT VARCHAR2 (30)
TEMPLATE_ID NUMBER

ACTIVITY_ID NUMBER

ACTUAL_ACTIVITY_ID NUMBER

MARKETING_MEDIUM_ID NUMBER

PURPOSE VARCHAR2 (30)
COUNTRY_ID NUMBER

OWNER_USER_ID NUMBER

TIMEZONE_ID NUMBER

CURRENCY_CODE VARCHAR2 (30)
OBJECTIVE VARCHAR2 (4000)
APPROVAL_ACTION_CODE VARCHAR2 (30)
USER_STATUS_ID NUMBER

STATUS_CODE VARCHAR2 (30)
REP_SCHED_FREQ_CODE VARCHAR2 (30)
REP_SCHED_FREQUENCY NUMBER

REP_SCHED_TG_EXCLUDE_FLAG VARCHAR2 (1)
PRODUCT_ID1 NUMBER

PRODUCT_ID2 NUMBER

PRODUCT_CATEGORY_ID1 NUMBER

PRODUCT_CATEGORY_ID2 NUMBER

COVER_LETTER_ID NUMBER

COLLAB_CITEM_ID1 NUMBER

COLLAB_CITEM_ID2 NUMBER

COLLAB_CITEM_ID3 NUMBER

COLLAB_SCRIPT_ID NUMBER

NOTES VARCHAR2 (4000)
PRETTY_URL_WEBSITE VARCHAR2 (2000)
ADDITIONAL_URL_PARAM VARCHAR2 (2000)
WP_APPLICATION_ID NUMBER

WP_PLACEMENT_ID NUMBER

WP_PLACEMENT_TITLE VARCHAR2 (1000)
WP_CITEM_ID NUMBER

CTD_ACTION NUMBER

CTD_URL_TEXT VARCHAR2 (256)
CTD_PARAM1 NUMBER

CTD_PARAM2 NUMBER

CTD_PARAM3 NUMBER

CTD_PARAM4 NUMBER

CTD_ADHOC_PARAM1 VARCHAR2 (100)
CTD_ADHOC_PARAM_VAL1 VARCHAR2 (255)
CTD_ADHOC_PARAM2 VARCHAR2 (100)
CTD_ADHOC_PARAM_VAL2 VARCHAR2 (255)
CTD_ADHOC_PARAM3 VARCHAR2 (100)
CTD_ADHOC_PARAM_VAL3 VARCHAR2 (255)
CTD_ADHOC_PARAM4 VARCHAR2 (100)
CTD_ADHOC_PARAM_VAL4 VARCHAR2 (255)
CTD_ADHOC_PARAM5 VARCHAR2 (100)
CTD_ADHOC_PARAM_VAL5 VARCHAR2 (255)
ATTRIBUTE_CATEGORY VARCHAR2 (240)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE_CATEGORY VARCHAR2 (240)
ACTIVITY_ATTRIBUTE1 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE2 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE3 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE4 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE5 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE6 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE7 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE8 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE9 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE10 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE11 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE12 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE13 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE14 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE15 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER (9)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER (15)
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# references the following:

SchemaAMS
TableAMS_ADI_CAMPAIGNS_INTERFACE
AMS.AMS_ADI_CAMPAIGNS_INTERFACE# is referenced by following:

SchemaAPPS
SynonymAMS_ADI_CAMPAIGNS_INTERFACE