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

VIEW: IEC.IEC_G_REP_CAMPAIGN_REC_DETAIL#

Object Details
Object Name: IEC_G_REP_CAMPAIGN_REC_DETAIL#
Object Type: VIEW
Owner: IEC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_REC_DETAIL_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CAMPAIGN_SCHEDULE_ID NUMBER (15) Yes
LIST_HEADER_ID NUMBER (15) Yes
LIST_SUBSET_ID NUMBER (15) Yes
RECORD_TYPE NUMBER (1) Yes
DIALING_METHOD VARCHAR2 (30)
RECORD_LOADED NUMBER (9)
RECORD_CALLED NUMBER (9)
RECORD_REMOVED NUMBER (9)
RECORD_REMAINING NUMBER (9)
RECORD_UNAVAILABLE NUMBER (9)
RECORD_AVAILABLE NUMBER (9)
PRED_EXHAUST DATE

QUOTA_CURRENT NUMBER (9)
QUOTA_OBJ NUMBER (9)
RECORD_CALLED_AND_REMOVED NUMBER (9)
RECORD_CALLED_AND_REMOVED_COPY NUMBER (9)
LAST_COPY_TIME DATE

OBJECT_VERSION_NUMBER NUMBER (9)
SECURITY_GROUP_ID NUMBER (15)
Query Text

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


SELECT CAMPAIGN_REC_DETAIL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CAMPAIGN_SCHEDULE_ID
,      LIST_HEADER_ID
,      LIST_SUBSET_ID
,      RECORD_TYPE
,      DIALING_METHOD
,      RECORD_LOADED
,      RECORD_CALLED
,      RECORD_REMOVED
,      RECORD_REMAINING
,      RECORD_UNAVAILABLE
,      RECORD_AVAILABLE
,      PRED_EXHAUST
,      QUOTA_CURRENT
,      QUOTA_OBJ
,      RECORD_CALLED_AND_REMOVED
,      RECORD_CALLED_AND_REMOVED_COPY
,      LAST_COPY_TIME
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM IEC.IEC_G_REP_CAMPAIGN_REC_DETAIL#;

Dependencies

[top of page]

IEC.IEC_G_REP_CAMPAIGN_REC_DETAIL# references the following:

SchemaIEC
TableIEC_G_REP_CAMPAIGN_REC_DETAILS
IEC.IEC_G_REP_CAMPAIGN_REC_DETAIL# is referenced by following:

SchemaAPPS
SynonymIEC_G_REP_CAMPAIGN_REC_DETAILS