merge into B24_QUEUE Q
    using
    (
    with CL as
    (
    select CLIENT_ID
    --, case when exists (select * from BM_ACTION_LOG where CUSTOMER_ID = CL.CLIENT_ID and MOMENT >= CL.MOMENT and ACTION_ID < 1000) then 1 end FL
    , case when exists (select * from BM_PAYMENT where CUSTOMER_ID = CL.CLIENT_ID and INPUT_MOMENT >= CL.MOMENT) then 1 end FP
    , case when exists (select * from SERVICES where CUSTOMER_ID = CL.CLIENT_ID and STATUS_DATE >= CL.MOMENT) then 1 end FS
    , case when exists (select * from SERVICES join BM_SERVICE_MONEY using (SERVICE_ID) where CUSTOMER_ID = CL.CLIENT_ID and MOMENT >= CL.MOMENT and MONEY != 0) then 1 end FC
    from (select CLIENT_ID, MOMENT from CYBERCOM.B24_CACHE) CL
    )
    select * from CL where coalesce(/*FL,*/FP,FS,FC) is not null
    ) D
    on (D.CLIENT_ID = Q.CLIENT_ID)
    when not matched then insert (Q.CLIENT_ID, MOMENT) values (D.CLIENT_ID, sysdate)

PLAN_TABLE_OUTPUT
HASH_VALUE  2497165858, child number 0
--------------------------------------
merge into CYBERCOM.B24_QUEUE Q     using     (     with CL as     (     select CLIENT_ID     --, 
case when exists (select * from BM_ACTION_LOG where CUSTOMER_ID = CL.CLIENT_ID and MOMENT > 
CL.MOMENT and ACTION_ID < 1000) then 1 end FL     , case when exists (select * from BM_PAYMENT where 
CUSTOMER_ID = CL.CLIENT_ID and INPUT_MOMENT > CL.MOMENT) then 1 end FP     , case when exists 
(select * from SERVICES where CUSTOMER_ID = CL.CLIENT_ID and STATUS_DATE > CL.MOMENT) then 1 end FS  
   , case when exists (select * from SERVICES join BM_SERVICE_MONEY using (SERVICE_ID) where 
CUSTOMER_ID = CL.CLIENT_ID and MOMENT > CL.MOMENT and MONEY != 0) then 1 end FC     from (select 
CLIENT_ID, MOMENT from CYBERCOM.B24_CACHE) CL     )     select * from CL where 
coalesce(/*FL,*/FP,FS,FC) is not null     ) D     on (D.CLIENT_ID = Q.CLIENT_ID)     when not 
matched then insert (Q.CLIENT_ID, MOMENT) values (D.CLIENT_ID, sysdate)
 
Plan hash value: 558666016
 
-------------------------------------------------------------------------------------------------------------
| Id  | Operation                            | Name                     | E-Rows |  OMem |  1Mem | Used-Mem |
-------------------------------------------------------------------------------------------------------------
|   1 |  MERGE                               | B24_QUEUE                |        |       |       |          |
|   2 |   VIEW                               |                          |        |       |       |          |
|   3 |    NESTED LOOPS OUTER                |                          |      1 |       |       |          |
|   4 |     VIEW                             |                          |      1 |       |       |          |
|*  5 |      FILTER                          |                          |        |       |       |          |
|   6 |       TABLE ACCESS FULL              | B24_CACHE                |      1 |       |       |          |
|*  7 |       VIEW                           | index$_join$_013         |     14 |       |       |          |
|*  8 |        HASH JOIN                     |                          |        |  1078K|  1078K|          |
|*  9 |         INDEX RANGE SCAN             | PAYMENT_CUSTOMER_IDX     |     14 |       |       |          |
|* 10 |         INDEX RANGE SCAN             | PAYMENT_INPUT_MOMENT_IDX |     14 |       |       |          |
|* 11 |        TABLE ACCESS BY INDEX ROWID   | SERVICES                 |      1 |       |       |          |
|* 12 |         INDEX RANGE SCAN             | SERV_CUSTOMER_IDX        |      5 |       |       |          |
|* 13 |         TABLE ACCESS BY INDEX ROWID  | BM_SERVICE_MONEY         |     58 |       |       |          |
|  14 |          NESTED LOOPS                |                          |    296 |       |       |          |
|  15 |           TABLE ACCESS BY INDEX ROWID| SERVICES                 |      5 |       |       |          |
|* 16 |            INDEX RANGE SCAN          | SERV_CUSTOMER_IDX        |      5 |       |       |          |
|* 17 |           INDEX RANGE SCAN           | SVRM_SERVICE_IDX         |  71133 |       |       |          |
|  18 |     TABLE ACCESS BY INDEX ROWID      | B24_QUEUE                |      1 |       |       |          |
|* 19 |      INDEX UNIQUE SCAN               | B24_QUEUE_PK             |      1 |       |       |          |
-------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   5 - filter(COALESCE(CASE  WHEN  IS NOT NULL THEN 1 END ,CASE  WHEN  IS NOT NULL THEN 1 END ,CASE  
              WHEN  IS NOT NULL THEN 1 END ) IS NOT NULL)
   7 - filter(("CUSTOMER_ID"=:B1 AND "INPUT_MOMENT">:B2))
   8 - access(ROWID=ROWID)
   9 - access("CUSTOMER_ID"=:B1)
  10 - access("INPUT_MOMENT">:B1)
  11 - filter("STATUS_DATE">:B1)
  12 - access("CUSTOMER_ID"=:B1)
  13 - filter(("BM_SERVICE_MONEY"."MONEY"<>0 AND "BM_SERVICE_MONEY"."MOMENT">:B1))
  16 - access("SERVICES"."CUSTOMER_ID"=:B1)
  17 - access("SERVICES"."SERVICE_ID"="BM_SERVICE_MONEY"."SERVICE_ID")
  19 - access("D"."CLIENT_ID"="Q"."CLIENT_ID")
 
Note
-----
   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level
 

PLAN_TABLE_OUTPUT
HASH_VALUE  1050332861, child number 0
--------------------------------------
merge /*+ GATHER_PLAN_STATISTICS */ into CYBERCOM.B24_QUEUE Q     using     (     with CL as     (   
  select CLIENT_ID     --, case when exists (select * from BM_ACTION_LOG where CUSTOMER_ID = 
CL.CLIENT_ID and MOMENT > CL.MOMENT and ACTION_ID < 1000) then 1 end FL     , case when exists 
(select * from BM_PAYMENT where CUSTOMER_ID = CL.CLIENT_ID and INPUT_MOMENT > CL.MOMENT) then 1 end 
FP     , case when exists (select * from SERVICES where CUSTOMER_ID = CL.CLIENT_ID and STATUS_DATE > 
CL.MOMENT) then 1 end FS     , case when exists (select * from SERVICES join BM_SERVICE_MONEY using 
(SERVICE_ID) where CUSTOMER_ID = CL.CLIENT_ID and MOMENT > CL.MOMENT and MONEY != 0) then 1 end FC   
  from (select CLIENT_ID, MOMENT from CYBERCOM.B24_CACHE) CL     )     select * from CL where 
coalesce(/*FL,*/FP,FS,FC) is not null     ) D     on (D.CLIENT_ID = Q.CLIENT_ID)     when not 
matched then insert (Q.CLIENT_ID, MOMENT) values (D.CLIENT_ID, sysdate)
 
Plan hash value: 558666016
 
-------------------------------------------------------------------------------------------------------------
| Id  | Operation                            | Name                     | E-Rows |  OMem |  1Mem | Used-Mem |
-------------------------------------------------------------------------------------------------------------
|   1 |  MERGE                               | B24_QUEUE                |        |       |       |          |
|   2 |   VIEW                               |                          |        |       |       |          |
|   3 |    NESTED LOOPS OUTER                |                          |      1 |       |       |          |
|   4 |     VIEW                             |                          |      1 |       |       |          |
|*  5 |      FILTER                          |                          |        |       |       |          |
|   6 |       TABLE ACCESS FULL              | B24_CACHE                |      1 |       |       |          |
|*  7 |       VIEW                           | index$_join$_013         |     14 |       |       |          |
|*  8 |        HASH JOIN                     |                          |        |  1078K|  1078K|          |
|*  9 |         INDEX RANGE SCAN             | PAYMENT_CUSTOMER_IDX     |     14 |       |       |          |
|* 10 |         INDEX RANGE SCAN             | PAYMENT_INPUT_MOMENT_IDX |     14 |       |       |          |
|* 11 |        TABLE ACCESS BY INDEX ROWID   | SERVICES                 |      1 |       |       |          |
|* 12 |         INDEX RANGE SCAN             | SERV_CUSTOMER_IDX        |      5 |       |       |          |
|* 13 |         TABLE ACCESS BY INDEX ROWID  | BM_SERVICE_MONEY         |     58 |       |       |          |
|  14 |          NESTED LOOPS                |                          |    296 |       |       |          |
|  15 |           TABLE ACCESS BY INDEX ROWID| SERVICES                 |      5 |       |       |          |
|* 16 |            INDEX RANGE SCAN          | SERV_CUSTOMER_IDX        |      5 |       |       |          |
|* 17 |           INDEX RANGE SCAN           | SVRM_SERVICE_IDX         |  71133 |       |       |          |
|  18 |     TABLE ACCESS BY INDEX ROWID      | B24_QUEUE                |      1 |       |       |          |
|* 19 |      INDEX UNIQUE SCAN               | B24_QUEUE_PK             |      1 |       |       |          |
-------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   5 - filter(COALESCE(CASE  WHEN  IS NOT NULL THEN 1 END ,CASE  WHEN  IS NOT NULL THEN 1 END ,CASE  
              WHEN  IS NOT NULL THEN 1 END ) IS NOT NULL)
   7 - filter(("CUSTOMER_ID"=:B1 AND "INPUT_MOMENT">:B2))
   8 - access(ROWID=ROWID)
   9 - access("CUSTOMER_ID"=:B1)
  10 - access("INPUT_MOMENT">:B1)
  11 - filter("STATUS_DATE">:B1)
  12 - access("CUSTOMER_ID"=:B1)
  13 - filter(("BM_SERVICE_MONEY"."MONEY"<>0 AND "BM_SERVICE_MONEY"."MOMENT">:B1))
  16 - access("SERVICES"."CUSTOMER_ID"=:B1)
  17 - access("SERVICES"."SERVICE_ID"="BM_SERVICE_MONEY"."SERVICE_ID")
  19 - access("D"."CLIENT_ID"="Q"."CLIENT_ID")
 
Note
-----
   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level
 

    merge into B24_QUEUE Q
    using
    (
    select CL.CLIENT_ID, coalesce(FP.M, FS.M, FC.M, FL.M) as MOMENT
    from B24_CACHE CL
    left join
      (
      select CUSTOMER_ID as C, max(INPUT_MOMENT) as M
      from BM_PAYMENT
      where INPUT_MOMENT > trunc(sysdate)-50
      group by CUSTOMER_ID
      ) FP on (FP.C = CL.CLIENT_ID and FP.M > CL.MOMENT)
    left join
      (
      select CUSTOMER_ID as C, max(STATUS_DATE) as M
      from SERVICES
      where STATUS_DATE > trunc(sysdate)-50
      group by CUSTOMER_ID
      ) FS on (FS.C = CL.CLIENT_ID and FS.M > CL.MOMENT)
    left join
      (
      select S.CUSTOMER_ID as C, max(SM.MOMENT) as M
      from SERVICES S
      join BM_SERVICE_MONEY SM on (SM.SERVICE_ID = S.SERVICE_ID)
      where SM.MOMENT > trunc(sysdate)-50
      and SM.FDATE > trunc(sysdate)-50
      and SM.MONEY != 0
      group by S.CUSTOMER_ID
      ) FC on (FC.C = CL.CLIENT_ID and FC.M > CL.MOMENT)
    left join
      (
      select CUSTOMER_ID as C, max(MOMENT) as M
      from BM_ACTION_LOG
      where MOMENT > trunc(sysdate)-50
      and ACTION_ID < 1000
      group by CUSTOMER_ID
      ) FL on (FL.C = CL.CLIENT_ID and FL.M > CL.MOMENT)
    where coalesce(FP.M,FS.M,FC.M,FL.M) is not null
    ) D
    on (D.CLIENT_ID = Q.CLIENT_ID)
    when not matched then insert (Q.CLIENT_ID, MOMENT) values (D.CLIENT_ID, sysdate)