Dinamometria POSDIN

DROP VIEW DINAMOMETRO_POSDIN;

/* Formatted on 09/10/2013 14:52:53 (QP5 v5.114.809.3010) */
CREATE OR REPLACE FORCE VIEW DINAMOMETRO_POSDIN
(
   NOMBREPOZO,
   FECHA,
   OBSERVACIONES_1,
   OBSERVACIONES_2,
   EQUIPO,
   GOLPESPORMINUTOS,
   CARRERANOMINAL,
   RELACIONTRANSMISION,
   NUEVOCONTRAPESO,
   NUEVOCONTRAPESOAUXILIAR,
   BOMBA,
   DIAMETRODELPISTON,
   CAUDALBRUTO,
   DESCRIPCIONMOTOR,
   POTENCIANOMINALMOTOR,
   REVOLUCIONESPORMINUTO,
   DIAMETROPOLEA,
   PROFUNDIDADDEBOMBA,
   NIVELDINAMICO,
   NIVELCORREAPORMCCOY,
   CARRERABRUTAFONDO,
   PRESIONDINAMICAFONDO,
   NIVELDINENSAYO,
   CARRERANETAFONDO,
   CAUDALBRUTOSUPERFICIE,
   PORCENTAJELLENADO,
   CARGAMAXIMASUPERFICIE,
   PORCENTAJECARGA,
   EFICIENCIATORSIONAL,
   REGIMENCAJAEXISTENTE,
   PRESIONDELINEA,
   PRESIONDECASING,
   NOMCONTRAPESOPRINCIPAL,
   NOMCONTRAPESOSECUNDARIO,
   DISTCONTRAPESOPRINCIPAL,
   DISTCONTRAPESOSECUNDARIO,
   DIAMETROVARILLA_1,
   DIAMETROVARILLA_2,
   DIAMETROVARILLA_3,
   DIAMETROVARILLA_4,
   ID_ENSAYO
)
AS
     SELECT   '' AS nombrepozo,
              '' AS fecha,
              '' AS observaciones_1,
              '' AS observaciones_2,
              '' AS equipo,
             '' AS golpesporminutos,
              1 AS carreranominal,
              1 AS relaciontransmision,
              1 AS nuevocontrapeso,
              1 AS nuevocontrapesoauxiliar,
              1 AS bomba,
              1 AS diametrodelpiston,
              1 AS caudalbruto,
              1 AS descripcionmotor,
              1 AS potencianominalmotor,
              1 AS revolucionesporminuto,
              1 AS diametropolea,
              1 AS profundidaddebomba,
              1 AS niveldinamico,
              1 AS nivelcorreapormccoy,
              1 AS carrerabrutafondo,
              1 AS presiondinamicafondo,
              1 AS niveldinensayo,
              1 AS carreranetafondo,
             1 AS caudalbrutosuperficie,
              1 AS porcentajellenado,
              1 AS cargamaximasuperficie,
             1 AS porcentajecarga,
              1 AS eficienciatorsional,
              1 AS regimencajaexistente,
              1 AS presiondelinea,
              1 AS presiondecasing,
              1 AS nomcontrapesoprincipal,
              1 AS nomcontrapesosecundario,
              1 AS distcontrapesoprincipal,
             1 AS distcontrapesosecundario,
              1 AS diametrovarilla_1,
              1 AS diametrovarilla_2,
             1 AS diametrovarilla_3,
              1 AS diametrovarilla_4,
              1 AS id_ensayo
       FROM               dual;