View: CS_INCIDENTS_WORKFLOW_V

Product:	CS - Service
Description:	Used by the Service Request Workflow
Implementation/DBA Data:	APPS.CS_INCIDENTS_WORKFLOW_V

View Text

SELECT INC.INCIDENT_ID
, INC.INCIDENT_NUMBER
, INC.SUMMARY
, EMP.SOURCE_ID INCIDENT_OWNER_ID
, INC.INVENTORY_ITEM_ID
, INC.PROBLEM_CODE
, INC.EXPECTED_RESOLUTION_DATE
, INC.INCIDENT_DATE
, INC.CUSTOMER_PRODUCT_ID
, INC.RESOLUTION_CODE
, TYPE.NAME INCIDENT_TYPE
, SEVERITY.NAME SEVERITY
, STATUS.NAME STATUS_CODE
, URGENCY.NAME URGENCY
, OWNER.RESOURCE_NAME OWNER
, RA2.PARTY_NAME CUSTOMER_NAME
, CSLKUP.MEANING PROBLEM_CODE_MEANING
, CSLKUP.DESCRIPTION PROBLEM_CODE_DESCRIPTION
, CSLKUP2.MEANING RESOLUTION_CODE_MEANING
, CSLKUP2.DESCRIPTION RESOLUTION_CODE_DESCRIPTION
, MTL.DESCRIPTION PRODUCT_DESCRIPTION
FROM CS_INCIDENTS_ALL_VL INC
, CS_INCIDENT_TYPES_VL TYPE
, CS_INCIDENT_SEVERITIES_VL SEVERITY
, CS_INCIDENT_STATUSES_VL STATUS
, CS_INCIDENT_URGENCIES_VL URGENCY
, HZ_PARTIES RA2
, CS_SR_OWNERS_V OWNER
, JTF_RS_RESOURCE_EXTNS EMP
, CS_CUSTOMER_PRODUCTS CP
, CS_LOOKUPS CSLKUP
, CS_LOOKUPS CSLKUP2
, MTL_SYSTEM_ITEMS_VL MTL
WHERE INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_OWNER_ID = OWNER.RESOURCE_ID(+)
AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID(+)
AND INC.CUSTOMER_ID = RA2.PARTY_ID(+)
AND INC.INCIDENT_SEVERITY_ID = SEVERITY.INCIDENT_SEVERITY_ID(+)
AND INC.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID(+)
AND INC.PROBLEM_CODE = CSLKUP.LOOKUP_CODE(+)
AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
AND INC.RESOLUTION_CODE = CSLKUP2.LOOKUP_CODE(+)
AND CSLKUP2.LOOKUP_TYPE (+) = 'REQUEST_RESOLUTION_CODE'
AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
AND NVL(MTL.ORGANIZATION_ID
, CS_STD.GET_ITEM_VALDN_ORGZN_ID) = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND EMP.RESOURCE_ID = OWNER.RESOURCE_ID

Columns