View: CS_SYSTEM_SR_LINKS_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.CS_SYSTEM_SR_LINKS_V

View Text

SELECT CS_SR_LINK.INCIDENT_ID
, CS_SR_LINK.SYSTEM_ID
, CS_SYSTEM.NAME
, INCVL.INCIDENT_STATUS_ID
, INCVL.INCIDENT_TYPE_ID
, INCVL.INCIDENT_URGENCY_ID
, INCVL.INCIDENT_SEVERITY_ID
, INCVL.INCIDENT_OWNER_ID
, INCVL.RESOURCE_TYPE
, INCVL.RESOURCE_SUBTYPE_ID
, INCVL.INVENTORY_ITEM_ID
, INCVL.CUSTOMER_PRODUCT_ID
, INCVL.CUSTOMER_ID
, INCVL.ACCOUNT_ID
, INCVL.PROBLEM_CODE
, INCVL.CALLER_TYPE
, INCVL.SUMMARY
, INCVL.SR_CREATION_CHANNEL
, INCVL.CP_COMPONENT_ID
, INCVL.CP_COMPONENT_VERSION_ID
, INCVL.CP_SUBCOMPONENT_ID
, INCVL.CP_SUBCOMPONENT_VERSION_ID
, INCVL.CP_REVISION_ID
, INCVL.INV_ITEM_REVISION
, INCVL.INV_COMPONENT_ID
, INCVL.INV_ORGANIZATION_ID
, INCVL.LAST_UPDATED_BY
, INCVL.CREATION_DATE
, INCVL.CREATED_BY
, INCVL.LAST_UPDATE_DATE
, INCVL.LAST_UPDATE_LOGIN
, INCVL.OBJECT_VERSION_NUMBER
, INCVL.INCIDENT_NUMBER
, INCVL.CUSTOMER_TICKET_NUMBER
FROM CS_SYSTEM_SR_LINKS CS_SR_LINK
, CS_INCIDENTS_ALL_VL INCVL
, CS_SYSTEMS_ALL_VL CS_SYSTEM
WHERE CS_SR_LINK.INCIDENT_ID = INCVL.INCIDENT_ID
AND CS_SR_LINK.SYSTEM_ID=CS_SYSTEM.SYSTEM_ID

Columns