SELECT /*+ all_rows */
SUM(q.qtp_pars)
FROM qtd_prg q
,ped p
,ite i
WHERE p.ped_tipo IN ('PG', 'EX', 'PP')
AND p.ped_nmro = n_ped_nmro
AND q.ped_nmro = n_ped_nmro
AND i.ped_nmro = n_ped_nmro
AND i.ite_seqn = n_ite_seqn
AND i.ite_seqn = q.ite_seqn
AND q.qtp_pars > 0
GROUP BY q.ped_nmro
,q.ite_seqn;
esse cara preferiu fazer 3 joins com o parâmetro do que simplesmente fazer entre os campos das tabelas eaiuehaiuehaiuehaiueha