VIEW: AMS.AMS_ACT_LIST_GROUPS#

Source

View Text - Preformatted

select ACT_LIST_GROUP_ID ACT_LIST_GROUP_ID, ACT_LIST_USED_BY_ID ACT_LIST_USED_BY_ID, ARC_ACT_LIST_USED_BY ARC_ACT_LIST_USED_BY, GROUP_CODE GROUP_CODE, GROUP_PRIORITY GROUP_PRIORITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS_CODE STATUS_CODE, USER_STATUS_ID USER_STATUS_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CALLING_CALENDAR_ID CALLING_CALENDAR_ID, RELEASE_CONTROL_ALG_ID RELEASE_CONTROL_ALG_ID, RELEASE_STRATEGY RELEASE_STRATEGY, RECYCLING_ALG_ID RECYCLING_ALG_ID, CALLBACK_PRIORITY_FLAG CALLBACK_PRIORITY_FLAG, CALL_CENTER_READY_FLAG CALL_CENTER_READY_FLAG, DIALING_METHOD DIALING_METHOD, QUANTUM QUANTUM, QUOTA QUOTA, QUOTA_RESET QUOTA_RESET from "AMS"."AMS_ACT_LIST_GROUPS"

View Text - HTML Formatted

SELECT ACT_LIST_GROUP_ID ACT_LIST_GROUP_ID
, ACT_LIST_USED_BY_ID ACT_LIST_USED_BY_ID
, ARC_ACT_LIST_USED_BY ARC_ACT_LIST_USED_BY
, GROUP_CODE GROUP_CODE
, GROUP_PRIORITY GROUP_PRIORITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS_CODE STATUS_CODE
, USER_STATUS_ID USER_STATUS_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CALLING_CALENDAR_ID CALLING_CALENDAR_ID
, RELEASE_CONTROL_ALG_ID RELEASE_CONTROL_ALG_ID
, RELEASE_STRATEGY RELEASE_STRATEGY
, RECYCLING_ALG_ID RECYCLING_ALG_ID
, CALLBACK_PRIORITY_FLAG CALLBACK_PRIORITY_FLAG
, CALL_CENTER_READY_FLAG CALL_CENTER_READY_FLAG
, DIALING_METHOD DIALING_METHOD
, QUANTUM QUANTUM
, QUOTA QUOTA
, QUOTA_RESET QUOTA_RESET
FROM "AMS"."AMS_ACT_LIST_GROUPS"