VIEW: APPS.CS_INCIDENT_LINKS_FROM_V

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.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')

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.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')