[Home] [Help]
View: BIC_SERVICE_REQUEST_SUMMARY_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT P.ACCOUNT_NUMBER
, INA.INCIDENT_ID REQUEST_ID
, INA.CUSTOMER_ID CUSTOMER_ID
, INA.ACCOUNT_ID CUST_ACCOUNT_ID
, INA.INCIDENT_NUMBER REQUEST_NUMBER
, INA.SUMMARY DESCRIPTION
, INSV.NAME SEVERITY
, INST.NAME STATUS
, INA.INCIDENT_DATE CREATION_DATE
, INA.CLOSE_DATE CLOSE_DATE
, INA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INA.INVENTORY_ITEM_ID PRODUCT
, INA.SR_CREATION_CHANNEL
, T.ACTUAL_START_DATE ESCALATION_DATE
FROM JTF_TASK_REFERENCES_B R
, CS_INCIDENT_SEVERITIES INSV
, CS_INCIDENT_STATUSES INST
, CS_INCIDENTS_ALL_VL INA
, BIC_PARTIES_V P
, JTF_TASKS_B T
WHERE INA.ACCOUNT_ID = P.CUST_ACCOUNT_ID(+)
AND INA.INCIDENT_SEVERITY_ID = INSV.INCIDENT_SEVERITY_ID
AND INSV.INCIDENT_SUBTYPE ='INC'
AND INA.INCIDENT_STATUS_ID = INST.INCIDENT_STATUS_ID
AND INST.INCIDENT_SUBTYPE = 'INC'
AND INA.INCIDENT_ID = R.OBJECT_ID (+)
AND R.OBJECT_TYPE_CODE(+) = 'SR'
AND R.REFERENCE_CODE(+) = 'ESC'
AND R.TASK_ID = T.TASK_ID(+)
AND T.TASK_TYPE_ID (+) = 22 WITH READ ONLY
Columns
Name |
ACCOUNT_NUMBER |
REQUEST_ID |
CUSTOMER_ID |
CUST_ACCOUNT_ID |
REQUEST_NUMBER |
DESCRIPTION |
SEVERITY |
STATUS |
CREATION_DATE |
CLOSE_DATE |
LAST_UPDATE_DATE |
PRODUCT |
SR_CREATION_CHANNEL |
ESCALATION_DATE |