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

TABLE: IEO.IEO_CP_STOP_LIST

Object Details
Object Name: IEO_CP_STOP_LIST
Object Type: TABLE
Owner: IEO
FND Design Data: TableIEO.IEO_CP_STOP_LIST
Subobject Name:
Status: VALID


People who should not be called


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CP_STOP_LIST_ID NUMBER (15) Yes Identifies the column that acts as the key to this table
STOP_EXPIRES_DATE DATE

Specifies the date the 'stop' expires for the customer ID
STOP_LIST_CODE VARCHAR2 (5)
The code associated with this stop list
TELEPHONE_NUMBER VARCHAR2 (24)
Telephone number of the customer
CUSTOMER_ID VARCHAR2 (20)
Customer ID
TIME_ZONE VARCHAR2 (2)
Time zone of the telephone number
CAMPAIGN VARCHAR2 (30)
Campaign name
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
CP_STOP_LIST_KEY VARCHAR2 (60) Yes Key used by CP to find this record. Typically configured either as customer ID or phone number but can be something else (e.g. a combination of both of those).
SECURITY_GROUP_ID NUMBER (15)
Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CP_STOP_LIST_ID
,      STOP_EXPIRES_DATE
,      STOP_LIST_CODE
,      TELEPHONE_NUMBER
,      CUSTOMER_ID
,      TIME_ZONE
,      CAMPAIGN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CP_STOP_LIST_KEY
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_STOP_LIST;

Dependencies

[top of page]

IEO.IEO_CP_STOP_LIST does not reference any database object

IEO.IEO_CP_STOP_LIST is referenced by following:

SchemaAPPS
SynonymIEO_CP_STOP_LIST