您可以这样做（使用实际的表名和列名，而不是应该删除的查询中的with子句）。请注意，分层递归从末尾（从'Active'状态）开始并向后进行;在我查询中，我在级别4停止它，因为我不想写入足够的行来到达级别13。当然，您必须在where子句中将4替换为13。

with
  test_data (customer_id, order_id, prev_order_id, status) as (
    select 1, 123, null, 'Complete' from dual union all
    select 1, 456,  123, 'Complete' from dual union all
    select 1, 789,  456, 'Complete' from dual union all
    select 1, 888,  789, 'Complete' from dual union all
    select 1, 999,  888, 'Active'   from dual union all
    select 2, 100, null, 'Complete' from dual union all
    select 2, 200,  100, 'Active'   from dual union all
    select 5, 105, null, 'Complete' from dual union all
    select 5, 106,  105, 'Complete' from dual union all
    select 5, 205, null, 'Complete' from dual union all
    select 5, 206,  205, 'Active'   from dual
  )
select  customer_id
from    test_data
where   level = 4
start   with status = 'Active'
connect by customer_id = prior customer_id and order_id = prior prev_order_id
;

CUSTOMER_ID
-----------
          1

需要更多的数据和测试。
也许会对你有帮助

CREATE TABLE CUSTOMER_LOG
(
CUSTOMER_ID number(5),
ORDER_ID number(5),
PREV_ORDER_ID number(5),
STATUS VARCHAR(50)
);

INSERT INTO CUSTOMER_LOG(CUSTOMER_ID,ORDER_ID,PREV_ORDER_ID,STATUS) values (1,123,NULL, 'Complete');
INSERT INTO CUSTOMER_LOG(CUSTOMER_ID,ORDER_ID,PREV_ORDER_ID,STATUS) values (1,456,123, 'Complete');
INSERT INTO CUSTOMER_LOG(CUSTOMER_ID,ORDER_ID,PREV_ORDER_ID,STATUS) values (1,789,456, 'Complete');
INSERT INTO CUSTOMER_LOG(CUSTOMER_ID,ORDER_ID,PREV_ORDER_ID,STATUS) values (1,888,789, 'Complete');
INSERT INTO CUSTOMER_LOG(CUSTOMER_ID,ORDER_ID,PREV_ORDER_ID,STATUS) values (1,999,888, 'Active');

Select
l.*,
(
select count(*)
from CUSTOMER_LOG s
where s.customer_id=1
start with s.ORDER_ID=l.ORDER_ID
connect by s.ORDER_ID= prior s.PREV_ORDER_ID   
) QTDE
from CUSTOMER_LOG l
where l.status='Active'