아래 쿼리는 postgres에서는 잘되는데
오라클에서는 병렬질의... 열은 하위 질의에 포괄 조인될 수 없습니다 라고 에러 발생하는 거 같습니다
실무 쿼리 비슷하게 만든 쿼리라 저 쿼리가 오라클에서 에러가 나는지 확인은 안해봤구요
아래 쿼리와 비슷한 실무 쿼리는 에러가 납니다
아래 쿼리는 
select 구문1
union all
select 구문2
이런 형식인데 select구문에서 left outer join 에 서브 쿼리로 되있어서 에러가 발생 하는거같습니다

각각의 select구문1, select구문2를 단독으로 실행하면 오라클에서는 잘 실행되는데
union all로 묶어서 실행하면 에러가 납니다

한 쿼리로 잘되게 실행되는 방법이 있을까요?



--국내
select
  t1.lss_id as lss_id
  ,max(t1.store) as store
  ,sum(
        case t1.loss_profit
	      when 'loss' then t1.amount
	      else 0
	    end
  ) as loss_amount
from
  domestic_store_loss t1
where t1.store = case 'ALL'
                   when 'ALL' then t1.store
				   when 'AAAA' then 'AAAA'
				   when 'BBBB' then 'BBBB'
				   when 'BANK' then 'BANK'
				 end
group by t1.lss_id
union all
--국외
select
  tm.lss_id
  ,tm.store
  ,tm.loss_amount
from
(
select
  t1.lss_id as lss_id
  ,max(t2.store) as store
  ,sum(
       case t2.store
	     when 'AAAA' then 
	                       case
	                         when t2.account = '1' or t2.account = '2' or t2.account = '3'
	                         then
	                              case t2.loss_profit
	                                when 'loss' then t2.amount * t_bs.xrt
	                                else 0
	                              end
	                         when t2.account = '4' or t2.account = '5' or t2.account = '6'
	                         then
	                              case t2.loss_profit
	                                 when 'loss' then t2.amount * t_is.xrt
	                                 else 0
	                              end
	                         else 0
	                       end
	     when 'BBBB' then 
	                       case
	                         when t2.account = '7' or t2.account = '8'
	                         then
	                              case t2.loss_profit
	                                when 'loss' then t2.amount * t_bs.xrt
	                                else 0
	                              end
	                         when t2.account = '9' or t2.account = '0'
	                         then
	                              case t2.loss_profit
	                                 when 'loss' then t2.amount * t_is.xrt
	                                 else 0
	                              end
	                         else 0
	                       end
	     else 0
	  end
  )  as loss_amount
from
  oversea_store_loss t1
  left outer join oversea_store_loss_detail t2
    on t1.lss_id = t2.lss_id
	   and t1.store = t2.store
  left outer join exchange_rate t_is
    on t2.reg_date = t_is.reg_date
  left outer join (
	  select
        substring(reg_date, 1, 4) reg_year
        ,currency
        ,round(avg(xrt), 2) as xrt
      from
         exchange_rate
      group by substring(reg_date, 1, 4), currency
  ) t_bs
    on substring(t2.reg_date, 1, 4) = reg_year
where
  1 = 1
group by t1.lss_id
order by 1
) tm
where
  tm.loss_amount > 9000000
  and tm.store = case 'ALL'
                   when 'ALL' then tm.store
				   when 'AAAA' then 'AAAA'
				   when 'BBBB' then 'BBBB'
				   when 'BANK' then 'BANK'
				 end
;


---------------------------
-- Table: public.domestic_store_loss

-- DROP TABLE IF EXISTS public.domestic_store_loss;

CREATE TABLE IF NOT EXISTS public.domestic_store_loss
(
    lss_id text COLLATE pg_catalog."default" NOT NULL,
    store text COLLATE pg_catalog."default" NOT NULL,
    reg_date text COLLATE pg_catalog."default" NOT NULL,
    loss_profit text COLLATE pg_catalog."default" NOT NULL,
    amount bigint,
    CONSTRAINT domestic_store_loss_pkey PRIMARY KEY (lss_id, store, reg_date, loss_profit)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.domestic_store_loss
    OWNER to postgres;

-- Table: public.exchange_rate

-- DROP TABLE IF EXISTS public.exchange_rate;

CREATE TABLE IF NOT EXISTS public.exchange_rate
(
    reg_date text COLLATE pg_catalog."default" NOT NULL,
    currency text COLLATE pg_catalog."default" NOT NULL,
    xrt bigint,
    CONSTRAINT exchange_rate_pkey PRIMARY KEY (reg_date, currency)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.exchange_rate
    OWNER to postgres;

COMMENT ON TABLE public.exchange_rate
    IS '환율정보';

-- Table: public.oversea_store_loss

-- DROP TABLE IF EXISTS public.oversea_store_loss;

CREATE TABLE IF NOT EXISTS public.oversea_store_loss
(
    lss_id text COLLATE pg_catalog."default" NOT NULL,
    store text COLLATE pg_catalog."default",
    reg_date text COLLATE pg_catalog."default",
    CONSTRAINT oversea_store_loss_pkey PRIMARY KEY (lss_id)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.oversea_store_loss
    OWNER to postgres;

-- Table: public.oversea_store_loss_detail

-- DROP TABLE IF EXISTS public.oversea_store_loss_detail;

CREATE TABLE IF NOT EXISTS public.oversea_store_loss_detail
(
    lss_id text COLLATE pg_catalog."default" NOT NULL,
    store text COLLATE pg_catalog."default" NOT NULL,
    account text COLLATE pg_catalog."default" NOT NULL,
    reg_date text COLLATE pg_catalog."default" NOT NULL,
    loss_profit text COLLATE pg_catalog."default" NOT NULL,
    amount bigint,
    CONSTRAINT oversea_store_loss_detail_pkey PRIMARY KEY (lss_id, store, account, reg_date, loss_profit)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.oversea_store_loss_detail
    OWNER to postgres;
---------------------------