SQL & PL/SQL

Hi,

I am gettng a oracle error "ora 00933 - sql command not properly ended".whts wrng with this code?

INSERT INTO SVC_ORDER
      (SVC_ORDER_ID,
       ORDER_NUMBER,
       ORDER_STATUS,
       ORDER_TYPE,
       DUE_DATE,
       RECEIVED_DATE,
       SERVICE_ID,
       VERSION)                    
       SELECT SVC_ORDER_ID.NEXTVAL,
              SUBSTR(O.SVC_ORD_NBR,1,8) AS ORDER_NUMBER,
              S.TBL_DATA AS ORDER_STATUS,
              DECODE(O.SVC_ORD_TYPE,'INST','ADD',
                                    'CKTO','DISCONNECT',
                                    'CKTA','SUPP',
                                    'CHNG','CHANGE') AS ORDER_TYPE,
               TO_DATE
          ( CASE
              WHEN NOT TO_NUMBER (SUBSTR (SVC_ORD_DT_REQ, 3, 2)) BETWEEN 1
                                                                         AND 12
                 THEN NULL
              ELSE SVC_ORD_DT_REQ
           END,
           'yymmrr'
          ) DUE_DT
  FROM (SELECT LPAD (TO_CHAR (O.SVC_ORD_DT_REQ),
                     6,
                     '0'
                    ) SVC_ORD_DT_REQ
          FROM M04_NT_UV_ORD_ADMIN O),
             
             TO_DATE
          (CASE
              WHEN NOT TO_NUMBER (SUBSTR (SVC_ORD_DT_ENTERED, 3, 2)) BETWEEN 1
                                                                         AND 12
                 THEN NULL
              ELSE SVC_ORD_DT_ENTERED
           END,
           'yymmrr'
          ) RECEIVED_DT
  FROM (SELECT LPAD (TO_CHAR (O.SVC_ORD_DT_ENTERED),
                     6,
                     '0'
                    ) SVC_ORD_DT_ENTERED
          FROM M04_NT_UV_ORD_ADMIN O) ,
                          N.END_CCT_NBR_SEQ,
              SUBSTR(O.SVC_ORD_NBR,9,1) AS VERSION
       FROM M04_NT_UV_ORD_ADMIN O,
            M04_CCT_NBR_RANGE N,
            M09_NT_UV_SECUR_TABLE S 
       WHERE O.ADABAS_ISN=N.ADABAS_ISN
       AND O.SVC_ORD_STATUS_CD=S.TBL_PRI
       AND S.TBL_ID=24