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

TABLE: IEO.IEO_LIST_CAMP_XRS_ALL

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


List and Campaign cross reference table


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LIST_CAMP_XR_ID NUMBER (15) Yes Primary key column
LIST_SRV_NAME VARCHAR2 (30) Yes List service in which this list is defined
SREF_TYPE VARCHAR2 (5) Yes "S"
LIST_NAME VARCHAR2 (30) Yes List name
REF_NAME VARCHAR2 (30) Yes Campaign name
REF_TYPE VARCHAR2 (5) Yes 'C' for campaigns and 'G' for list groups
LIST_TYPE VARCHAR2 (30)
Obsolete
MEMBER_TYPE VARCHAR2 (1)
Obsolete
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
ORG_ID NUMBER (15) Yes Multi-org support
IL_CAMPAIGN_ID NUMBER (10)
Unused
IL_CP_SVC_LIST_ID NUMBER

Unused
IL_CP_SVC_LIST_ID2 NUMBER

Unused
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 LIST_CAMP_XR_ID
,      LIST_SRV_NAME
,      SREF_TYPE
,      LIST_NAME
,      REF_NAME
,      REF_TYPE
,      LIST_TYPE
,      MEMBER_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      IL_CAMPAIGN_ID
,      IL_CP_SVC_LIST_ID
,      IL_CP_SVC_LIST_ID2
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_LIST_CAMP_XRS_ALL;

Dependencies

[top of page]

IEO.IEO_LIST_CAMP_XRS_ALL does not reference any database object

IEO.IEO_LIST_CAMP_XRS_ALL is referenced by following:

SchemaIEO
ViewIEO_LIST_CAMP_XRS_ALL#