in an effort to try and understand what you require, I have attempted to simplify your query and just return relevant columns....based on code below...what results do you want?

SELECT DISTINCT

GLPSI.IDN AS GLMSO_GLPSI_IDN,

GLMSO.IDN AS GLMSO_IDN,

GLMSO.KMSO,

GLMSO.FAB,

GLMSO.DFINV,

GLMSO.DFINA,

GLCTA.KCTR,

GLCTA.DCAT

FROM GLMSO

INNER JOIN GLARA ON GLARA.IDN = GLMSO.IDN

AND GLARA.KARA = GLMSO.KARA

INNER JOIN GLPSI ON GLPSI.IDN = GLARA.IDN

AND GLPSI.KPSI = GLARA.KPSI

INNER JOIN GLCMS ON GLCMS.IDN = GLMSO.IDN

AND GLCMS.KMSO = GLMSO.KMSO

INNER JOIN GLCVA ON GLCMS.IDN = GLCVA.IDN

AND GLCMS.KCVA = GLCVA.KCVA

INNER JOIN GLCTR ON GLCVA.IDN = GLCTR.IDN

AND GLCVA.KCTR = GLCTR.KCTR

INNER JOIN GLCTA ON GLMSO.IDN = GLCTA.IDN

AND GLMSO.KARA = GLCTA.KARA

WHERE ( GLPSI.IDN = '0099' )

AND ( GLMSO.FAB = 'A' )