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) 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

41328372
41328372,10250181,40001104

41328372
41328372,10250181,40001471,10159060,40001104


WITH path (root, path, parent, ownership) AS (
  SELECT child, TO_CHAR(child), parent, ownership
  FROM   p_c_rel
  WHERE  child IN (41203134, 41328372)
UNION ALL
  SELECT p.root, p.path || ',' || r.child, 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
300

41328372
41328372,10250181,40001471,10159060,40001104
470

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