VIEW: APPS.CS_INCIDENTS_WORKFLOW_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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