VIEW: APPS.CS_SR_LINKS_EXT_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)