CS Service Request Detail

Description

Categories: BI Publisher, Service

Application: Service
Source: Service Request Detail Report (XML)
Short Name: CSXSRDET_XML
DB package: CS_CSXSRDET_XMLP_PKG

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

Ask a question

Download

Related Blitz Reports

CSD Depot Repair XMLP Estimate CS Service Request Summary CSD Depot Repair Traveler INV Inventory Items AHL Supplier Warranty Visit CSI Customer Products Summary AR Transactions and Lines AHL Supplier Warranty Claims AHL Generate Visit Instance - Tasks Warranty Contracts