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;