无聊SQL1

select (select min(event.event_start_dt) actPeriodStDt
          from cost_event event
         where event.mdl_ver_id = 71502
           and (event.actualize_ind = 'A' or event.actualize_ind = 'L')) actPeriodStDt,
       (Select max(maxActDate)
          from ((select max(event.event_start_dt) maxActDate
                   from cost_event event, cost_event_service s
                  where event.mdl_ver_id = 97194
                    and event.mdl_ver_id = s.mdl_ver_id
                    and event.event_id = s.event_id
                    and (event.actualize_ind = 'A' or
                        event.actualize_ind = 'L')) union
             (select max(event.event_start_dt + nvl(event_duration_days, 0)) maxActDate
                   from cost_event event, cost_part_event p
                  where event.mdl_ver_id = 97194
                    and event.mdl_ver_id = p.mdl_ver_id
                    and event.event_id = p.event_id
                    and (event.actualize_ind = 'A' or
                        event.actualize_ind = 'L')))) actPeriodEdDt
  from dual