 Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
    (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
  Values
+   ('concepts_list_t', 7, 'Primary Flag', 'String', 7);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('cdebrowser_csi_list_t', 5, 'Classification Scheme Version', 'Number', 3);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('derived_data_element_t', 2, 'Derivation Type Description', 'Struct', 2);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('derived_data_element_t', 8, 'DDE Preferred Name', 'Struct', 8);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('derived_data_element_t', 9, 'DDE Preferred Definition', 'Struct', 9);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('designations_list_t', 1, 'Alternate Name Context Name', 'String', 1);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('designations_list_t', 2, 'Alternate Name Context Version', 'Number', 2);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('designations_list_t', 3, 'Alternate Name', 'String', 3);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('designations_list_t', 4, 'Alternate Name Type', 'String', 4);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
+   ('cdebrowser_rd_list_t', 1, 'Document Name', 'String', 2);
+Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
+   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
+ Values
    ('cdebrowser_rd_list_t', 2, 'Document Organization', 'String', 4);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('cdebrowser_csi_list_t', 5, 'Classification Scheme Version', 'Number', 3);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('derived_data_element_t', 2, 'Derivation Type Description', 'Struct', 2);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('derived_data_element_t', 8, 'DDE Preferred Name', 'Struct', 8);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('derived_data_element_t', 9, 'DDE Preferred Definition', 'Struct', 9);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('designations_list_t', 1, 'Alternate Name Context Name', 'String', 1);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('designations_list_t', 2, 'Alternate Name Context Version', 'Number', 2);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('designations_list_t', 3, 'Alternate Name', 'String', 3);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('designations_list_t', 4, 'Alternate Name Type', 'String', 4);
-Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
-   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
- Values
-   ('cdebrowser_rd_list_t', 1, 'Document Name', 'String', 2);
 Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
    (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
  Values

   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
 Values
   ('valid_value_list_t', 1, 'Valid Values', 'String', 1);
Insert into SBREXT.CUSTOM_DOWNLOAD_TYPES
   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
 Values
   ('concepts_list_t', 7, 'Primary Flag', 'String', 7);

/* Formatted on 5/11/2011 4:39:16 PM (QP5 v5.115.810.9015) */
CREATE OR REPLACE FORCE VIEW SBREXT.cde_excel_generator_view (

CREATE OR REPLACE TYPE "SBREXT"."VALID_VALUE_LIST_T" AS TABLE OF VALID_VALUE_T;
/

--GRANT EXECUTE, DEBUG ON SBREXT.VALID_VALUE_LIST_T TO CDECURATE;

--GRANT EXECUTE, DEBUG ON SBREXT.VALID_VALUE_LIST_T TO DER_USER;

--GRANT EXECUTE, DEBUG ON SBREXT.VALID_VALUE_LIST_T TO SBR WITH GRANT OPTION;

DROP TABLE SBREXT.CUSTOM_DOWNLOAD_TYPES CASCADE CONSTRAINTS;

