CS Service Request Detail

➜ Back to Library

Description
Categories: BI Publisher, Service Application: Service Source: Service Request Detail Report (XML) Short Name: CSXSRDET_XML DB package: CS_CSXSRDET_XMLP_PKG more less

Copy

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

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

Download

Related Blitz Reports
CSD Depot Repair XMLP Estimate CS Service Request Summary CSD Depot Repair Traveler AHL Supplier Warranty Visit AHL Supplier Warranty Claims CSI Customer Products Summary AHL Generate Visit Instance - Tasks Warranty Contracts AHL Generate Visit Instances Warranty Contracts ONT Cancelled Orders