[Home] [Help]
| Product: | XNS - Service for Communications (Obsolete) |
|---|---|
| Description: | Related service requests information |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CS.ROWID ROW_ID
, CS.LAST_UPDATE_DATE
, CS.LAST_UPDATED_BY
, CS.CREATION_DATE
, CS.CREATED_BY
, CS.LAST_UPDATE_LOGIN
, CS.FROM_INCIDENT_ID
, CS.TO_INCIDENT_ID
, CS.LINK_TYPE
, CP.SYSTEM_ID
, SYS.NAME SYSTEM_NAME
, INC.INCIDENT_STATUS_ID
, STATUS.NAME STATUS_NAME
, INC.CURRENT_SERIAL_NUMBER
, INC.INCIDENT_TYPE_ID
, TYPE.NAME INCIDENT_TYPE_NAME
, CS.LINK_ID
FROM CS_INCIDENT_LINKS CS
, CS_INCIDENTS_ALL_B INC
, CS_SYSTEMS SYS
, CS_INCIDENT_TYPES_VL TYPE
, CS_INCIDENT_STATUSES_VL STATUS
, CS_CUSTOMER_PRODUCTS CP
WHERE CS.LINK_TYPE IN ('CHILD'
, 'PARENT')
AND INC.INCIDENT_ID = CS.TO_INCIDENT_ID
AND CP.SYSTEM_ID = SYS.SYSTEM_ID (+)
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND INC.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID (+) UNION SELECT CS.ROWID ROW_ID
, CS.LAST_UPDATE_DATE
, CS.LAST_UPDATED_BY
, CS.CREATION_DATE
, CS.CREATED_BY
, CS.LAST_UPDATE_LOGIN
, CS.TO_INCIDENT_ID
, CS.FROM_INCIDENT_ID
, DECODE(CS.LINK_TYPE
, 'PARENT'
, 'CHILD'
, 'CHILD'
, 'PARENT')
, CP.SYSTEM_ID
, SYS.NAME SYSTEM_NAME
, INC.INCIDENT_STATUS_ID
, STATUS.NAME STATUS_NAME
, INC.CURRENT_SERIAL_NUMBER
, INC.INCIDENT_TYPE_ID
, TYPE.NAME INCIDENT_TYPE_NAME
, LINK_ID
FROM CS_INCIDENT_LINKS CS
, CS_INCIDENTS_ALL_B INC
, CS_SYSTEMS SYS
, CS_INCIDENT_TYPES_VL TYPE
, CS_INCIDENT_STATUSES_VL STATUS
, CS_CUSTOMER_PRODUCTS CP
WHERE CS.LINK_TYPE IN ('CHILD'
, 'PARENT')
AND INC.INCIDENT_ID = FROM_INCIDENT_ID
AND CP.SYSTEM_ID = SYS.SYSTEM_ID (+)
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND INC.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID (+)