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
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