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