SELECT
k
.EMPID,
p
.PDCID,
p
.PDCNOMPLAN,
k
.PERID,
k
.TESDOCNUMINTERNO,
c
.CLACTANODONOMBRE,
k
.CTACODIGO,
t
.CTANOMBRE,
k
.CDICODIGO,
(SELECT clactanodonombre
FROM
CONT_CLASIFICACONCEPTOS x
WHERE
x
.clactanivel1=c.clactanivel1 AND
x
.clactanivel2=c.clactanivel2 AND
x
.clactanivel3=c.clactanivel3 AND
x
.cdicodigo = 0 AND
x
.pdcid=c.PDCID) AS SubGrupo,
(SELECT
clactanodonombre
FROM CONT_CLASIFICACONCEPTOS x
WHERE x.clactanivel1=c.clactanivel1
AND x.clactanivel2=c.clactanivel2
AND x.clactanivel3=0
AND x.pdcid=c.pdcid) AS Grupo,
(
k.TESDOCMONTOLOCALDEBE) AS debe,(k.TESDOCMONTOLOCALHABER) AS haber
FROM
TEST_DETALLEDOC k , CONT_PLANCONCEPTOS p , CONT_CLASIFICACONCEPTOS c, CONT_CUENTAS t
WHERE k.CTACODIGO=t.CTACODIGO
AND k.CDICODIGO=c.CDICODIGO(+)
AND p.PDCID=c.PDCID
AND K.EMPID IN(1,99,100)
AND k.PERID =123
ORDER BY K.EMPID
SELECT
k
.EMPID,
p
.PDCID,
p
.PDCNOMPLAN,
k
.PERID,
k
.TESDOCNUMINTERNO,
c
.CLACTANODONOMBRE,
k
.CTACODIGO,
t
.CTANOMBRE,
k
.CDICODIGO,
(SELECT clactanodonombre
FROM
CONT_CLASIFICACONCEPTOS x
WHERE
x
.clactanivel1=c.clactanivel1 AND
x
.clactanivel2=c.clactanivel2 AND
x
.clactanivel3=c.clactanivel3 AND
x
.cdicodigo = 0 AND
x
.pdcid=c.PDCID) AS SubGrupo,
(SELECT
clactanodonombre
FROM CONT_CLASIFICACONCEPTOS x
WHERE x.clactanivel1=c.clactanivel1
AND x.clactanivel2=c.clactanivel2
AND x.clactanivel3=0
AND x.pdcid=c.pdcid) AS Grupo,
(
k.TESDOCMONTOLOCALDEBE) AS debe,(k.TESDOCMONTOLOCALHABER) AS haber
FROM
TEST_DETALLEDOC k , CONT_PLANCONCEPTOS p , CONT_CLASIFICACONCEPTOS c, CONT_CUENTAS t
WHERE k.CTACODIGO=t.CTACODIGO
AND k.CDICODIGO=c.CDICODIGO(+)
AND p.PDCID=c.PDCID
AND K.EMPID IN(1,99,100)
AND k.PERID =123
ORDER BY K.EMPID
The following error has occurred:
ORA-01427: single-row subquery returns more than one row