Fórum sql #281511

Olá pessoal, o sql abaixo está retornando o seguinte erro: ORA-01427: single-row subquery returns more than one row, alguém sabe o significado??
O erro ocorreu a partir do momento que inseri esta parte dó código:
[i:05e42d782f] , (SELECT Numero
FROM ReferenciaNumeracao
WHERE NVL(cTitulo, NULL) = 200
AND cLargura = pec.cLargura
AND cGrade = pec.cGrade
AND cTipoFt = pec.cTipoFt
AND cRefer = pec.cRefer) Numero[/i:05e42d782f]

SELECT ped.cPessoaJur || ´ ´ || pes.Fantasia Cliente
, ped.IDLote
, pec.cRefer
, rec.Descricao
, ped.DataEntrega
, ped.Pedido
, ref.dRefer
[i:05e42d782f] , (SELECT Numero
FROM ReferenciaNumeracao
WHERE NVL(cTitulo, NULL) = 200
AND cLargura = pec.cLargura
AND cGrade = pec.cGrade
AND cTipoFt = pec.cTipoFt
AND cRefer = pec.cRefer) Numero[/i:05e42d782f]
, (SELECT TextoTecnico
FROM v_FichaTecnica
WHERE NVL(cTitulo, NULL) = 32250
AND SeqCombFt = pec.SeqCombFt
AND cLargura = pec.cLargura
AND cGrade = pec.cGrade
AND cTipoFt = pec.cTipoFt
AND cRefer = pec.cRefer) StockNumber
, pec.cTipoFt
, ref.cConstrucao
, tgr.Pares
, tgr.Pares / pec.QuantGrades3 ParesConv
, tgr.cUnidade
, tgr.NumGrade
, (SELECT Data
FROM Retornos
WHERE cFase = 1
AND Talao = tal.Talao) Corte
, (SELECT Data
FROM Retornos
WHERE cFase = 5
AND Talao = tal.Talao) Costura
, (SELECT Data
FROM Retornos
WHERE cFase = 8
AND Talao = tal.Talao) Montagem
FROM TalaoGrades tgr
, Taloes tal
, ReferenciaComb rec
, Referencias ref
, PedidoGrades peg
, PesJurFis pes
, PedidoCombs pec
, FasesFt f
, Pedidos ped
WHERE tgr.NumGrade = peg.NumGrade
AND tgr.Talao = tal.Talao
AND tal.InternoPedComb = pec.InternoPedComb
AND rec.cLargura = pec.cLargura
AND rec.cGrade = pec.cGrade
AND rec.SeqCombFt = pec.SeqCombFt
AND rec.CTipoFt = pec.CTipoFt
AND rec.cRefer = pec.CRefer
AND ref.CTipoFt = pec.CTipoFt
AND ref.CRefer = pec.CRefer
AND peg.InternoPedComb = pec.InternoPedComb
AND pes.cPessoaJur = ped.cPessoaJur
AND pec.Pedido = ped.Pedido
AND (:p_SoAberto = ´N´
OR NOT EXISTS (SELECT 1
FROM Retornos
WHERE cFase = f.cFaseFim
AND Talao = tal.Talao))
AND ped.DataPedido >= :p_Inicio
AND (ped.CarimboCorrugado = :p_CFaseFT
OR :p_CFaseFt = -1)
AND (ped.cPessoaJur = :p_CCliente
OR :p_CCliente = -1)
AND (ped.IdLote = :p_IdLote
OR :p_IdLote IS NULL)
AND f.cFaseFt = ped.CarimboCorrugado
AND ped.cTipoPedido = 7
ORDER BY ped.cPessoaJur || ´ ´ || pes.Fantasia
, ped.IDLote
, pec.CRefer
, ped.DataEntrega
, ped.Pedido
, rec.Descricao