 
 GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON SBREXT.DEC_EXCEL_GENERATOR_VIEW TO SBR WITH GRANT OPTION;
 
---DROP VIEW SBREXT.VD_EXCEL_GENERATOR_VIEW;
-
 /* Formatted on 5/11/2011 4:40:49 PM (QP5 v5.115.810.9015) */
-CREATE OR REPLACE FORCE VIEW vd_excel_generator_view (
+CREATE OR REPLACE FORCE VIEW SBREXT.vd_excel_generator_view (
    vd_idseq,
    "VD Public ID",
    "VD Short Name",

update SBREXT.TOOL_OPTIONS_EXT t set VALUE =    ('CDE_IDSEQ,DEC_IDSEQ,VD_IDSEQ,Conceptual Domain Public ID,Conceptual Domain Short Name,Conceptual Domain Version,Conceptual Domain Context Name,Classification Scheme Public ID,DDE Methods,Representation Concept Origin,Value Domain Concept Origin,Property Concept Origin,Object Class Concept Origin,Derivation Type Description,DDE Preferred Name,DDE Preferred Definition,Document Organization')
where t.tool_name = 'CURATION' and T.PROPERTY = 'CUSTOM.COLUMN.EXCLUDED';

--DROP TABLE SBREXT.CUSTOM_DOWNLOAD_TYPES CASCADE CONSTRAINTS;

CREATE TABLE 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 (
