DROP TABLE DEMO_TAB

CREATE TABLE DEMO_TAB
(
  SEQCLAIMID    NUMBER(9),
  LINE_NUMBER   NUMBER,
  SYS_REV_CODE  VARCHAR2(8 BYTE),
  REVCODE       VARCHAR2(48 BYTE),
  QUANTITY1     NUMBER(15,1),
  PROC_CODE     VARCHAR2(8 BYTE),
  CLMSTAT       CHAR(1 BYTE),
  PROCSTAT      CHAR(1 BYTE),
  PAID          NUMBER(18,2)
);


INSERT ALL 
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, REVCODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT)
 Values
   (245976246, 1, '0124', 1, '124', 'I', 'F')
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, REVCODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT)
 Values
   (245976246, 2, '0124', 1, '124', 'I', 'F')
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, REVCODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT)
 Values
   (245976246, 3, '0124', 1, '124', 'I', 'F')
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, REVCODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT)
 Values
   (245976246, 4, '0124', 1, '124', 'I', 'F')
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, REVCODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT)
 Values
   (245976246, 5, '0124', 1, '124', 'I', 'F')
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, SYS_REV_CODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT, PAID)
 Values
   (245976246, 6, '124', 13, 'SYSPSYC2', 'P', 'P', 6500)
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, SYS_REV_CODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT, PAID)
 Values
   (245976246, 7, ' ', 1, '--', 'P', 'P', 100)
into DEMO_TAB
   (SEQCLAIMID, LINE_NUMBER, SYS_REV_CODE, QUANTITY1, PROC_CODE, CLMSTAT, PROCSTAT, PAID)
 Values
   (245976246, 8, ' ', 1, '--', 'P', 'P', 60)
SELECT * FROM DUAL;
COMMIT;

SELECT * FROM DEMO_TAB;

SEQCLAIMID LINE_NUMBER SYS_REV_ REVCODE            QUANTITY1 PROC_COD C P       PAID
---------- ----------- -------- ----------------- ---------- -------- - - ----------
 245976246           1          0124                       1 124      I F
 245976246           2          0124                       1 124      I F
 245976246           3          0124                       1 124      I F
 245976246           4          0124                       1 124      I F
 245976246           5          0124                       1 124      I F
 245976246           6 124                                13 SYSPSYC2 P P       6500
 245976246           7                                     1 --       P P        100
 245976246           8                                     1 --       P P         60
6 rows selected.


DESIRED RESULT IS :

SEQCLAIMID LINE_NUMBER SYS_REV_ REVCODE          QUANTITY1 PROC_COD C P       PAID
---------- ----------- -------- --------------- ---------- -------- - - ----------
 245976246           1  124     0124                    16 124      P F	     6760