Following query results duplicate rows

Hello,

Following query results in duplicate row. what joins are missing?

SELECT
r.requisition_id,
NVL(TRIM(r.requisition_number), 'NULL') AS requisition_number,
CASE
WHEN dbms_lob.getlength(rt.external_qual) > 0
THEN rt.external_qual
ELSE TO_CLOB('NULL')
END AS external_qual,
CASE
WHEN dbms_lob.getlength(rt.internal_qual) > 0
THEN rt.internal_qual
ELSE TO_CLOB('NULL')
END AS internal_qual,
NVL(TRIM(j.information1), 'NULL') AS information1,

COALESCE((

    SELECT tl.description

    FROM irc_descriptions_b d,

         irc_desc_versions_b b,

         irc_desc_versions_tl tl

    WHERE d.description_id = b.description_id

      AND b.desc_version_id = tl.desc_version_id