[Home] [Help]
View: BIC_SERVICE_REQUEST_DETAIL_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT INA.INCIDENT_ID
, INA.CUSTOMER_ID CUSTOMER_ID
, INA.ACCOUNT_ID CUST_ACCOUNT_ID
, INA.INCIDENT_NUMBER SR_NUMBER
, INA.INCIDENT_DATE CREATION_DATE
, INA.CLOSE_DATE CLOSE_DATE
, INA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL CURRENT_CONTACT_NAME
, INA.PROBLEM_CODE PROBLEM_CODE
, CLP.MEANING PROBLEM_DESCRIPTION
, INA.RESOLUTION_CODE RESOLUTION_CODE
, CLR.MEANING RESOLUTION_DESCRIPTION
FROM CS_INCIDENTS_ALL_B INA
, CS_LOOKUPS CLP
, CS_LOOKUPS CLR
WHERE INA.PROBLEM_CODE = CLP.LOOKUP_CODE (+)
AND INA.RESOLUTION_CODE = CLR.LOOKUP_CODE (+) WITH READ ONLY
Columns
Name |
INCIDENT_ID |
CUSTOMER_ID |
CUST_ACCOUNT_ID |
SR_NUMBER |
CREATION_DATE |
CLOSE_DATE |
LAST_UPDATE_DATE |
CURRENT_CONTACT_NAME |
PROBLEM_CODE |
PROBLEM_DESCRIPTION |
RESOLUTION_CODE |
RESOLUTION_DESCRIPTION |