| index

View V_COMPLETE_EXT_MODULES

Columns

Name | Type | Optional | Default | Comments
FIELD_1 | VARCHAR2(240) | Y |  |
FIELD_2 | VARCHAR2(240) | Y |  |
FIELD_3 | VARCHAR2(240) | Y |  |
FIELD_4 | VARCHAR2(240) | Y |  |
FIELD_5 | VARCHAR2(240) | Y |  |
FIELD_6 | VARCHAR2(240) | Y |  |
FIELD_7 | VARCHAR2(240) | Y |  |
FIELD_8 | VARCHAR2(240) | Y |  |
FIELD_9 | VARCHAR2(240) | Y |  |
FIELD_10 | VARCHAR2(240) | Y |  |
FIELD_11 | VARCHAR2(240) | Y |  |
FIELD_12 | VARCHAR2(240) | Y |  |
FIELD_13 | VARCHAR2(240) | Y |  |
FIELD_14 | VARCHAR2(240) | Y |  |
FIELD_15 | VARCHAR2(240) | Y |  |
FIELD_16 | VARCHAR2(240) | Y |  |
FIELD_17 | VARCHAR2(240) | Y |  |
FIELD_18 | VARCHAR2(240) | Y |  |
FIELD_19 | VARCHAR2(240) | Y |  |
FIELD_20 | VARCHAR2(240) | Y |  |
FIELD_21 | VARCHAR2(240) | Y |  |
FIELD_22 | VARCHAR2(240) | Y |  |
FIELD_23 | VARCHAR2(240) | Y |  |
FIELD_24 | VARCHAR2(240) | Y |  |
FIELD_25 | VARCHAR2(240) | Y |  |
FIELD_26 | VARCHAR2(240) | Y |  |
FIELD_27 | VARCHAR2(240) | Y |  |
FIELD_28 | VARCHAR2(240) | Y |  |
FIELD_29 | VARCHAR2(240) | Y |  |
FIELD_30 | VARCHAR2(240) | Y |  |
FIELD_31 | VARCHAR2(240) | Y |  |
FIELD_32 | VARCHAR2(240) | Y |  |
FIELD_33 | VARCHAR2(240) | Y |  |
FIELD_34 | VARCHAR2(240) | Y |  |
FIELD_35 | VARCHAR2(240) | Y |  |
FIELD_36 | VARCHAR2(240) | Y |  |
FIELD_37 | VARCHAR2(240) | Y |  |
FIELD_38 | VARCHAR2(240) | Y |  |
FIELD_39 | VARCHAR2(240) | Y |  |
FIELD_40 | VARCHAR2(240) | Y |  |

SQL

    CREATE OR REPLACE VIEW V_COMPLETE_EXT_MODULES AS
    SELECT "FIELD_1","FIELD_2","FIELD_3","FIELD_4","FIELD_5","FIELD_6","FIELD_7","FIELD_8","FIELD_9","FIELD_10","FIELD_11","FIELD_12","FIELD_13","FIELD_14","FIELD_15","FIELD_16","FIELD_17","FIELD_18","FIELD_19","FIELD_20","FIELD_21","FIELD_22","FIELD_23","FIELD_24","FIELD_25","FIELD_26","FIELD_27","FIELD_28","FIELD_29","FIELD_30","FIELD_31","FIELD_32","FIELD_33","FIELD_34","FIELD_35","FIELD_36","FIELD_37","FIELD_38","FIELD_39","FIELD_40"
      FROM ext_modules t
     WHERE field_1 IS NOT NULL
       AND field_2 IS NOT NULL
       AND field_3 IS NOT NULL
       AND field_4 IS NOT NULL
       AND field_5 IS NOT NULL
       AND field_6 IS NOT NULL
       AND field_7 IS NOT NULL
       AND field_8 IS NOT NULL
       AND field_9 IS NOT NULL
       AND field_10 IS NOT NULL
       AND field_11 IS NOT NULL
       AND field_12 IS NOT NULL
       AND field_13 IS NOT NULL
       AND field_14 IS NOT NULL
       AND field_17 IS NOT NULL
       AND field_18 IS NOT NULL
       AND field_19 IS NOT NULL
       AND field_20 IS NOT NULL
       AND field_21 IS NOT NULL
       AND field_22 IS NOT NULL
       AND field_25 IS NOT NULL
       AND field_26 IS NOT NULL
       AND field_27 IS NOT NULL
       AND field_28 IS NOT NULL
       AND field_30 IS NOT NULL;