Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE P_C_REL (Child , Parent ,Ownership) AS
SELECT 41203134, 10151091, 100 FROM DUAL UNION ALL
SELECT 10250181, 40001104,  30 FROM DUAL UNION ALL
SELECT 40856701, 40109963, 100 FROM DUAL UNION ALL
SELECT 10159060, 40001104, 100 FROM DUAL UNION ALL
SELECT 41328372, 10250181, 100 FROM DUAL UNION ALL
SELECT 40001471, 10159060, 100 FROM DUAL UNION ALL
SELECT 10250181, 40001471,  70 FROM DUAL UNION ALL
SELECT 10151091, 40856701, 100 FROM DUAL UNION ALL
SELECT 40001104, 10351678, 100 FROM DUAL;
9 rows affected

SELECT CONNECT_BY_ROOT child AS child,
       SUBSTR(SYS_CONNECT_BY_PATH(child, ',' ), 2) || ',' || parent AS path
FROM   p_c_rel
WHERE CONNECT_BY_ISLEAF = 1
START WITH child IN (41203134, 41328372)
CONNECT BY child = PRIOR parent


CHILD
PATH


41203134
41203134,10151091,40856701,40109963

41328372
41328372,10250181,40001104,10351678

41328372
41328372,10250181,40001471,10159060,40001104,10351678


WITH path (root, path, parent, ownership) AS (
  SELECT child, child || ',' || parent, parent, ownership
  FROM   p_c_rel
  WHERE  child IN (41203134, 41328372)
UNION ALL
  SELECT p.root, p.path || ',' || r.parent, r.parent, p.ownership + r.ownership
  FROM   path p
         INNER JOIN p_c_rel r
         ON p.parent = r.child
)
SELECT root, path, ownership
FROM   path
ORDER BY DENSE_RANK() OVER (PARTITION BY root ORDER BY ownership DESC)
FETCH FIRST ROW WITH TIES;


ROOT
PATH
OWNERSHIP


41203134
41203134,10151091,40856701,40109963
300

41328372
41328372,10250181,40001471,10159060,40001104,10351678
470

CHILD	PATH
41203134	41203134,10151091,40856701,40109963
41328372	41328372,10250181,40001104,10351678
41328372	41328372,10250181,40001471,10159060,40001104,10351678