CS Service Request Detail

➜ Back to Library
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
Download
Related Blitz Reports
CS Service Request Summary CSD Depot Repair XMLP Estimate INV Inventory Items XXE4ARW Excel4apps Inventory Items CSD Depot Repair Traveler AHL Supplier Warranty Visit AHL Supplier Warranty Claims CSI Customer Products Summary AHL Generate Visit Instance - Tasks Warranty Contracts
Blitz Report™

Blitz Report™ provides multiple benefits: