eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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