SELECT ROWNUM AS R, ARCH.STATE_TIME,
       ARCH.OBJECT_ID,
       OBJS.DISPLAY_NAME,
       ARCH.ADDRESS,
       ARCH.SLAB_ACTION AS ACTION,
       ARCH.AUTHOR_ID,
       ARCH.EDITOR_ID,
       ARCH.DELETOR_ID
FROM WMS_SLAB_STATES_ARCHIVE ARCH
JOIN WMS_WAREHOUSE_OBJECTS OBJS
  ON OBJS.WRHS_OBJ_ID = ARCH.OBJECT_ID
JOIN
(
    SELECT ARCH.SL_ST_A_ID, ARCH.OBJECT_ID
    FROM
    (
        SELECT ROWNUM AS R, ARCH.*
        FROM
        (
            SELECT *
            FROM WMS_SLAB_STATES_ARCHIVE ARCH
            WHERE ARCH.STATE_TIME > '20.09.2017 00:00:00'
            ORDER BY ARCH.OBJECT_ID, ARCH.STATE_TIME
        ) ARCH
    ) PREV_ARCH
    JOIN
    (
        SELECT ROWNUM AS R, ARCH.*
        FROM
        (
            SELECT *
            FROM WMS_SLAB_STATES_ARCHIVE ARCH
            WHERE ARCH.STATE_TIME > '20.09.2017 00:00:00'
            ORDER BY ARCH.OBJECT_ID, ARCH.STATE_TIME
        ) ARCH
    ) ARCH
    ON PREV_ARCH.R + 1 = ARCH.R
      AND PREV_ARCH.OBJECT_ID = ARCH.OBJECT_ID
    JOIN WMS_STORAGE_STATES_ARCHIVE PARENTS
      ON PARENTS.STORAGE_ID = PREV_ARCH.PARENT_ID
        AND ABS( EXTRACT( SECOND FROM PARENTS.STATE_TIME - PREV_ARCH.STATE_TIME )
              + EXTRACT( MINUTE FROM PARENTS.STATE_TIME - PREV_ARCH.STATE_TIME ) * 60
              + EXTRACT( HOUR FROM PARENTS.STATE_TIME - PREV_ARCH.STATE_TIME ) * 60 * 60
              + EXTRACT( DAY FROM PARENTS.STATE_TIME - PREV_ARCH.STATE_TIME ) * 60 * 60 * 24
                ) <= 1
    JOIN WMS_WAREHOUSE_OBJECTS PPARENTS
      ON PPARENTS.WRHS_OBJ_ID = PARENTS.STORAGE_ID
    WHERE ARCH.SLAB_ACTION = 11
      AND PARENTS.STATE_TIME > '20.09.2017 00:00:00'
      AND PPARENTS.WRHS_OBJ_ID IN
      (
        -- ТП УУС-1
        20582729,
        -- ПТ УУС-2
        20582736,

        -- ТОЛ-1
        24150640,
        -- ТОЛ-2
        24150538
      )
) ARCH_KEYS
ON ARCH.SL_ST_A_ID <= ARCH_KEYS.SL_ST_A_ID
  AND ARCH.OBJECT_ID = ARCH_KEYS.OBJECT_ID
WHERE OBJS.OBJECT_TYPE = 1
  AND OBJS.DATE_CREATE > '10.09.2017 00:00:00'
ORDER BY ARCH.OBJECT_ID, ARCH.STATE_TIME