[Home] [Help]
559: -- Cursor to get the object version number and repair quantity
560: -- and SR summary
561: CURSOR CUR_REPAIR_LINE(p_Repair_line_id NUMBER) IS
562: SELECT A.QUANTITY, A.OBJECT_VERSION_NUMBER, B.SUMMARY, B.INCIDENT_ID
563: FROM CSD_REPAIRS A, CS_INCIDENTS_ALL_VL B
564: WHERE A.REPAIR_LINE_ID = p_repair_line_id
565: AND A.INCIDENT_ID = B.INCIDENT_ID;
566:
567: l_incident_id NUMBER;