VIEW: IEO.IEO_CAMPAIGNS_ALL#

Source

View Text - Preformatted

select CAMPAIGN_ID CAMPAIGN_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, REF_TYPE REF_TYPE, REF_NAME REF_NAME, LIST_SRV_NAME LIST_SRV_NAME, POWER_SCORE_Y_N POWER_SCORE_Y_N, PRODUCT_SELECT_MAX PRODUCT_SELECT_MAX, POWER_GUIDE_FILE POWER_GUIDE_FILE, PBX_NAME PBX_NAME, PRIORITY_NUMBER PRIORITY_NUMBER, PROD_SELECT_MAX PROD_SELECT_MAX, QUOTE_EXPR_DAYS QUOTE_EXPR_DAYS, CATEGORY CATEGORY, CALL_PROG_DETECT CALL_PROG_DETECT, CAMPAIGN_CODE CAMPAIGN_CODE, SHORT_DESCRIPTION SHORT_DESCRIPTION, AFFINITY_Y_N AFFINITY_Y_N, PRODUCT_ORDER_Y_N PRODUCT_ORDER_Y_N, LIST_MANAGER_Y_N LIST_MANAGER_Y_N, LIST_NAME LIST_NAME, STARTUP_DATE STARTUP_DATE, SET_NUMBER SET_NUMBER, SET_STATUS SET_STATUS, SET_TYPE SET_TYPE, TRANS_SCORE_ITEM TRANS_SCORE_ITEM, USE_DIALING_Y_N USE_DIALING_Y_N, LONG_DESCRIPTION LONG_DESCRIPTION, MAX_WAIT_LS_RESP MAX_WAIT_LS_RESP, ACTIVE_Y_N ACTIVE_Y_N, PRODUCT_ID PRODUCT_ID, CPDRCT CPDRCT, CLIENT_ID CLIENT_ID, DEF_INTERNAL_LIST DEF_INTERNAL_LIST, DEF_EXTERNAL_LIST DEF_EXTERNAL_LIST, DEF_LIST_GROUP DEF_LIST_GROUP, AUTO_START_PG_Y_N AUTO_START_PG_Y_N, GROUP_TYPE GROUP_TYPE, DIALING_TYPE DIALING_TYPE, NUM_MEMBERS NUM_MEMBERS, NUM_SET_MEMBERS NUM_SET_MEMBERS, DIALING_OPTIONS DIALING_OPTIONS, CAM_CP_SERVICE_ID CAM_CP_SERVICE_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "IEO"."IEO_CAMPAIGNS_ALL"

View Text - HTML Formatted

SELECT CAMPAIGN_ID CAMPAIGN_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, REF_TYPE REF_TYPE
, REF_NAME REF_NAME
, LIST_SRV_NAME LIST_SRV_NAME
, POWER_SCORE_Y_N POWER_SCORE_Y_N
, PRODUCT_SELECT_MAX PRODUCT_SELECT_MAX
, POWER_GUIDE_FILE POWER_GUIDE_FILE
, PBX_NAME PBX_NAME
, PRIORITY_NUMBER PRIORITY_NUMBER
, PROD_SELECT_MAX PROD_SELECT_MAX
, QUOTE_EXPR_DAYS QUOTE_EXPR_DAYS
, CATEGORY CATEGORY
, CALL_PROG_DETECT CALL_PROG_DETECT
, CAMPAIGN_CODE CAMPAIGN_CODE
, SHORT_DESCRIPTION SHORT_DESCRIPTION
, AFFINITY_Y_N AFFINITY_Y_N
, PRODUCT_ORDER_Y_N PRODUCT_ORDER_Y_N
, LIST_MANAGER_Y_N LIST_MANAGER_Y_N
, LIST_NAME LIST_NAME
, STARTUP_DATE STARTUP_DATE
, SET_NUMBER SET_NUMBER
, SET_STATUS SET_STATUS
, SET_TYPE SET_TYPE
, TRANS_SCORE_ITEM TRANS_SCORE_ITEM
, USE_DIALING_Y_N USE_DIALING_Y_N
, LONG_DESCRIPTION LONG_DESCRIPTION
, MAX_WAIT_LS_RESP MAX_WAIT_LS_RESP
, ACTIVE_Y_N ACTIVE_Y_N
, PRODUCT_ID PRODUCT_ID
, CPDRCT CPDRCT
, CLIENT_ID CLIENT_ID
, DEF_INTERNAL_LIST DEF_INTERNAL_LIST
, DEF_EXTERNAL_LIST DEF_EXTERNAL_LIST
, DEF_LIST_GROUP DEF_LIST_GROUP
, AUTO_START_PG_Y_N AUTO_START_PG_Y_N
, GROUP_TYPE GROUP_TYPE
, DIALING_TYPE DIALING_TYPE
, NUM_MEMBERS NUM_MEMBERS
, NUM_SET_MEMBERS NUM_SET_MEMBERS
, DIALING_OPTIONS DIALING_OPTIONS
, CAM_CP_SERVICE_ID CAM_CP_SERVICE_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "IEO"."IEO_CAMPAIGNS_ALL"