asdfasa

SELECT
          AG.INDICE_AGENDAMIENTO
          ,AG.ATENDING_DOCTOR_ID
          ,REPLACE(AG.ATENDING_DOCTOR,'^','') AS ATENDING_DOCTOR
          ,AG.REFERING_DOCTOR_ID
          ,AG.REFERING_DOCTOR
          ,AG.CONSULTING_DOCTOR_ID
          ,AG.CONSULTING_DOCTOR
          ,TE.DESCRIPCION AS ORDER_STATUS
          ,AG.UNIVERSAL_SERVICEID_ID
          ,AG.UNIVERSAL_SERVICEID
          ,PR.DESCRIPCION AS PRIORITY
          ,AG.ACCESSION_NUMBER
          ,AG.STUDY_ID
          ,AG.MODALITY
          ,TO_CHAR(FECHA_HORA,'DD/MM/YYYY HH24:MI') AS FECHA_HORA
          ,AG.INDICE_AETITLE
          ,AG.STUDY_INSTANCE_UID
          ,PA.NUM_REGISTRO_MEDICO PATIENT_ID
          ,PA.APELLIDO_P || '^' || PA.NOMBRES PATIENT_NAME
          ,PA.SEXO PATIENT_SEX
          ,PA.RUT PATIENT_RUT
          ,TO_CHAR(PATIENT_BIRTHDATETIME,'DD/MM/YYYY') AS PATIENT_BIRTHDATETIME
          ,AG.COMMENTS
          ,AC.INSTITUTIONAL_DEPARTAMENT_NAME AS INDICE_AREA_CENTRO
          ,AGP.DESCRIPCION AS INDICE_PABELLON
          ,PREV.DESCRIPCION_PREVISION AS INDICE_PREVISION
          ,AG.VALOR
          ,AG.ENTREGADO
          ,TPAG.DESCRIPCION_PAGO AS INDICE_PAGO
          ,BCO.DESCRIPCION_BANCO AS INDICE_BANCO
          ,AG.NUMERO_DOCUMENTO
          ,TO_CHAR(AG.FECHA_PAGO,'DD/MM/YYYY') AS FECHA_PAGO
          ,AG.NUMERO_BOLETA
          ,EMP.DESCRIPCION AS INDICE_EMPRESA
          ,AG.AG_ASIGNACION
          ,AG.INDICE_RESPONSABLE
          ,(CASE WHEN AG.CONTRASTE = 0 THEN 'No' ELSE 'Si' END) AS CONTRASTE
          ,(CASE WHEN AG.ANESTESIA = 0 THEN 'No' ELSE 'Si' END) AS ANESTESIA
          ,AG.TIPO_PROCEDENCIA
          ,AG.INDICE_PROCEDENCIA
          ,'' AS PROCEDENCIA
        FROM AGENDAMIENTO AG
        LEFT JOIN TRADUCCION_ESTADO TE ON AG.ORDER_STATUS = TE.ESTADO_COD AND AG.INDICE_AREA_CENTRO = TE.INDICE_AREA_CENTRO
        LEFT JOIN PRIORIDAD PR ON AG.PRIORITY = PR.INDICE_PRIORIDAD AND AG.INDICE_AREA_CENTRO = PR.AREA_CENTRO
        LEFT JOIN PREVISION PREV ON AG.INDICE_PREVISION = PREV.INDICE_PREVISION
        LEFT JOIN BANCO BCO ON AG.INDICE_BANCO = BCO.INDICE_BANCO
        LEFT JOIN EMPRESAS EMP ON AG.INDICE_EMPRESA = EMP.INDICE_EMPRESA
        LEFT JOIN TIPO_PAGO TPAG ON AG.INDICE_PAGO = TPAG.INDICE_PAGO
        LEFT JOIN AREAS_CENTROS AC ON AG.INDICE_AREA_CENTRO = AC.INDICE_AREA_CENTRO
        LEFT JOIN AG_PABELLONES AGP ON AG.INDICE_PABELLON = AGP.ID
        INNER JOIN PACIENTES PA ON AG.PATIENT_ID = PA.NUM_REGISTRO_MEDICO

        WHERE INDICE_AGENDAMIENTO =  $id