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