VIEW: APPS.CS_SYSTEM_SR_LINKS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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