Home » SQL & PL/SQL » SQL & PL/SQL » query taking lot of time to execute (ORACLE 11g)
query taking lot of time to execute [message #639937] |
Mon, 20 July 2015 08:49 |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Hi Sir,
The below query is taking lot of time to execute sir
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')
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-21,'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-22
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-28,'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-29
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-35,'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-36
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-42,'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-43
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-49,'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-50
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-56,'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-57
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-63,'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-64
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-70,'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-71
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-77,'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-78
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-84,'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-85
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-91,'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-92
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-98,'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-99
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-105,'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-106
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-112,'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-113
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-119,'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-120
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-126,'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-127
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-133,'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-134
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-133,'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-134
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-140,'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-141
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-147,'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-148
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-154,'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-155
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-161,'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-162
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-161,'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-162
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-168,'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-169
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-175,'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-176
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-182,'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-183
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-189,'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-190
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-196,'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-197
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-203,'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-204
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-210,'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-211
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-217,'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-218
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-224,'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-225
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-231,'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-232
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-245,'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-246
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-252,'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-253
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-259,'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-260
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-266,'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-267
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-273,'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-274
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-280,'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-281
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-287,'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-288
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-294,'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-295
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-301,'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-302
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-308,'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-309
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-315,'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-316
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-322,'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-323
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-329,'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-330
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-336,'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-337
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-343,'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-344
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-350,'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-351
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-357,'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-358
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-364,'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-365
group by TAGS_BUSINESS_UNIT,TAGS_SUB_BUSINESS_UNIT,to_date(WEEk,'MON-dd-yyyy')
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')
Please help me to tune the above query
|
|
|
|
Re: query taking lot of time to execute [message #639940 is a reply to message #639939] |
Mon, 20 July 2015 09:14 |
cookiemonster
Messages: 13920 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Looks suspiciously like the only difference between all those unioned selects are the following lines:
WHERE week = to_char(to_date('07/13/2015','mm/dd/yyyy')+3-336,'MON-DD-YYYY')
....
and project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-358
And the only thing that actually changes is the number being subtracted from 3.
Is that the case (cause I'm certainly not comparing the lot)?
|
|
|
|
|
|
Re: query taking lot of time to execute [message #639945 is a reply to message #639941] |
Mon, 20 July 2015 10:00 |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Thank you very much sir for this prompt reply
There is only two difference in the union query.
One is
week = to_char(to_date('07/13/2015','mm/dd/yyyy')+3,'MON-DD-YYYY')
and second is
project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-1
I can implement week by using in operator but my project_start_date also changes . In this case what could be my project_start_date ?
Appreciate your help sir
|
|
|
Re: query taking lot of time to execute [message #639947 is a reply to message #639945] |
Mon, 20 July 2015 10:07 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
select *
from mytab
where a = 1 and b = 2
union
select *
from mytab
where a = 2 and b = 3union
select *
from mytab
where a = 3 and b = 4
select *
from mytab
where (a=1 and b=2) or (a=2 and b=3) or (a=3 and b = 4)
alternatively, you could make up a table that contained the date combos that you want and do a pairwise query:
select *
from mytab
where (a,b) in (select adate, bdate
from yourtab)
where a = 3 and b = 8[/code]
|
|
|
|
Re: query taking lot of time to execute [message #639949 is a reply to message #639948] |
Mon, 20 July 2015 10:13 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
cookiemonster wrote on Mon, 20 July 2015 16:07Looks like the project_start_date is being compared to the day before the week value in all cases.
Good shout, hadn't spotted that.
select *
from mytab
where a in (1,2,3)
and b = a-1
|
|
|
|
|
Re: query taking lot of time to execute [message #639954 is a reply to message #639952] |
Mon, 20 July 2015 10:46 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
The suggestion given in message 639949 (the message to which you replied) makes no mention of creating any tables, nor does the first suggestion in message 639947, I assume that you are referring to the second suggestion in that message. S to summarise, you have been given 3 suggestions as to how to write your query, but because one of those suggestions contains an implication that you'd need to build a table (you don't actually need to, you could create an inline view if you wanted - but let's not further confuse matters) you have discarded the other two without actually considering them. Further, the third suggestion is clearly a revision of the other, significantly simplifying the code due to CM's pointer. So, why did you decide to only consider the suggestion that implied the use of a table, and reject the other two suggestions as if they didn't exist?
|
|
|
|
Re: query taking lot of time to execute [message #639957 is a reply to message #639954] |
Mon, 20 July 2015 11:15 |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Hi Sir,
Thanks for the suggestion sir
Here is the confusion. If you can see the query sir in every union there is +3 plus incremented by 7 for week column and
project_start_date is less to_date('07/13/2015','mm/dd/yyyy')+3-1 ,to_date('07/13/2015','mm/dd/yyyy')+3-8,to_date('07/13/2015','mm/dd/yyyy')+3-15
...
for every union clause
For week I can simply add a in operator whereas for ever union there is a different project_start_date which is less than
How I should implement it technically sir without using union operator.
Regards
|
|
|
Re: query taking lot of time to execute [message #639959 is a reply to message #639957] |
Mon, 20 July 2015 13:17 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
week = to_char(to_date('07/13/2015','mm/dd/yyyy')+3,'MON-DD-YYYY')
project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-1
week = to_char(to_date('07/13/2015','mm/dd/yyyy')+3-7,'MON-DD-YYYY')
project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-8
week = to_char(to_date('07/13/2015','mm/dd/yyyy')+3-14,'MON-DD-YYYY')
project_start_date < to_date('07/13/2015','mm/dd/yyyy')+3-15
within each query, there is a clear, direct correlation between week and project_start_date. see if you can figure it out.
|
|
|
|
|
Re: query taking lot of time to execute [message #640324 is a reply to message #640243] |
Mon, 27 July 2015 05:42 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
John Watson wrote on Fri, 24 July 2015 18:01Looks as though your answer wasn't good enough:
https://community.oracle.com/thread/3772418
You should have written the complete statement for him. I can't understand why you are so lazy, Pablo.
Sorry John <tugs forelock> I'll get right on that
cookiemonster wroteI love the fact that the OP has taken a cut down version of the original SQL and asked an unnecessary question about - can you rewrite this with a WITH clause - the whole thing can be done in one select without a WITH clause or any UNIONs.
I love Dom Brooks's post in that thread.
|
|
|
Goto Forum:
Current Time: Fri Apr 26 03:06:13 CDT 2024
|