View: CS_INCIDENT_LINKS_TO_V_SEC

Product:	CS - Service
Description:	This is a secured view on cs_incidents_links_to_v
Implementation/DBA Data:	APPS.CS_INCIDENT_LINKS_TO_V_SEC

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
, L.OBJECT_ID
, L.OBJECT_TYPE
, L.OBJECT_NUMBER
, L.SUBJECT_ID
, L.SUBJECT_TYPE
, NULL LINK_TYPE_CODE
, L.RECIPROCAL_LINK_ID
, L.LINK_TYPE_ID
, L_TYPE.NAME LINK_TYPE_NAME
, RES_DT.RESOURCE_NAME OWNER
, L.ATTRIBUTE11 ATTRIBUTE11
, L.ATTRIBUTE12 ATTRIBUTE12
, L.ATTRIBUTE13 ATTRIBUTE13
, L.ATTRIBUTE14 ATTRIBUTE14
, L.ATTRIBUTE15 ATTRIBUTE15
, L.OBJECT_VERSION_NUMBER
, JTF_EXT.NAME EXTERNAL_OBJECT
FROM CS_INCIDENTS_B_SEC INCB
, CS_INCIDENTS_ALL_TL INC
, CS_INCIDENT_LINKS L
, CS_INCIDENT_SEVERITIES_TL SEVERITY
, CS_INCIDENT_STATUSES_TL STATUS
, JTF_OBJECTS_TL JTF
, CS_SR_LINK_TYPES_TL L_TYPE
, JTF_RS_RESOURCE_EXTNS_TL RES_DT
, JTF_OBJECTS_TL JTF_EXT
WHERE INCB.INCIDENT_ID = L.OBJECT_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')
AND L_TYPE.LINK_TYPE_ID=L.LINK_TYPE_ID
AND L_TYPE.LANGUAGE = USERENV('LANG')
AND INCB.INCIDENT_OWNER_ID = RES_DT.RESOURCE_ID(+)
AND RES_DT.LANGUAGE(+) = USERENV('LANG')
AND RES_DT.CATEGORY(+) = SUBSTR(INCB.RESOURCE_TYPE
, 4
, LENGTH(INCB.RESOURCE_TYPE)-3)
AND JTF_EXT.OBJECT_CODE(+) = L.OBJECT_TYPE
AND JTF_EXT.LANGUAGE(+) = USERENV('LANG')
AND SYSDATE BETWEEN NVL(L.START_DATE_ACTIVE
, SYSDATE)
AND NVL(L.END_DATE_ACTIVE
, SYSDATE)

Columns