CS Service Request Detail

Description
Categories: BI Publisher
Application: Service
Source: Service Request Detail Report (XML)
Short Name: CSXSRDET_XML
DB package: CS_CSXSRDET_XMLP_PKG
Run CS Service Request Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT     INC.INCIDENT_ID INCIDENT_ID1,
	INC.INCIDENT_NUMBER,
	to_char(INC.INCIDENT_DATE,'DD-MON-YYYY') INCIDENT_DATE,
                   INC.CUSTOMER_NUMBER,
                   INC.COMPANY_NAME,
NVL(INC.CURRENT_SERIAL_NUMBER, CII.SERIAL_NUMBER) CURRENT_SERIAL_NUMBER,
	INC.REFERENCE_NUMBER,
	INC.PROBLEM_CODE,
	INC.RESOLUTION_CODE,
                   INC.INCIDENT_TYPE,
	INC.SEVERITY,
	INC.URGENCY,
	INC.OWNER,
	INC.SUMMARY,
                   INC.PRODUCT_NAME,
	INC.PRODUCT_DESCRIPTION
FROM        CS_SR_REPORT_V INC,
	Mtl_System_items_VL MSI,
CSI_ITEM_INSTANCES cii
WHERE ROWNUM < 200 AND   
            MSI.inventory_item_id(+) = INC.inventory_item_id
AND 
            MSI.Organization_id(+) = :P_ORGANIZATION_ID AND
INC.inventory_item_id = CII.inventory_item_id(+) AND
cii.instance_id(+)           = inc.customer_product_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 INC.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