query traza

SELECT sgui.cprefijo || '-' || sgui.nguia AS GUIA,
          SDIN.NANIO
       || '-0'
       || SDIN.CADUANA
       || '-'
       || SDIN.CTPDCTO
       || '-'
       || SDIN.NDCTO
       || '-'
       || SDIN.DLETRA
          DOCUMENTO,
       TRUNC (SDIN.FHINGRESO) INGRESO,
       TRUNC (SDEG.FEGRESO) EGRESO,
       LTER.CODIGO codigo_termometro,
       LTER.RANGO_TEMP rango_termometro,
       SDIN.SDCTOING,
       SGUI.SGUIA,
       IUIN.SPOSICION,
       LPOS.DPOSICION,
       sddt.Scli_factura scli_responsable,
       FSXC.CORREO,
       ccli.dnomyap
       --,TRUNC(SDEG.FEGRESO) - TRUNC(SDIN.FHINGRESO)+1
  FROM LTER,
       LOCT,
       LPOS,
       IUIN,
       SING,
       SGUI,
       SDIN,
       SEGR,
       SDEG,
       FSXC,
       ccli,
       sddt,
       sdes
 WHERE     LOCT.SPOSICION = LPOS.SPOSICION
       AND LTER.MHABILITADO =1
       AND LTER.ID_TERMOMETRO = LOCT.ID_TERMOMETRO
       AND LPOS.SPOSICION = IUIN.SPOSICION
       AND IUIN.SDCTOING = SING.SDCTOING
       AND IUIN.SGUIA = SING.SGUIA
       AND SING.SGUIA = SGUI.SGUIA
       AND SING.SDCTOING = SDIN.SDCTOING
       AND SING.SGUIA = SDES.SGUIA
       AND SING.SDCTOING = SDES.SDCTOING
       AND SDES.SDCTODEST = SDDT.SDCTODEST
       AND SDES.SDCTODEST = SEGR.SDCTODEST
       AND SING.SGUIA = SEGR.SGUIA
       AND SING.SDCTOING = SEGR.SDCTOING
       AND SEGR.SDCTOEGRE = SDEG.SDCTOEGRE
       AND SDDT.SCLI_FACTURA = FSXC.scli
       AND FSXC.CSERVICIO = 201
       AND ccli.scli = SDDT.SCLI_FACTURA
      AND FSXC.CORREO IS NOT NULL
       --AND trunc(sdeg.fegreso) = trunc(SYSDATE) - 1
        AND sgui.nguia = 'XXX-50475261'
       ORDER BY FSXC.scli, SGUI.SGUIA ASC