4 Replies Latest reply on Jul 20, 2015 7:17 PM by Vadim Tropashko-Oracle

    query taking lot of time to execute

    user1014019

      Hi Sir,

       

      The below query is taking lot of time to execute sir

      Code: [Select all] [Show/ hide]

       

      SELECT to_date(WEEk,'MON-dd-yyyy') Week,TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,Sum(to_number(decode(RESOURCE_NB,'-',0,RESOURCE_NB)))  as Resource_NB FROM hrbostf.FACT_STF_NEEDS WHERE week =  to_char(to_date('07/13/2015','mm/dd/yyyy')+3,'MON-DD-YYYY') and TAGS_BUSINESS_UNIT in ('NA HTEC','NA Operations','NA US OPERATION','NA IDS','NA EUC','NA CPRD','NA MALS') --  and (TAGS_BUSINESS_UNIT = @variable('Enter Business Unit') or @variable('Enter Business Unit') = @variable('Enter Business Unit')) and upper (CREATOR_FULL_NAME) not like '%BALBOSA%GLORIA%' and close_date = '-' and state <> 'Inactive' and project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-1 group by TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,to_date(WEEk,'MON-dd-yyyy') UNION SELECT to_date(WEEk,'MON-dd-yyyy'),TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,Sum(to_number(decode(RESOURCE_NB,'-',0,RESOURCE_NB)))  as Resource_NB FROM hrbostf.FACT_STF_NEEDS WHERE week =  to_char(to_date('07/13/2015','mm/dd/yyyy')+3-7,'MON-DD-YYYY') and TAGS_BUSINESS_UNIT in  ('NA HTEC','NA Operations','NA US OPERATION','NA IDS','NA EUC','NA CPRD','NA MALS') --  and (TAGS_BUSINESS_UNIT = @variable('Enter Business Unit') or @variable('Enter Business Unit') = @variable('Enter Business Unit')) and upper (CREATOR_FULL_NAME) not like '%BALBOSA%GLORIA%' and close_date = '-' and state <> 'Inactive' and project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-8 group by TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,to_date(WEEk,'MON-dd-yyyy') UNION SELECT to_date(WEEk,'MON-dd-yyyy'),TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,Sum(to_number(decode(RESOURCE_NB,'-',0,RESOURCE_NB)))  as Resource_NB FROM hrbostf.FACT_STF_NEEDS WHERE week =  to_char(to_date('07/13/2015','mm/dd/yyyy')+3-14,'MON-DD-YYYY') and TAGS_BUSINESS_UNIT in   ('NA HTEC','NA Operations','NA US OPERATION','NA IDS','NA EUC','NA CPRD','NA MALS') --  and (TAGS_BUSINESS_UNIT = @variable('Enter Business Unit') or @variable('Enter Business Unit') = @variable('Enter Business Unit')) and upper (CREATOR_FULL_NAME) not like '%BALBOSA%GLORIA%' and close_date = '-' and state <> 'Inactive' and project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-15 group by TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,to_date(WEEk,'MON-dd-yyyy')

      The query is same for each union operator except for two difference

       

      The first difference is filter on week column is changing whereas the second difference is project_start_date for each union operator keeps on changing.

       

      I can implement week column by using IN Operator that would help me write multiple union operator but my project_start_date also changes.

       

      How I should implement technically week and project_start_date so that query data after changing should give me same results as it is right now giving data.

       

      Appreciate your help sir.

        • 1. Re: query taking lot of time to execute
          2683628

          Hi

           

          Can you please update the questoin with the following:

          - Version of Oracle

          - Table definitions

          - Any indezes

          - SQL

          - Results of explain plan

          • 2. Re: query taking lot of time to execute
            user1014019

            The below is the execution plan of the query sir

             

             

            Plan hash value: 2188394823    ----------------------------------------------------------------------------------------------------  | Id  | Operation                      | Name              | Rows  | Bytes | Cost (%CPU)| Time     |  ----------------------------------------------------------------------------------------------------  |   0 | SELECT STATEMENT               |                   |   119 | 10948 |  2832K (99)| 09:26:30 |  |   1 |  SORT UNIQUE                   |                   |   119 | 10948 |  2832K (99)| 09:26:30 |  |   2 |   UNION-ALL                    |                   |       |       |            |          |  |   3 |    HASH GROUP BY               |                   |     3 |   276 | 50756   (1)| 00:10:10 |  |*  4 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     3 |   276 | 50754   (1)| 00:10:10 |  |*  5 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |   6 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*  7 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*  8 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |   9 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 10 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 11 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  12 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 13 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 14 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  15 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 16 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 17 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  18 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 19 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 20 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  21 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 22 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 23 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  24 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 25 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 26 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  27 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 28 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 29 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  30 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 31 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 32 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  33 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 34 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 35 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  36 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 37 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 38 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  39 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 40 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 41 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  42 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 43 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 44 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  45 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 46 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 47 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  48 |    HASH GROUP BY               |                   |     7 |   644 | 96580   (1)| 00:19:19 |  |* 49 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     7 |   644 | 96578   (1)| 00:19:19 |  |* 50 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 49319 |       | 47563   (1)| 00:09:31 |  |  51 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 52 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 53 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  54 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 55 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 56 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  57 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 58 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 59 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  60 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 61 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 62 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  63 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 64 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 65 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  66 |    HASH GROUP BY               |                   |     7 |   644 | 96580   (1)| 00:19:19 |  |* 67 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     7 |   644 | 96578   (1)| 00:19:19 |  |* 68 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 49319 |       | 47563   (1)| 00:09:31 |  |  69 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 70 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 71 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  72 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 73 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 74 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  75 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 76 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 77 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  78 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 79 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 80 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  81 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 82 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 83 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  84 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 85 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 86 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  87 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 88 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 89 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  90 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 91 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 92 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  93 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 94 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 95 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  96 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |* 97 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |* 98 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  |  99 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*100 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*101 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 102 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*103 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*104 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 105 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*106 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*107 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 108 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*109 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*110 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 111 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*112 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*113 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 114 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*115 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*116 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 117 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*118 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*119 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 120 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*121 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*122 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 123 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*124 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*125 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 126 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*127 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*128 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 129 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*130 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*131 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 132 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*133 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*134 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 135 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*136 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*137 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 138 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*139 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*140 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 141 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*142 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*143 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 144 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*145 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*146 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 147 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*148 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*149 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 150 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*151 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*152 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 153 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*154 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*155 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 156 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*157 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*158 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 159 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*160 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*161 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  | 162 |    HASH GROUP BY               |                   |     2 |   184 | 50756   (1)| 00:10:10 |  |*163 |     TABLE ACCESS BY INDEX ROWID| FACT_STF_NEEDS    |     2 |   184 | 50754   (1)| 00:10:10 |  |*164 |      INDEX SKIP SCAN           | IND_FACT_STF_NEED | 18095 |       | 32771   (1)| 00:06:34 |  ----------------------------------------------------------------------------------------------------    Predicate Information (identified by operation id):  ---------------------------------------------------    4 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-07-15  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  5 - access("WEEK"='JUL-16-2015')  filter("WEEK"='JUL-16-2015')  7 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-07-08  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  8 - access("WEEK"='JUL-09-2015')  filter("WEEK"='JUL-09-2015')  10 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-07-01  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  11 - access("WEEK"='JUL-02-2015')  filter("WEEK"='JUL-02-2015')  13 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-06-24  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  14 - access("WEEK"='JUN-25-2015')  filter("WEEK"='JUN-25-2015')  16 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-06-17  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  17 - access("WEEK"='JUN-18-2015')  filter("WEEK"='JUN-18-2015')  19 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-06-10  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  20 - access("WEEK"='JUN-11-2015')  filter("WEEK"='JUN-11-2015')  22 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-06-03  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  23 - access("WEEK"='JUN-04-2015')  filter("WEEK"='JUN-04-2015')  25 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-05-27  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  26 - access("WEEK"='MAY-28-2015')  filter("WEEK"='MAY-28-2015')  28 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-05-20  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  29 - access("WEEK"='MAY-21-2015')  filter("WEEK"='MAY-21-2015')  31 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-05-13  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  32 - access("WEEK"='MAY-14-2015')  filter("WEEK"='MAY-14-2015')  34 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-05-06  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  35 - access("WEEK"='MAY-07-2015')  filter("WEEK"='MAY-07-2015')  37 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-04-29  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  38 - access("WEEK"='APR-30-2015')  filter("WEEK"='APR-30-2015')  40 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-04-22  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  41 - access("WEEK"='APR-23-2015')  filter("WEEK"='APR-23-2015')  43 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-04-15  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  44 - access("WEEK"='APR-16-2015')  filter("WEEK"='APR-16-2015')  46 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-04-08  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  47 - access("WEEK"='APR-09-2015')  filter("WEEK"='APR-09-2015')  49 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-04-01  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  50 - access("WEEK"='APR-02-2015')  filter("WEEK"='APR-02-2015')  52 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-03-25  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  53 - access("WEEK"='MAR-26-2015')  filter("WEEK"='MAR-26-2015')  55 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-03-18  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  56 - access("WEEK"='MAR-19-2015')  filter("WEEK"='MAR-19-2015')  58 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-03-11  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  59 - access("WEEK"='MAR-12-2015')  filter("WEEK"='MAR-12-2015')  61 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-03-04  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  62 - access("WEEK"='MAR-05-2015')  filter("WEEK"='MAR-05-2015')  64 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-03-04  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  65 - access("WEEK"='MAR-05-2015')  filter("WEEK"='MAR-05-2015')  67 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-02-25  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  68 - access("WEEK"='FEB-26-2015')  filter("WEEK"='FEB-26-2015')  70 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-02-18  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  71 - access("WEEK"='FEB-19-2015')  filter("WEEK"='FEB-19-2015')  73 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-02-11  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  74 - access("WEEK"='FEB-12-2015')  filter("WEEK"='FEB-12-2015')  76 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-02-04  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  77 - access("WEEK"='FEB-05-2015')  filter("WEEK"='FEB-05-2015')  79 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-02-04  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  80 - access("WEEK"='FEB-05-2015')  filter("WEEK"='FEB-05-2015')  82 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-01-28  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  83 - access("WEEK"='JAN-29-2015')  filter("WEEK"='JAN-29-2015')  85 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-01-21  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  86 - access("WEEK"='JAN-22-2015')  filter("WEEK"='JAN-22-2015')  88 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-01-14  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  89 - access("WEEK"='JAN-15-2015')  filter("WEEK"='JAN-15-2015')  91 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2015-01-07  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  92 - access("WEEK"='JAN-08-2015')  filter("WEEK"='JAN-08-2015')  94 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-12-31  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  95 - access("WEEK"='JAN-01-2015')  filter("WEEK"='JAN-01-2015')  97 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-12-24  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  98 - access("WEEK"='DEC-25-2014')  filter("WEEK"='DEC-25-2014')  100 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-12-17  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  101 - access("WEEK"='DEC-18-2014')  filter("WEEK"='DEC-18-2014')  103 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-12-10  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  104 - access("WEEK"='DEC-11-2014')  filter("WEEK"='DEC-11-2014')  106 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-12-03  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  107 - access("WEEK"='DEC-04-2014')  filter("WEEK"='DEC-04-2014')  109 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-11-26  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  110 - access("WEEK"='NOV-27-2014')  filter("WEEK"='NOV-27-2014')  112 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-11-12  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  113 - access("WEEK"='NOV-13-2014')  filter("WEEK"='NOV-13-2014')  115 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-11-05  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  116 - access("WEEK"='NOV-06-2014')  filter("WEEK"='NOV-06-2014')  118 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION') AND "PROJECT_START_DATE"<TO_DATE(' 2014-10-29  00:00:00', 'syyyy-mm-dd hh24:mi:ss'))  119 - access("WEEK"='OCT-30-2014')  filter("WEEK"='OCT-30-2014')  121 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-10-22 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  122 - access("WEEK"='OCT-23-2014')  filter("WEEK"='OCT-23-2014')  124 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-10-15 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  125 - access("WEEK"='OCT-16-2014')  filter("WEEK"='OCT-16-2014')  127 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-10-08 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  128 - access("WEEK"='OCT-09-2014')  filter("WEEK"='OCT-09-2014')  130 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-10-01 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  131 - access("WEEK"='OCT-02-2014')  filter("WEEK"='OCT-02-2014')  133 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-09-24 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  134 - access("WEEK"='SEP-25-2014')  filter("WEEK"='SEP-25-2014')  136 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-09-17 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  137 - access("WEEK"='SEP-18-2014')  filter("WEEK"='SEP-18-2014')  139 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-09-10 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  140 - access("WEEK"='SEP-11-2014')  filter("WEEK"='SEP-11-2014')  142 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-09-03 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  143 - access("WEEK"='SEP-04-2014')  filter("WEEK"='SEP-04-2014')  145 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-08-27 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  146 - access("WEEK"='AUG-28-2014')  filter("WEEK"='AUG-28-2014')  148 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-08-20 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  149 - access("WEEK"='AUG-21-2014')  filter("WEEK"='AUG-21-2014')  151 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-08-13 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  152 - access("WEEK"='AUG-14-2014')  filter("WEEK"='AUG-14-2014')  154 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-08-06 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  155 - access("WEEK"='AUG-07-2014')  filter("WEEK"='AUG-07-2014')  157 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-07-30 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  158 - access("WEEK"='JUL-31-2014')  filter("WEEK"='JUL-31-2014')  160 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-07-23 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  161 - access("WEEK"='JUL-24-2014')  filter("WEEK"='JUL-24-2014')  163 - filter("STATE"<>'Inactive' AND "CLOSE_DATE"='-' AND UPPER("CREATOR_FULL_NAME") NOT  LIKE '%BALBOSA%GLORIA%' AND "PROJECT_START_DATE"<TO_DATE(' 2014-07-16 00:00:00',  'syyyy-mm-dd hh24:mi:ss') AND ("TAGS_BUSINESS_UNIT"='NA CPRD' OR "TAGS_BUSINESS_UNIT"='NA  EUC' OR "TAGS_BUSINESS_UNIT"='NA HTEC' OR "TAGS_BUSINESS_UNIT"='NA IDS' OR  "TAGS_BUSINESS_UNIT"='NA MALS' OR "TAGS_BUSINESS_UNIT"='NA Operations' OR  "TAGS_BUSINESS_UNIT"='NA US OPERATION'))  164 - access("WEEK"='JUL-17-2014')  filter("WEEK"='JUL-17-2014')  

            The database version is Oracle 11g

            • 3. Re: query taking lot of time to execute

              Sorry - wrong forum!

               

              This forum is ONLY for sql developer questions and your question has NOTHING to do with that product.

               

              Please mark the thread ANSWERED and repost it in the sql and PL/SQL forum

              SQL & PL/SQL

               

              Before you repost read the FAQ in that forum for how to post a tuning request and the info that you need to provide. If you don't provide that info (e.g. table/index ddl, stat info, row counts for tables/predicates, etc) you will be ask for it and that will just delay getting any help.

              • 4. Re: query taking lot of time to execute
                Vadim Tropashko-Oracle

                Run SQLDeveloper autotrace, then identify hotspots of the execution plan:

                Tuning & Diagnostics Features in Oracle SQL Developer