SQL & PL/SQL

Hi Gurus

I appreciate if someone help me out.

I have the following data:

Sample data

DROP TABLE z_sen_dtl;
/
DROP SEQUENCE z_s_dtl_seq;
/
CREATE SEQUENCE z_s_dtl_seq MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE ;
  /
  CREATE TABLE z_sen_dtl
    (
      s_id     NUMBER,
      s_dtl_id NUMBER,
      f_amt    NUMBER,
      v_amt    NUMBER
    ) ;
  /
  /
  INSERT ALL
    WHEN f_amt>0 THEN
  INTO z_sen_dtl
    (
      s_id,
      s_dtl_id,
      f_amt,
      v_amt
    )
    VALUES
    (
      s_id,
      z_s_dtl_seq.nextval,
      f_amt,
      v_amt
    )
    WHEN v_amt>0 THEN
  INTO z_sen_dtl
    (
      s_id,
      s_dtl_id,
      f_amt,
      v_amt
    )
    VALUES
    (
      s_id,
      z_s_dtl_seq.nextval,
      f_amt,
      v_amt
    )
WITH datum AS
  ( SELECT 90138 s_id , 80000 f_amt, 12000 v_amt FROM dual
  )
SELECT * FROM datum ;

Data After Insert in z_sen_dtl

S_ID, S_DTL_ID,      F_AMT, V_AMT

90138      1                80000      12000
90138      1                80000      12000

Required Output in z_sen_dtl

S_ID, S_DTL_ID,      F_AMT, V_AMT

90138      1                80000      12000
90138      2                80000      12000

If you see my code then I use nextval in my both insert statement but still system is not incrementing by 1. Can somebody guide me how to fix this issue?. Thanks in advance

Regards

Matt