Oracle 11g Release 2

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

create table pntos_vnta (pnto_vnta, crgo) as
select 12345 , 'CARGO ' || level
from dual
connect by level <= 3
3 rows affected

create table cargos (cargo) as
select 'CARGO ' || level
from dual
connect by level <= 3
3 rows affected

-- original, with extra ) removed
SELECT
    s.PNTO_VNTA,
    LISTAGG (g.CARGO, ', ') WITHIN GROUP (ORDER BY g.CARGO) OVER()  PRODUCTOS
FROM
    PNTOS_VNTA s,
    CARGOS g
WHERE
    s.crgo = g.CARGO
    AND s.PNTO_VNTA = 12345
    GROUP BY s.PNTO_VNTA,
    g.cargo
    ;


PNTO_VNTA
PRODUCTOS


12345
CARGO 1, CARGO 2, CARGO 3

12345
CARGO 1, CARGO 2, CARGO 3

12345
CARGO 1, CARGO 2, CARGO 3


SELECT
    s.PNTO_VNTA,
    LISTAGG (g.CARGO, ', ') WITHIN GROUP (ORDER BY g.CARGO) PRODUCTOS
FROM
    PNTOS_VNTA s,
    CARGOS g
WHERE
    s.crgo = g.CARGO
    AND s.PNTO_VNTA = 12345
    GROUP BY s.PNTO_VNTA
    ;


PNTO_VNTA
PRODUCTOS


12345
CARGO 1, CARGO 2, CARGO 3


SELECT
    s.PNTO_VNTA,
    LISTAGG (g.CARGO, ', ') WITHIN GROUP (ORDER BY g.CARGO) PRODUCTOS
FROM PNTOS_VNTA s
JOIN CARGOS g ON s.crgo = g.CARGO
WHERE s.PNTO_VNTA = 12345
GROUP BY s.PNTO_VNTA
;


PNTO_VNTA
PRODUCTOS


12345
CARGO 1, CARGO 2, CARGO 3


SELECT
    s.PNTO_VNTA,
    LISTAGG (s.CRGO, ', ') WITHIN GROUP (ORDER BY s.CRGO) PRODUCTOS
FROM PNTOS_VNTA s
WHERE s.PNTO_VNTA = 12345
GROUP BY s.PNTO_VNTA
;


PNTO_VNTA
PRODUCTOS


12345
CARGO 1, CARGO 2, CARGO 3

PNTO_VNTA	PRODUCTOS
12345	CARGO 1, CARGO 2, CARGO 3
12345	CARGO 1, CARGO 2, CARGO 3
12345	CARGO 1, CARGO 2, CARGO 3