View: CS_INCIDENT_LINKS_FROM_V

Product:	CS - Service
Description:	Show all Service Requests that are linked from another service request to this Service request.
Implementation/DBA Data:	APPS.CS_INCIDENT_LINKS_FROM_V

View Text

SELECT L.ROWID ROW_ID
, L.LINK_ID LINK_ID
, L.FROM_INCIDENT_ID FROM_INCIDENT_ID
, L.TO_INCIDENT_ID TO_INCIDENT_ID
, JTF.NAME DOC_TYPE
, L.LINK_TYPE LINK_TYPE
, L.LAST_UPDATE_DATE LAST_UPDATE_DATE
, L.LAST_UPDATED_BY LAST_UPDATED_BY
, L.CREATION_DATE CREATION_DATE
, L.CREATED_BY CREATED_BY
, L.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, L.ATTRIBUTE1 ATTRIBUTE1
, L.ATTRIBUTE2 ATTRIBUTE2
, L.ATTRIBUTE3 ATTRIBUTE3
, L.ATTRIBUTE4 ATTRIBUTE4
, L.ATTRIBUTE5 ATTRIBUTE5
, L.ATTRIBUTE6 ATTRIBUTE6
, L.ATTRIBUTE7 ATTRIBUTE7
, L.ATTRIBUTE8 ATTRIBUTE8
, L.ATTRIBUTE9 ATTRIBUTE9
, L.ATTRIBUTE10 ATTRIBUTE10
, L.CONTEXT CONTEXT
, INCB.INCIDENT_NUMBER DOC_NUMBER
, INC.SUMMARY SUMMARY
, NULL PRODUCT_NUMBER
, NULL PRODUCT_DESCRIPTION
, SEVERITY.NAME SEVERITY
, STATUS.NAME STATUS
, 'SR' DOC_CODE
, INCB.INVENTORY_ITEM_ID PRODUCT_ID
FROM CS_INCIDENTS_ALL_B INCB
, CS_INCIDENTS_ALL_TL INC
, CS_INCIDENT_LINKS L
, CS_INCIDENT_SEVERITIES_TL SEVERITY
, CS_INCIDENT_STATUSES_TL STATUS
, JTF_OBJECTS_TL JTF
WHERE INCB.INCIDENT_ID = L.FROM_INCIDENT_ID
AND INC.INCIDENT_ID = INCB.INCIDENT_ID
AND INC.LANGUAGE = USERENV('LANG')
AND JTF.OBJECT_CODE = 'SR'
AND JTF.LANGUAGE = USERENV('LANG')
AND INCB.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND STATUS.LANGUAGE = USERENV('LANG')
AND INCB.INCIDENT_SEVERITY_ID = SEVERITY.INCIDENT_SEVERITY_ID
AND SEVERITY.LANGUAGE = USERENV('LANG')

Columns