CS Service Request Summary

Description
Categories: BI Publisher, Service
Application: Service
Source: Service Request Summary Report (XML)
Short Name: CSXSRSUM_XML
DB package: CS_CSXSRSUM_XMLP_PKG
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
Install Location
 
LOV Oracle
Closed Flag
 
LOV Oracle
Logged By
 
LOV Oracle
Closed Date
 
Date
Owner
 
LOV Oracle
Status
 
LOV Oracle
Resolution Code
 
LOV Oracle
Problem Code
 
LOV Oracle
Urgency
 
LOV Oracle
Severity
 
LOV Oracle
Type
 
LOV Oracle
To Request Number
 
LOV Oracle
From Request Number
 
LOV Oracle
To Item
 
From Item
 
To Customer Number
 
LOV Oracle
From Customer Number
 
LOV Oracle