[Home] [Help]
View: IEU_UWQ_SERV_REQ_V
Product: | IEU - Universal Work Queue |
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT O.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, O.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'INCIDENT_ID' IEU_PARAM_PK_COL
, TO_CHAR(A.INCIDENT_ID) IEU_PARAM_PK_VALUE
, A.INCIDENT_NUMBER
, A.SEVERITY
, A.SERVERITY
, A.STATUS
, A.SUMMARY
, A.PERSON_ORG
, A.RESOURCE_ID
, A.RESOURCE_TYPE
, A.OWNER
, A.SR_TYPE
, A.ESCALATED
, A.COVERAGE_NAME
, A.COVERAGE_LEVEL
, A.INCIDENT_SEVERITY_ID
, A.INCIDENT_STATUS_ID
, A.INCIDENT_TYPE_ID
FROM CS_SR_UWQ_V A
, JTF_OBJECTS_VL O
WHERE O.OBJECT_CODE = 'SR'
Columns
Name |
IEU_OBJECT_FUNCTION |
IEU_OBJECT_PARAMETERS |
IEU_MEDIA_TYPE_UUID |
IEU_PARAM_PK_COL |
IEU_PARAM_PK_VALUE |
INCIDENT_NUMBER |
SEVERITY |
SERVERITY |
STATUS |
SUMMARY |
PERSON_ORG |
RESOURCE_ID |
RESOURCE_TYPE |
OWNER |
SR_TYPE |
ESCALATED |
COVERAGE_NAME |
COVERAGE_LEVEL |
INCIDENT_SEVERITY_ID |
INCIDENT_STATUS_ID |
INCIDENT_TYPE_ID |