 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;
 

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);

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