[Home] [Help]
View: 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
| INCIDENT_ID |
| SYSTEM_ID |
| NAME |
| INCIDENT_STATUS_ID |
| INCIDENT_TYPE_ID |
| INCIDENT_URGENCY_ID |
| INCIDENT_SEVERITY_ID |
| INCIDENT_OWNER_ID |
| RESOURCE_TYPE |
| RESOURCE_SUBTYPE_ID |
| INVENTORY_ITEM_ID |
| CUSTOMER_PRODUCT_ID |
| CUSTOMER_ID |
| ACCOUNT_ID |
| PROBLEM_CODE |
| CALLER_TYPE |
| SUMMARY |
| SR_CREATION_CHANNEL |
| CP_COMPONENT_ID |
| CP_COMPONENT_VERSION_ID |
| CP_SUBCOMPONENT_ID |
| CP_SUBCOMPONENT_VERSION_ID |
| CP_REVISION_ID |
| INV_ITEM_REVISION |
| INV_COMPONENT_ID |
| INV_ORGANIZATION_ID |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| OBJECT_VERSION_NUMBER |
| INCIDENT_NUMBER |
| CUSTOMER_TICKET_NUMBER |
| Name |
APPS.CS_SYSTEM_SR_LINKS_V