SELECT DISTINCT :SPID, t1.nodename nodename, t1.gdate, t1.gtime,
                   t1.gdate_time, t1.ndd_mw, t1.ndd_mv, nvl(t1.fms_mw,0)+t2.fms_mw+mw, nvl(t1.fms_mv,0)+t2.fms_mv+mv,
                   t1.nddraw_mw, t1.nddraw_mv
              FROM tmp_ndd_nddraw_fms_data t1, tmp_ndd_nddraw_fms_data t2, (
              WITH min_max_date as(select min(gdate) min_date,max(gdate) max_date from tmp_ms_data),
maps as( select game from unmetmap where gspid=:SPID),
t AS
     (
        SELECT   TO_CHAR (f.target_datetime, 'YYYYmmdd') gdate,
                 TO_CHAR (f.target_datetime, 'HH24mi') gtime,
                 SUM (f.mean_frcstd_mw) mw
            FROM pkd_dt f, wgen w,maps m,min_max_date d
           WHERE f.gen_id = w.gen_id
             AND w.gen_name =m.gen_name
             AND f.target_datetime BETWEEN   TO_DATE (d.min_date,
                                                      'yyyymmddhh24mi'
                                                     )
                                           - 1 / 48
                                       AND   TO_DATE (d.max_date + 1,
                                                      'yyyymmddhh24mi'
                                                     )
                                           + 1 / 48
        GROUP BY f.target_datetime
        ORDER BY TO_CHAR (f.target_datetime, 'YYYYmmdd'),
                 TO_CHAR (f.target_datetime, 'HH24mi')),
     m_w AS
     (
        SELECT gdate,
               DECODE (gtime,
                       2330, 2400,
                       TO_CHAR (  TO_DATE (LPAD (gtime, 4, '000'), 'HH24mi')
                                + 1 / 48,
                                'HH24MI'
                               )
                      ) gtime,
               mw
          FROM (SELECT gdate, gtime + 0 gtime, mw
                  FROM t t1
                UNION
                SELECT t1.gdate, t1.gtime + 30 gtime, (t1.mw + t2.mw) / 2
                  FROM t t2, t t1
                 WHERE (t1.gdate = t2.gdate AND t1.gtime + 100 = t2.gtime)
                    OR (    t1.gdate + 1 = t2.gdate
                        AND t1.gtime = 2300
                        AND t2.gtime = 0
                       )),min_max_date
         WHERE gdate BETWEEN min_date AND max_date),
     t2 AS
     (
        SELECT   TO_CHAR (f.target_datetime, 'YYYYmmdd') gdate,
                 TO_CHAR (f.target_datetime, 'HH24mi') gtime,
                 SUM (f.f_mvar) mw
            FROM extdata f, wger w,maps m,min_max_date d
           WHERE f.gen_id = w.gen_id
             AND w.gen_name =m.gen_name
             AND f.target_datetime BETWEEN   TO_DATE (min_date,
                                                      'yyyymmddhh24mi'
                                                     )
                                           - 1 / 48
                                       AND   TO_DATE (max_date + 1,
                                                      'yyyymmddhh24mi'
                                                     )
                                           + 1 / 48
        GROUP BY f.target_datetime
        ORDER BY TO_CHAR (f.target_datetime, 'YYYYmmdd'),
                 TO_CHAR (f.target_datetime, 'HH24mi')),
     wind_mv AS
     (
        SELECT gdate,
               DECODE (gtime,
                       2330, 2400,
                       TO_CHAR (  TO_DATE (LPAD (gtime, 4, '000'), 'HH24mi')
                                + 1 / 48,
                                'HH24MI'
                               )
                      ) gtime,
               mw mv
          FROM (SELECT gdate, gtime + 0 gtime, mw
                  FROM t2 t1
                UNION
                SELECT t1.gdate, t1.gtime + 30 gtime, (t1.mw + t2.mw) / 2
                  FROM t2 t2, t2 t1
                 WHERE (t1.gdate = t2.gdate AND t1.gtime + 100 = t2.gtime)
                    OR (    t1.gdate + 1 = t2.gdate
                        AND t1.gtime = 2300
                        AND t2.gtime = 0
                       )),min_max_date
         WHERE gdate BETWEEN min_date AND max_date)
     (SELECT wmw.gdate, wmw.gtime, nvl(mw,0)mw, nvl(mv,0) mv
        FROM w_mw, w_mv
       WHERE wind_mw.gdate = wind_mv.gdate(+) AND wind_mw.gtime = wind_mv.gtime(+))) T3
             WHERE t1.gdate = t2.gdate
               AND t1.gtime = t2.gtime
               and t1.gtime=t3.gtime
               and t1.gdate=t3.gdate
               AND t1.nodename = t2.nodename || 'DW'
               AND t1.nodename LIKE '%DW'
               AND t1.spid = 0

TO_DATE (max_date + 1,
                                                      'yyyymmddhh24mi'
                                                     )

SQL> SELECT TO_DATE (201310071259, 'yyyymmddhh24mi') FROM dual;
 
TO_DATE(201310071259,'YYYYMMDD
------------------------------
07/10/2013 12:59:00
 
SQL> SELECT TO_DATE (201310071259 + 1, 'yyyymmddhh24mi') FROM dual;
 
SELECT TO_DATE (201310071259 + 1, 'yyyymmddhh24mi') FROM dual
 
ORA-01851: minutes must be between 0 and 59
 
SQL> 

t1.gdate + 1 = t2.gdate

SQL> SELECT TO_CHAR (last_day(SYSDATE), 'YYYYmmdd') + 1 FROM dual;
 
TO_CHAR(LAST_DAY(SYSDATE),'YYY
------------------------------
                      20131032
 
SQL> 

WHERE (t1.gdate = t2.gdate AND t1.gtime + 100 = t2.gtime)
       OR (t1.gdate + 1 = t2.gdate
           AND t1.gtime = 2300
           AND t2.gtime = 0
          )

WHERE t1.gdate + 1/24 = t2.gdate