SELECT * FROM
(
SELECT GE.EMP_NOMBRE AS EMP_GERENTE, CA.CAN_DESCRI AS TIPO_VENDEDOR, EE.EMP_CLAVE, EE.COMPANIA, EE.EMP_GPID,
EE.EMP_NOMBRE, ' ' || VV.NOMBRE AS COLUMNA, 0 AS FACTOR, VV.VISIBLE_ORDEN, PD.MONTO, TB.NOMBRE AS TIPOBONO
FROM DCC_PLANILLA_DETALLE PD
  INNER JOIN DCC_VARIABLE VV ON PD.VARIABLE = VV.VARIABLE
  INNER JOIN DCC_EMPLEADO EE ON PD.EMP_CLAVE = EE.EMP_CLAVE AND PD.SUCURSAL_CLAVE = EE.SUC_CLAVE
  INNER JOIN DC1_TAS_RUTA RU ON EE.RUT_CLAVE = RU.RUT_cLAVE AND EE.SUC_CLAVE = RU.SUC_CLAVE
  INNER JOIN DCC_TAS_CANAL CA ON RU.CAN_CLAVE = CA.CAN_CLAVE
  LEFT OUTER JOIN DCC_AGRUPACION_RUTA AR ON EE.SUC_CLAVE = AR.SUC_CLAVE AND EE.RUT_CLAVE = AR.RUT_CLAVE
  LEFT OUTER JOIN DCC_EMPLEADO GE ON AR.RUT_CLAVE_GEVE = GE.RUT_CLAVE AND AR.SUC_CLAVE = GE.SUC_CLAVE
  LEFT OUTER JOIN DCC_TIPOBONO_BONO TBB ON AR.TIPOBONO = TBB.TIPOBONO
  LEFT OUTER JOIN DCC_TIPOBONO TB ON TBB.TIPOBONO=TB.TIPOBONO
WHERE PD.FECHA_INICIAL = TO_DATE('2019-05-31','YYYY-MM-DD')
  AND PD.SUCURSAL_CLAVE = 3300
  AND PD.CALENDARIO = 10
  AND VV.VISIBLE = 1
UNION ALL
SELECT GE.EMP_NOMBRE AS EMP_GERENTE, CA.CAN_DESCRI AS TIPO_VENDEDOR, EE.EMP_CLAVE, EE.COMPANIA, EE.EMP_GPID,
EE.EMP_NOMBRE, '-' || BB.CODIGO AS COLUMNA, 1 AS FACTOR, 10000 + BB.BONO AS VISIBLE_ORDEN, PD.MONTO, TB.NOMBRE AS TIPOBONO
FROM DCC_PLANILLA_BONO PD
  INNER JOIN DCC_BONO BB ON PD.BONO = BB.BONO
  INNER JOIN DCC_EMPLEADO EE ON PD.EMP_CLAVE = EE.EMP_CLAVE AND PD.SUCURSAL_CLAVE = EE.SUC_CLAVE
  INNER JOIN DC1_TAS_RUTA RU ON EE.RUT_CLAVE = RU.RUT_cLAVE AND EE.SUC_CLAVE = RU.SUC_CLAVE
  INNER JOIN DCC_TAS_CANAL CA ON RU.CAN_CLAVE = CA.CAN_CLAVE
  LEFT OUTER JOIN DCC_AGRUPACION_RUTA AR ON EE.SUC_CLAVE = AR.SUC_CLAVE AND EE.RUT_CLAVE = AR.RUT_CLAVE
  LEFT OUTER JOIN DCC_EMPLEADO GE ON AR.RUT_CLAVE_GEVE = GE.RUT_CLAVE AND AR.SUC_CLAVE = GE.SUC_CLAVE
  LEFT OUTER JOIN DCC_TIPOBONO_BONO TBB ON AR.TIPOBONO = TBB.TIPOBONO
  LEFT OUTER JOIN DCC_TIPOBONO TB ON TBB.TIPOBONO=TBB.TIPOBONO
WHERE PD.FECHA_INICIAL = TO_DATE('2019-05-31','YYYY-MM-DD')
  AND PD.SUCURSAL_CLAVE = 3300
  AND PD.CALENDARIO = 10
) DATOS
WHERE EMP_CLAVE=9873
ORDER BY TIPOBONO, VISIBLE_ORDEN ASC