VIEW: APPS.CS_INCIDENT_LINKS_TO_V_SEC

Source

View Text - Preformatted

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.ATTRIBUTE_CONTEXT ATTRIBUTE_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)

View Text - HTML Formatted

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.ATTRIBUTE_CONTEXT ATTRIBUTE_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)