CS Service Request Summary

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