VIEW: IEO.IEO_CP_SVC_LISTS_ALL#

Source

View Text - Preformatted

select CP_SVC_LIST_ID CP_SVC_LIST_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, LIST_NAME LIST_NAME, LIST_SRV_NAME LIST_SRV_NAME, SREF_TYPE SREF_TYPE, CALENDAR_FILE CALENDAR_FILE, CAL_ALG_TYPE CAL_ALG_TYPE, ORG_ID ORG_ID, LIST_RELEASE_STR LIST_RELEASE_STR, QUEUE_FIRST_ENTRY QUEUE_FIRST_ENTRY, QUEUE_LAST_ENTRY QUEUE_LAST_ENTRY, QUEUE_SCORE QUEUE_SCORE, QUEUE_SCORE_CNT QUEUE_SCORE_CNT, QUEUE_CODE QUEUE_CODE, QUEUE_PRIORITY QUEUE_PRIORITY, QUEUE_STATUS QUEUE_STATUS, QUEUE_TYPE QUEUE_TYPE, RELEASE_STRATEGY RELEASE_STRATEGY, RELEASE_ARRAY_CNT RELEASE_ARRAY_CNT, RELEASE_STOP_FLAG RELEASE_STOP_FLAG, REMAIN_QUOTA REMAIN_QUOTA, RANDOMIZE_FLAG RANDOMIZE_FLAG, RECYCLE_METHOD RECYCLE_METHOD, SHORT_DESCRIPTION SHORT_DESCRIPTION, SORT_KEY SORT_KEY, CREATE_DT_TM CREATE_DT_TM, CALL_TYPE_CODE CALL_TYPE_CODE, CTRL_LENGTH CTRL_LENGTH, DIALING_METHOD DIALING_METHOD, STOP_DT_TM STOP_DT_TM, SELECTION_CRITERIA SELECTION_CRITERIA, SORT_ORDER_MAP SORT_ORDER_MAP, SELECTION_PRIORITY SELECTION_PRIORITY, SCORE_RESET SCORE_RESET, SORT_FIELD SORT_FIELD, SELECT_STRING_LEN SELECT_STRING_LEN, TOTAL_RECORDS TOTAL_RECORDS, NUM_SORT_KEYS NUM_SORT_KEYS, ORIGIN_OF_LIST ORIGIN_OF_LIST, VIEW_LIST_Y_N VIEW_LIST_Y_N, AUTO_REFRESH AUTO_REFRESH, LONG_DESCRIPTION LONG_DESCRIPTION, LIST_SORT_ORDER LIST_SORT_ORDER, PRD_EXHAUST PRD_EXHAUST, QUANTUM QUANTUM, QUOTA QUOTA, QUOTA_RESET QUOTA_RESET, DEFLT_RECYCLE_LIST DEFLT_RECYCLE_LIST, TIMESTAMP_FLAG TIMESTAMP_FLAG, DIALING_TYPE DIALING_TYPE, DT_PRD_EXHAUST DT_PRD_EXHAUST, DIALING_OPTIONS DIALING_OPTIONS, EXHAUST_AVAIL_FLAG EXHAUST_AVAIL_FLAG, LIST_SELECT_STR LIST_SELECT_STR, LIST_MGR_LIST_Y_N LIST_MGR_LIST_Y_N, LIST_STATUS LIST_STATUS, LIST_TYPE LIST_TYPE, INDEX_SLOTS INDEX_SLOTS, TIMESTAMP_ACTUAL TIMESTAMP_ACTUAL, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "IEO"."IEO_CP_SVC_LISTS_ALL"

View Text - HTML Formatted

SELECT CP_SVC_LIST_ID CP_SVC_LIST_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
, LIST_NAME LIST_NAME
, LIST_SRV_NAME LIST_SRV_NAME
, SREF_TYPE SREF_TYPE
, CALENDAR_FILE CALENDAR_FILE
, CAL_ALG_TYPE CAL_ALG_TYPE
, ORG_ID ORG_ID
, LIST_RELEASE_STR LIST_RELEASE_STR
, QUEUE_FIRST_ENTRY QUEUE_FIRST_ENTRY
, QUEUE_LAST_ENTRY QUEUE_LAST_ENTRY
, QUEUE_SCORE QUEUE_SCORE
, QUEUE_SCORE_CNT QUEUE_SCORE_CNT
, QUEUE_CODE QUEUE_CODE
, QUEUE_PRIORITY QUEUE_PRIORITY
, QUEUE_STATUS QUEUE_STATUS
, QUEUE_TYPE QUEUE_TYPE
, RELEASE_STRATEGY RELEASE_STRATEGY
, RELEASE_ARRAY_CNT RELEASE_ARRAY_CNT
, RELEASE_STOP_FLAG RELEASE_STOP_FLAG
, REMAIN_QUOTA REMAIN_QUOTA
, RANDOMIZE_FLAG RANDOMIZE_FLAG
, RECYCLE_METHOD RECYCLE_METHOD
, SHORT_DESCRIPTION SHORT_DESCRIPTION
, SORT_KEY SORT_KEY
, CREATE_DT_TM CREATE_DT_TM
, CALL_TYPE_CODE CALL_TYPE_CODE
, CTRL_LENGTH CTRL_LENGTH
, DIALING_METHOD DIALING_METHOD
, STOP_DT_TM STOP_DT_TM
, SELECTION_CRITERIA SELECTION_CRITERIA
, SORT_ORDER_MAP SORT_ORDER_MAP
, SELECTION_PRIORITY SELECTION_PRIORITY
, SCORE_RESET SCORE_RESET
, SORT_FIELD SORT_FIELD
, SELECT_STRING_LEN SELECT_STRING_LEN
, TOTAL_RECORDS TOTAL_RECORDS
, NUM_SORT_KEYS NUM_SORT_KEYS
, ORIGIN_OF_LIST ORIGIN_OF_LIST
, VIEW_LIST_Y_N VIEW_LIST_Y_N
, AUTO_REFRESH AUTO_REFRESH
, LONG_DESCRIPTION LONG_DESCRIPTION
, LIST_SORT_ORDER LIST_SORT_ORDER
, PRD_EXHAUST PRD_EXHAUST
, QUANTUM QUANTUM
, QUOTA QUOTA
, QUOTA_RESET QUOTA_RESET
, DEFLT_RECYCLE_LIST DEFLT_RECYCLE_LIST
, TIMESTAMP_FLAG TIMESTAMP_FLAG
, DIALING_TYPE DIALING_TYPE
, DT_PRD_EXHAUST DT_PRD_EXHAUST
, DIALING_OPTIONS DIALING_OPTIONS
, EXHAUST_AVAIL_FLAG EXHAUST_AVAIL_FLAG
, LIST_SELECT_STR LIST_SELECT_STR
, LIST_MGR_LIST_Y_N LIST_MGR_LIST_Y_N
, LIST_STATUS LIST_STATUS
, LIST_TYPE LIST_TYPE
, INDEX_SLOTS INDEX_SLOTS
, TIMESTAMP_ACTUAL TIMESTAMP_ACTUAL
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "IEO"."IEO_CP_SVC_LISTS_ALL"