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 |