Product: | CS - Service |
---|---|
Description: | This view lists all the external links for a service request. |
Implementation/DBA Data: | APPS.CS_SR_LINKS_EXT_V |
SELECT L.ROWID ROW_ID
, L.LINK_ID LINK_ID
, L.OBJECT_ID
, L.OBJECT_TYPE EXTERNAL_OBJECT_CODE
, L.OBJECT_NUMBER DOC_NUMBER
, L.SUBJECT_ID
, L.SUBJECT_TYPE
, L.LINK_TYPE_ID
, L_TYPE.NAME LINK_TYPE_NAME
, L.OBJECT_VERSION_NUMBER
, JTF_EXT.NAME EXTERNAL_OBJECT
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.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.ATTRIBUTE11 ATTRIBUTE11
, L.ATTRIBUTE12 ATTRIBUTE12
, L.ATTRIBUTE13 ATTRIBUTE13
, L.ATTRIBUTE14 ATTRIBUTE14
, L.ATTRIBUTE15 ATTRIBUTE15
, L.CONTEXT CONTEXT
, L.RECIPROCAL_LINK_ID
FROM CS_INCIDENT_LINKS L
, CS_SR_LINK_TYPES_TL L_TYPE
, JTF_OBJECTS_TL JTF_EXT
WHERE OBJECT_TYPE != 'SR'
AND L_TYPE.LINK_TYPE_ID=L.LINK_TYPE_ID
AND L_TYPE.LANGUAGE = USERENV('LANG')
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)