CS Service Request Summary

Description
Categories: BI Publisher
Application: Service
Source: Service Request Summary Report (XML)
Short Name: CSXSRSUM_XML
DB package: CS_CSXSRSUM_XMLP_PKG
Run CS Service Request Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT      CV.INCIDENT_NUMBER,
	CV.INCIDENT_DATE,
	CV.PROBLEM_CODE,
	CV.RESOLUTION_CODE,
	CV.INCIDENT_TYPE,
	CV.SEVERITY,
	CV.STATUS_CODE,
	CV.URGENCY,
	CV.OWNER,
	CV.CUSTOMER_NUMBER,
	CV.COMPANY_NAME CUSTOMER_NAME,
	NVL(CV.CURRENT_SERIAL_NUMBER, CII.SERIAL_NUMBER) CURRENT_SERIAL_NUMBER, 
	CV.REFERENCE_NUMBER,
                   CV.PRODUCT_NAME,
                   CV.SUMMARY
FROM     CS_SR_REPORT_V CV,
         MTL_SYSTEM_ITEMS_VL MSI,
  CSI_ITEM_INSTANCES cii
WHERE  
 CV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND     CV.inventory_item_id    =    cii.inventory_item_id(+) 	
AND     cii.instance_id(+)          =   CV.customer_product_id	
AND    MSI.organization_id(+)  = to_number(fnd_profile.value_specific('SO_ORGANIZATION_ID')) 
     &LP_CUSTOMER_NUMBER
     &LP_REQUEST_NUMBER
     &LP_CLOSEDDATE
     &LP_CLOSED_FLAG
     &LP_LOGGEDBY
     &LP_OWNER
     &LP_PROBLEM_CODE
     &LP_RESOLUTION_CODE
     &LP_SEVERITY
     &LP_STATUS
     &LP_TYPE
     &LP_URGENCY
    AND  &P_ITEM_WHERE
ORDER BY CV.CUSTOMER_NUMBER , CV.INCIDENT_NUMBER
Parameter Name SQL text Validation
From Customer Number
 
LOV Oracle
To Customer Number
 
LOV Oracle
From Item
 
Char
To Item
 
Char
From Request Number
 
LOV Oracle
To Request Number
 
LOV Oracle
Type
 
LOV Oracle
Severity
 
LOV Oracle
Urgency
 
LOV Oracle
Problem Code
 
LOV Oracle
Resolution Code
 
LOV Oracle
Status
 
LOV Oracle
Owner
 
LOV Oracle
Closed Date
 
Date
Logged By
 
LOV Oracle
Closed Flag
 
LOV Oracle
Install Location
 
LOV Oracle