VIEW: CS.CS_GROUP_LEVEL_ASSIGNS#

Source

View Text - Preformatted

select ASSIGNMENT_ID ASSIGNMENT_ID, SERVICE_GROUP_ID SERVICE_GROUP_ID, SUPPORT_LEVEL_ID SUPPORT_LEVEL_ID, ROLE_PERSON_ID ROLE_PERSON_ID, 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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CUSTOMER_ID CUSTOMER_ID, SR_TYPE_ID SR_TYPE_ID, SR_SEVERITY_ID SR_SEVERITY_ID, SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE, SYSTEM_ID SYSTEM_ID, CP_TYPE_CODE CP_TYPE_CODE, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, PROBLEM_CODE PROBLEM_CODE, INSTALL_CITY INSTALL_CITY, INSTALL_COUNTY INSTALL_COUNTY, INSTALL_STATE INSTALL_STATE, INSTALL_POSTAL_CODE INSTALL_POSTAL_CODE, INSTALL_COUNTRY INSTALL_COUNTRY, INSTALL_PROVINCE INSTALL_PROVINCE, ADDRESS_ID ADDRESS_ID, SITE_USE_ID SITE_USE_ID, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ROLE_PERSON_ORIG_SYSTEM ROLE_PERSON_ORIG_SYSTEM, ROLE_PERSON_NAME ROLE_PERSON_NAME, ROLE_PERSON_DISPLAY_NAME ROLE_PERSON_DISPLAY_NAME from "CS"."CS_GROUP_LEVEL_ASSIGNS"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, SERVICE_GROUP_ID SERVICE_GROUP_ID
, SUPPORT_LEVEL_ID SUPPORT_LEVEL_ID
, ROLE_PERSON_ID ROLE_PERSON_ID
, 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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CUSTOMER_ID CUSTOMER_ID
, SR_TYPE_ID SR_TYPE_ID
, SR_SEVERITY_ID SR_SEVERITY_ID
, SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE
, SYSTEM_ID SYSTEM_ID
, CP_TYPE_CODE CP_TYPE_CODE
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, PROBLEM_CODE PROBLEM_CODE
, INSTALL_CITY INSTALL_CITY
, INSTALL_COUNTY INSTALL_COUNTY
, INSTALL_STATE INSTALL_STATE
, INSTALL_POSTAL_CODE INSTALL_POSTAL_CODE
, INSTALL_COUNTRY INSTALL_COUNTRY
, INSTALL_PROVINCE INSTALL_PROVINCE
, ADDRESS_ID ADDRESS_ID
, SITE_USE_ID SITE_USE_ID
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ROLE_PERSON_ORIG_SYSTEM ROLE_PERSON_ORIG_SYSTEM
, ROLE_PERSON_NAME ROLE_PERSON_NAME
, ROLE_PERSON_DISPLAY_NAME ROLE_PERSON_DISPLAY_NAME
FROM "CS"."CS_GROUP_LEVEL_ASSIGNS"