[Home] [Help]
| Product: | BIC - Customer Intelligence (obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INC.INCIDENT_ID
, INC.INCIDENT_OWNER_ID INCIDENT_OWNER_FK
, INC.INCIDENT_STATUS_ID INCIDENT_STATUS_FK
, INC.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_FK
, INC.INCIDENT_TYPE_ID INCIDENT_TYPE_FK
, INC.INCIDENT_DATE
, INC.CLOSE_DATE
, CSA.CREATION_DATE RESPONSE_DATE
, STAT.CLOSE_FLAG
, NULL LAST_NAME
, NULL FIRST_NAME
, NULL EMPLOYEE_NAME
, PF.START_DATE_ACTIVE EMPLOYEE_START_DATE
, ISEV.NAME INCIDENT_SEVERITY
, ISEV.DESCRIPTION SEVERITY_DESC
, ITYP.NAME INCIDENT_TYPE
, ITYP.DESCRIPTION INC_TYPE_DESC
, DC.PARTY_ID
, DC.COUNTRY
, DC.CITY
, DC.STATE
, INC.ORG_ID ORG_ID
, DC.CUSTOMER_CATEGORY_FK
, DC.MARKET_SEGMENT_FK
, DT.ACT_PERIOD_NAME
, DT.START_DATE
, DT.ACT_PERIOD_START_DATE
, DT.ACT_PERIOD_END_DATE
, DT.ACT_YEAR
, DT.ACT_PERIOD_NUM
, DT.ACT_QUARTER
, DT.ACT_HALF_YEAR
, DT.ACT_YEAR_START_DATE
, DT.ACT_QUARTER_START_DATE
FROM JTF_RS_RESOURCE_EXTNS PF
, CS_INCIDENT_STATUSES STAT
, CS_INCIDENT_SEVERITIES ISEV
, CS_INCIDENT_TYPES ITYP
, CS_INCIDENT_ACTIONS CSA
, BIC_DIMV_TIME DT
, BIC_DIMV_CUSTOMERS DC
, CS_INCIDENTS_ALL_B INC
WHERE INC.INCIDENT_OWNER_ID = PF.RESOURCE_ID (+)
AND INC.INCIDENT_STATUS_ID = STAT.INCIDENT_STATUS_ID
AND INC.CUSTOMER_ID = DC.PARTY_ID
AND INC.INCIDENT_ID = CSA.INCIDENT_ID
AND CSA.CREATION_DATE BETWEEN DT.ACT_PERIOD_START_DATE
AND DT.ACT_PERIOD_END_DATE
AND INC.INCIDENT_SEVERITY_ID = ISEV.INCIDENT_SEVERITY_ID
AND INC.INCIDENT_TYPE_ID = ITYP.INCIDENT_TYPE_ID WITH READ ONLY