[Home] [Help] [Dependency Information]
Object Name: | IEO_SYSTEM_CAMPS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IEO |
FND Design Data: | IEO.IEO_SYSTEM_CAMPS_ALL |
Subobject Name: | |
Status: | VALID |
ISSUE
=====
All Campaign tables will have to replaced by marketing campaign tables
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_CAMP_ID | NUMBER | Yes | Primary key column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LIST_SRV_NAME | VARCHAR2 | (30) | Yes | List service name |
SREF_TYPE | VARCHAR2 | (5) | Yes | "S" |
ORG_ID | NUMBER | (15) | Yes | Multi org support column |
PHYSICAL_DB | VARCHAR2 | (20) | ODBC DSN for campaign database | |
ODBC_DSN_NAME | VARCHAR2 | (60) | Not used | |
REF_TYPE | VARCHAR2 | (5) | "G" = list group, "C" = campaign | |
REF_NAME | VARCHAR2 | (30) | Campaign name | |
SHORT_DESCRIPTION | VARCHAR2 | (30) | Description of this campaign | |
PRDTY_SRV_NAME | VARCHAR2 | (30) | Not used | |
LIST_MANAGER_Y_N | VARCHAR2 | (5) | "Y" if this campaign is to be serviced by Campaign Plus | |
ACTIVE_Y_N | VARCHAR2 | (5) | Indicates whether the campaign is active or not | |
PRIORITY_NUMBER | VARCHAR2 | (9) | Not used | |
VERSA_ENABLED_Y_N | VARCHAR2 | (5) | "Y" if this campaign is known to VTT/OTB | |
PRED_ABDN_LIMIT | VARCHAR2 | (30) | Not used | |
VERSION | VARCHAR2 | (20) | Not used | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
Cut, paste (and edit) the following text to query this object:
SELECT SYSTEM_CAMP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_SRV_NAME
, SREF_TYPE
, ORG_ID
, PHYSICAL_DB
, ODBC_DSN_NAME
, REF_TYPE
, REF_NAME
, SHORT_DESCRIPTION
, PRDTY_SRV_NAME
, LIST_MANAGER_Y_N
, ACTIVE_Y_N
, PRIORITY_NUMBER
, VERSA_ENABLED_Y_N
, PRED_ABDN_LIMIT
, VERSION
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_SYSTEM_CAMPS_ALL;
IEO.IEO_SYSTEM_CAMPS_ALL does not reference any database object
IEO.IEO_SYSTEM_CAMPS_ALL is referenced by following:
|
|
|