|
View V_COMPLETE_EXT_MODULES
|
|
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
|
|
|
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;