 
 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",

   (TYPE_NAME, COLUMN_INDEX, DISPLAY_NAME, DISPLAY_TYPE, DISPLAY_COLUMN_INDEX)
 Values
   ('concepts_list_t', 7, 'Primary Flag', 'String', 7);



--DROP VIEW SBREXT.CDE_EXCEL_GENERATOR_VIEW;

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


GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON SBREXT.CDE_EXCEL_GENERATOR_VIEW TO SBR WITH GRANT OPTION;

/* Formatted on 5/11/2011 4:40:12 PM (QP5 v5.115.810.9015) */
CREATE OR REPLACE FORCE VIEW SBREXT.dec_excel_generator_view (
   dec_idseq,
