CS Service Request Summary
Description
Categories: BI Publisher
Application: Service
Source: Service Request Summary Report (XML)
Short Name: CSXSRSUM_XML
DB package: CS_CSXSRSUM_XMLP_PKG
Source: Service Request Summary Report (XML)
Short Name: CSXSRSUM_XML
DB package: CS_CSXSRSUM_XMLP_PKG
Run
CS Service Request Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT CV.INCIDENT_NUMBER, CV.INCIDENT_DATE, CV.PROBLEM_CODE, CV.RESOLUTION_CODE, CV.INCIDENT_TYPE, CV.SEVERITY, CV.STATUS_CODE, CV.URGENCY, CV.OWNER, CV.CUSTOMER_NUMBER, CV.COMPANY_NAME CUSTOMER_NAME, NVL(CV.CURRENT_SERIAL_NUMBER, CII.SERIAL_NUMBER) CURRENT_SERIAL_NUMBER, CV.REFERENCE_NUMBER, CV.PRODUCT_NAME, CV.SUMMARY FROM CS_SR_REPORT_V CV, MTL_SYSTEM_ITEMS_VL MSI, CSI_ITEM_INSTANCES cii WHERE CV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND CV.inventory_item_id = cii.inventory_item_id(+) AND cii.instance_id(+) = CV.customer_product_id AND MSI.organization_id(+) = to_number(fnd_profile.value_specific('SO_ORGANIZATION_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 CV.CUSTOMER_NUMBER , CV.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 |