COde : SELECT CUSTOMERZB.CUSTOMER_KEY ZB, CUSTOMERZW.CUSTOMER_KEY ZW, (sum(WMART.WLR_CUST_DB_MTH.ZNWSALE) + sum(WMART.WLR_CUST_DB_MTH.ZSALE) + sum(WMART.WLR_CUST_DB_MTH.ZUPGSALE)) - (sum(WMART.WLR_CUST_DB_MTH.ZNWRET) + sum(WMART.WLR_CUST_DB_MTH.ZRET) + sum(WMART.WLR_CUST_DB_MTH.ZUPGRET))Revenue, WMART.WLR_CUST_DB_MTH.CALDAY, WMART.TIMEDIM_MONTH_VW.MONTH_NUMERIC, sum(WMART.WLR_CUST_DB_MTH.ZFRTRANS) , sum(WMART.WLR_CUST_DB_MTH.ZCHTRANS) , sum(WMART.WLR_CUST_DB_MTH.ZACTCHRG), DB_MATDIM.ZDBSIGNON, DB_MATDIM.DBCLASS_TXT --WMART.WLR_CUST_DB_MTH.UPDATE_TIMESTAMP FROM WMART.WLR_CUST_DB_MTH, WMART.MATERIALDIM SUB_MATDIM, WMART.MATERIALDIM CLASS_MATDIM, WMART.CUSTOMER CUSTOMERZB, WMART.MATERIALSALESDIM DB_MATSALESDIM, WMART.TIMEDIM_MONTH_VW, WMART.MATERIALSALESDIM SUB_MATSALESDIM, WMART.CUSTOMER CUSTOMERZW, WMART.CUSTOMER CUSTOMERSH, WMART.CUSTOMER CUSTOMERSP, WMART.MATERIALDIM DB_MATDIM, WMART.USAGEOPTIONSDIM WHERE ( WMART.WLR_CUST_DB_MTH.ZWL_SUB_LOC=CUSTOMERZB.CUSTOMER_KEY ) AND ( WMART.WLR_CUST_DB_MTH.USAGEOPTIONDIM_KEY=WMART.USAGEOPTIONSDIM.USAGEOPTIONDIM_KEY ) AND ( WMART.WLR_CUST_DB_MTH.DB_MAT_KEY=DB_MATDIM.MATERIAL_KEY ) AND ( WMART.WLR_CUST_DB_MTH.DB_MAT_SALES_KEY=DB_MATSALESDIM.MATERIAL_SALES_KEY ) AND ( WMART.WLR_CUST_DB_MTH.CLASS_MAT_KEY=CLASS_MATDIM.MATERIAL_KEY ) AND ( WMART.WLR_CUST_DB_MTH.SUB_MAT_KEY=SUB_MATDIM.MATERIAL_KEY ) AND ( WMART.WLR_CUST_DB_MTH.SUB_MAT_SALES_KEY=SUB_MATSALESDIM.MATERIAL_SALES_KEY ) AND ( WMART.WLR_CUST_DB_MTH.ZWL_RPT_ORG=CUSTOMERZW.CUSTOMER_KEY ) AND ( WMART.WLR_CUST_DB_MTH.SOLD_TO=CUSTOMERSP.CUSTOMER_KEY ) AND ( WMART.WLR_CUST_DB_MTH.SHIP_TO=CUSTOMERSH.CUSTOMER_KEY ) AND ( WMART.TIMEDIM_MONTH_VW.TIME_DIM_KEY=WMART.WLR_CUST_DB_MTH.CALDAY ) AND DB_MATDIM.ZDBSIGNON IN ('ADMFLG-BPAI-PDF', 'ADMFLG-ITC-PDF', 'ADMFLG-TTAB-PDF', 'ASIAPAC-ALL', 'BPAI-FILINGS', 'BPAI-RULES', 'CATAGPRINT', 'CATEMPLATE', 'CLAIMSLOCATORDB', 'CLAIMSSELECTDB', 'CN-PAT', 'CN-PAT-ALL', 'CN-PAT-APP', 'COPYRIGHT-FRMS', 'DE-PAT', 'DE-PAT-ALL', 'DE-PAT-APP', 'EPO-PAT', 'EPO-PAT-ALL', 'EPO-PAT-APP', 'EPO-PAT-HELP', 'EURO-PAT-ALL', 'EURO-PATENT-PDF', 'FIP-DECISIONS', 'FIP-OG-PAT', 'FR-PAT', 'FR-PAT-ALL', 'FR-PAT-APP', 'GB-PAT', 'GB-PAT-ALL', 'GB-PAT-APP', 'GRAPHCLAIMSHIST', 'GRAPHCLAIMSTRACK', 'GRAPHPATFAM', 'IPADMIN-FILINGS', 'IP-TREATIES', 'ITC-RULES', 'ITC-RULES-TOC', 'JP-PAT', 'JP-PAT-ALL', 'JP-PAT-APP', 'KR-PAT', 'KR-PAT-ALL', 'KR-PAT-APP', 'MARKMAN-ALL', 'MARKMAN-CLAIMCHT', 'MARKMAN-DCT', 'MARKMAN-ORDERS', 'PAT-ACCGRPH', 'PAT-AMENDED-LINK', 'PAT-APPRESP', 'PATCLAIM', 'PATCLAIMSFINAL', 'PATCLAIMSORIGIN', 'PATCLAIMSVERS', 'PAT-FILEHIS-LINK', 'PATFILEHIST-PDF', 'PATFILELINK', 'PATFILEPDF', 'PATFILEWRAP', 'PAT-GPHCLMS-LINK', 'PAT-ORIGFIN-LINK', 'PATRULES-ALL', 'PATRULES-ALL-TOC', 'PATRULES-CA', 'PATRULES-CA-TOC', 'PATRULES-DE', 'PATRULES-DE-TOC', 'PATRULES-GA', 'PATRULES-GA-TOC', 'PATRULES-IL', 'PATRULES-IL-TOC', 'PATRULES-MN', 'PATRULES-MN-TOC', 'PATRULES-NJ', 'PATRULES-NJ-TOC', 'PATRULES-PA', 'PATRULES-PA-TOC', 'PATRULES-TX', 'PATRULES-TX-TOC', 'PATRULES-WA', 'PATRULES-WA-TOC', 'PROFILER-IP', 'PROFILER-PATEX', 'PROFILER-PATJ', 'PROFILER-TMEX', 'PROFILER-TMJ', 'TMRULES-ALL', 'TMRULES-ALL-TOC', 'TMRULES-AZ', 'TMRULES-AZ-TOC', 'TMRULES-CA', 'TMRULES-CA-TOC', 'TMRULES-FL', 'TMRULES-FL-TOC', 'TMRULES-IL', 'TMRULES-IL-TOC', 'TMRULES-LA', 'TMRULES-LA-TOC', 'TMRULES-MI', 'TMRULES-MI-TOC', 'TMRULES-MN', 'TMRULES-MN-TOC', 'TMRULES-MO', 'TMRULES-MO-TOC', 'TMRULES-NC', 'TMRULES-NC-TOC', 'TMRULES-NJ', 'TMRULES-NJ-TOC', 'TMRULES-NY', 'TMRULES-NY-TOC', 'TMRULES-OH', 'TMRULES-OH-TOC', 'TMRULES-PA', 'TMRULES-PA-TOC', 'TMRULES-TX', 'TMRULES-TX-TOC', 'TMRULES-WA', 'TMRULES-WA-TOC', 'TTAB-FILINGS', 'TTAB-RULES', 'USITC-F', 'USITC-FILINGS', 'US-PAT-HIST', 'US-PAT-HISTORY', 'USPTOPAT-RULES', 'USPTOTM-RULES', 'WORLDPAT-ALL') AND ( CUSTOMERZB.SALESORG = 'WEST' ) AND ( CUSTOMERSP.INDUSTRY NOT IN ('PWI','AWI','CWI','FGWI','FWI','GWI') ) AND ( CLASS_MATDIM.MATERIAL_NUM Not In (30004517, 33000003,40434827,40544038,40697050) ) AND WMART.TIMEDIM_MONTH_VW.MONTH_NUMERIC >= '201201' GROUP BY CUSTOMERZB.CUSTOMER_KEY , CUSTOMERZW.CUSTOMER_KEY, WMART.WLR_CUST_DB_MTH.CALDAY, WMART.TIMEDIM_MONTH_VW.MONTH_NUMERIC, DB_MATDIM.ZDBSIGNON, DB_MATDIM.DBCLASS_TXT HAVING ( (sum(WMART.WLR_CUST_DB_MTH.ZNWSALE) + sum(WMART.WLR_CUST_DB_MTH.ZSALE) + sum(WMART.WLR_CUST_DB_MTH.ZUPGSALE)) - (sum(WMART.WLR_CUST_DB_MTH.ZNWRET) + sum(WMART.WLR_CUST_DB_MTH.ZRET) + sum(WMART.WLR_CUST_DB_MTH.ZUPGRET)) != 0 ) Plan hash value: 863245068 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 65M| 12G| | 3386K (1)| 00:00:58 | | | | | | | 1 | PX COORDINATOR | | | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10014 | 65M| 12G| | 3386K (1)| 00:00:58 | | | Q1,14 | P->S | QC (RAND) | |* 3 | FILTER | | | | | | | | | Q1,14 | PCWC | | | 4 | HASH GROUP BY | | 65M| 12G| 254G| 3386K (1)| 00:00:58 | | | Q1,14 | PCWP | | | 5 | PX RECEIVE | | 1303M| 241G| | 314K (7)| 00:00:06 | | | Q1,14 | PCWP | | | 6 | PX SEND HASH | :TQ10013 | 1303M| 241G| | 314K (7)| 00:00:06 | | | Q1,13 | P->P | HASH | |* 7 | HASH JOIN | | 1303M| 241G| | 314K (7)| 00:00:06 | | | Q1,13 | PCWP | | | 8 | PX RECEIVE | | 1588K| 10M| | 69 (2)| 00:00:01 | | | Q1,13 | PCWP | | | 9 | PX SEND BROADCAST | :TQ10002 | 1588K| 10M| | 69 (2)| 00:00:01 | | | Q1,02 | P->P | BROADCAST | | 10 | PX BLOCK ITERATOR | | 1588K| 10M| | 69 (2)| 00:00:01 | | | Q1,02 | PCWC | | | 11 | INDEX STORAGE FAST FULL SCAN | MATERIALDIM_PK | 1588K| 10M| | 69 (2)| 00:00:01 | | | Q1,02 | PCWP | | |* 12 | HASH JOIN | | 1303M| 232G| | 314K (7)| 00:00:06 | | | Q1,13 | PCWP | | | 13 | PX RECEIVE | | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,13 | PCWP | | | 14 | PX SEND BROADCAST | :TQ10003 | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,03 | P->P | BROADCAST | | 15 | PX BLOCK ITERATOR | | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,03 | PCWC | | |* 16 | INDEX FAST FULL SCAN | MATERIALDIM_X4 | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,03 | PCWP | | |* 17 | HASH JOIN | | 1303M| 217G| | 313K (7)| 00:00:06 | | | Q1,13 | PCWP | | | 18 | PX RECEIVE | | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,13 | PCWP | | | 19 | PX SEND BROADCAST | :TQ10004 | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,04 | P->P | BROADCAST | | 20 | PX BLOCK ITERATOR | | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,04 | PCWC | | |* 21 | INDEX FAST FULL SCAN | CUSTOMER_X4 | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,04 | PCWP | | |* 22 | HASH JOIN | | 1303M| 203G| | 313K (6)| 00:00:06 | | | Q1,13 | PCWP | | | 23 | PX RECEIVE | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,13 | PCWP | | | 24 | PX SEND BROADCAST | :TQ10005 | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,05 | P->P | BROADCAST | | 25 | PX BLOCK ITERATOR | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,05 | PCWC | | | 26 | INDEX STORAGE FAST FULL SCAN | MATERIALSALESDIM_PK | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,05 | PCWP | | |* 27 | HASH JOIN | | 1303M| 195G| | 312K (6)| 00:00:06 | | | Q1,13 | PCWP | | | 28 | PX RECEIVE | | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,13 | PCWP | | | 29 | PX SEND BROADCAST | :TQ10006 | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,06 | P->P | BROADCAST | | 30 | PX BLOCK ITERATOR | | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,06 | PCWC | | | 31 | INDEX STORAGE FAST FULL SCAN | CUSTOMER_PK | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,06 | PCWP | | |* 32 | HASH JOIN | | 1303M| 186G| | 312K (6)| 00:00:06 | | | Q1,13 | PCWP | | | 33 | PX RECEIVE | | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,13 | PCWP | | | 34 | PX SEND BROADCAST | :TQ10007 | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,07 | P->P | BROADCAST | | 35 | PX BLOCK ITERATOR | | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,07 | PCWC | | | 36 | INDEX STORAGE FAST FULL SCAN | CUSTOMER_PK | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,07 | PCWP | | |* 37 | HASH JOIN | | 1303M| 178G| | 311K (6)| 00:00:06 | | | Q1,13 | PCWP | | | 38 | PX RECEIVE | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,13 | PCWP | | | 39 | PX SEND BROADCAST | :TQ10008 | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,08 | P->P | BROADCAST | | 40 | PX BLOCK ITERATOR | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,08 | PCWC | | | 41 | INDEX STORAGE FAST FULL SCAN | MATERIALSALESDIM_PK | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,08 | PCWP | | |* 42 | HASH JOIN | | 1303M| 169G| | 311K (6)| 00:00:06 | | | Q1,13 | PCWP | | | 43 | PART JOIN FILTER CREATE | :BF0000 | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,13 | PCWP | | | 44 | PX RECEIVE | | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,13 | PCWP | | | 45 | PX SEND BROADCAST | :TQ10009 | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,09 | P->P | BROADCAST | | 46 | PX BLOCK ITERATOR | | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,09 | PCWC | | |* 47 | TABLE ACCESS STORAGE FULL | TIMEDIM_MONTH | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,09 | PCWP | | |* 48 | HASH JOIN | | 1531M| 181G| | 310K (6)| 00:00:06 | | | Q1,13 | PCWP | | | 49 | PX RECEIVE | | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,13 | PCWP | | | 50 | PX SEND BROADCAST | :TQ10010 | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,10 | P->P | BROADCAST | | 51 | PX BLOCK ITERATOR | | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,10 | PCWC | | |* 52 | TABLE ACCESS STORAGE FULL | CUSTOMER | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,10 | PCWP | | |* 53 | HASH JOIN | | 5244M| 561G| | 301K (5)| 00:00:06 | | | Q1,13 | PCWP | | | 54 | PX RECEIVE | | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,13 | PCWP | | | 55 | PX SEND BROADCAST | :TQ10011 | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,11 | P->P | BROADCAST | | 56 | PX BLOCK ITERATOR | | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,11 | PCWC | | | 57 | INDEX STORAGE FAST FULL SCAN | USAGEOPTIONSDIM_PK | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,11 | PCWP | | |* 58 | HASH JOIN | | 5244M| 527G| | 299K (5)| 00:00:06 | | | Q1,13 | PCWP | | | 59 | PX RECEIVE | | 141K| 2761K| | 1949 (1)| 00:00:01 | | | Q1,13 | PCWP | | | 60 | PX SEND BROADCAST | :TQ10012 | 141K| 2761K| | 1949 (1)| 00:00:01 | | | Q1,12 | P->P | BROADCAST | | 61 | MERGE JOIN CARTESIAN | | 141K| 2761K| | 1949 (1)| 00:00:01 | | | Q1,12 | PCWP | | | 62 | VIEW | | 75 | | | 3 (34)| 00:00:01 | | | Q1,12 | PCWP | | | 63 | HASH UNIQUE | | 75 | 675 | | 3 (34)| 00:00:01 | | | Q1,12 | PCWP | | | 64 | PX RECEIVE | | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,12 | PCWP | | | 65 | PX SEND HASH | :TQ10001 | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,01 | P->P | HASH | | 66 | PX BLOCK ITERATOR | | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,01 | PCWC | | |* 67 | TABLE ACCESS STORAGE FULL | TIMEDIM_MONTH | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,01 | PCWP | | | 68 | BUFFER SORT | | 1885 | 37700 | | 1949 (1)| 00:00:01 | | | Q1,12 | PCWP | | | 69 | BUFFER SORT | | | | | | | | | Q1,12 | PCWC | | | 70 | PX RECEIVE | | 1885 | 37700 | | 1871 (1)| 00:00:01 | | | Q1,12 | PCWP | | | 71 | PX SEND BROADCAST | :TQ10000 | 1885 | 37700 | | 1871 (1)| 00:00:01 | | | | S->P | BROADCAST | | 72 | INLIST ITERATOR | | | | | | | | | | | | | 73 | TABLE ACCESS BY INDEX ROWID| MATERIALDIM | 1885 | 37700 | | 1871 (1)| 00:00:01 | | | | | | |* 74 | INDEX RANGE SCAN | MATERIALDIM_X5 | 1885 | | | 128 (0)| 00:00:01 | | | | | | | 75 | PX BLOCK ITERATOR | | 2373M| 194G| | 295K (4)| 00:00:05 |:BF0000|:BF0000| Q1,13 | PCWC | | |* 76 | TABLE ACCESS STORAGE FULL | WLR_CUST_DB_MTH | 2373M| 194G| | 295K (4)| 00:00:05 |:BF0000|:BF0000| Q1,13 | PCWP | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - filter(SUM("WLR_CUST_DB_MTH"."ZNWSALE")+SUM("WLR_CUST_DB_MTH"."ZSALE")+SUM("WLR_CUST_DB_MTH"."ZUPGSALE")-(SUM("WLR_CUST_DB_MTH"."ZNWRET")+SUM("WLR_CUST_DB_MTH"."Z RET")+SUM("WLR_CUST_DB_MTH"."ZUPGRET"))<>0) 7 - access("WLR_CUST_DB_MTH"."SUB_MAT_KEY"="SUB_MATDIM"."MATERIAL_KEY") 12 - access("WLR_CUST_DB_MTH"."CLASS_MAT_KEY"="CLASS_MATDIM"."MATERIAL_KEY") 16 - filter("CLASS_MATDIM"."MATERIAL_NUM"<>30004517 AND "CLASS_MATDIM"."MATERIAL_NUM"<>33000003 AND "CLASS_MATDIM"."MATERIAL_NUM"<>40434827 AND "CLASS_MATDIM"."MATERIAL_NUM"<>40544038 AND "CLASS_MATDIM"."MATERIAL_NUM"<>40697050) 17 - access("WLR_CUST_DB_MTH"."SOLD_TO"="CUSTOMERSP"."CUSTOMER_KEY") 21 - filter("CUSTOMERSP"."INDUSTRY"<>'PWI' AND "CUSTOMERSP"."INDUSTRY"<>'AWI' AND "CUSTOMERSP"."INDUSTRY"<>'CWI' AND "CUSTOMERSP"."INDUSTRY"<>'FGWI' AND "CUSTOMERSP"."INDUSTRY"<>'FWI' AND "CUSTOMERSP"."INDUSTRY"<>'GWI') 22 - access("WLR_CUST_DB_MTH"."DB_MAT_SALES_KEY"="DB_MATSALESDIM"."MATERIAL_SALES_KEY") 27 - access("WLR_CUST_DB_MTH"."ZWL_RPT_ORG"="CUSTOMERZW"."CUSTOMER_KEY") 32 - access("WLR_CUST_DB_MTH"."SHIP_TO"="CUSTOMERSH"."CUSTOMER_KEY") 37 - access("WLR_CUST_DB_MTH"."SUB_MAT_SALES_KEY"="SUB_MATSALESDIM"."MATERIAL_SALES_KEY") 42 - access("TIME_DIM_KEY"="WLR_CUST_DB_MTH"."CALDAY") 47 - storage("MONTH_NUMERIC">='201201' AND "TD"."MONTH_NUMERIC"<>'NV') filter("MONTH_NUMERIC">='201201' AND "TD"."MONTH_NUMERIC"<>'NV') 48 - access("WLR_CUST_DB_MTH"."ZWL_SUB_LOC"="CUSTOMERZB"."CUSTOMER_KEY") 52 - storage("CUSTOMERZB"."SALESORG"='WEST') filter("CUSTOMERZB"."SALESORG"='WEST') 53 - access("WLR_CUST_DB_MTH"."USAGEOPTIONDIM_KEY"="USAGEOPTIONSDIM"."USAGEOPTIONDIM_KEY") 58 - access("WLR_CUST_DB_MTH"."DB_MAT_KEY"="DB_MATDIM"."MATERIAL_KEY") 67 - storage("WLU_812_FLAG"='Y') filter("WLU_812_FLAG"='Y') 74 - access("DB_MATDIM"."ZDBSIGNON"='ADMFLG-BPAI-PDF' OR "DB_MATDIM"."ZDBSIGNON"='ADMFLG-ITC-PDF' OR "DB_MATDIM"."ZDBSIGNON"='ADMFLG-TTAB-PDF' OR "DB_MATDIM"."ZDBSIGNON"='ASIAPAC-ALL' OR "DB_MATDIM"."ZDBSIGNON"='BPAI-FILINGS' OR "DB_MATDIM"."ZDBSIGNON"='BPAI-RULES' OR "DB_MATDIM"."ZDBSIGNON"='CATAGPRINT' OR "DB_MATDIM"."ZDBSIGNON"='CATEMPLATE' OR "DB_MATDIM"."ZDBSIGNON"='CLAIMSLOCATORDB' OR "DB_MATDIM"."ZDBSIGNON"='CLAIMSSELECTDB' OR "DB_MATDIM"."ZDBSIGNON"='CN-PAT' OR "DB_MATDIM"."ZDBSIGNON"='CN-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='CN-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='COPYRIGHT-FRMS' OR "DB_MATDIM"."ZDBSIGNON"='DE-PAT' OR "DB_MATDIM"."ZDBSIGNON"='DE-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='DE-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='EPO-PAT' OR "DB_MATDIM"."ZDBSIGNON"='EPO-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='EPO-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='EPO-PAT-HELP' OR "DB_MATDIM"."ZDBSIGNON"='EURO-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='EURO-PATENT-PDF' OR "DB_MATDIM"."ZDBSIGNON"='FIP-DECISIONS' OR "DB_MATDIM"."ZDBSIGNON"='FIP-OG-PAT' OR "DB_MATDIM"."ZDBSIGNON"='FR-PAT' OR "DB_MATDIM"."ZDBSIGNON"='FR-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='FR-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='GB-PAT' OR "DB_MATDIM"."ZDBSIGNON"='GB-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='GB-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='GRAPHCLAIMSHIST' OR "DB_MATDIM"."ZDBSIGNON"='GRAPHCLAIMSTRACK' OR "DB_MATDIM"."ZDBSIGNON"='GRAPHPATFAM' OR "DB_MATDIM"."ZDBSIGNON"='IP-TREATIES' OR "DB_MATDIM"."ZDBSIGNON"='IPADMIN-FILINGS' OR "DB_MATDIM"."ZDBSIGNON"='ITC-RULES' OR "DB_MATDIM"."ZDBSIGNON"='ITC-RULES-TOC' OR "DB_MATDIM"."ZDBSIGNON"='JP-PAT' OR "DB_MATDIM"."ZDBSIGNON"='JP-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='JP-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='KR-PAT' OR "DB_MATDIM"."ZDBSIGNON"='KR-PAT-ALL' OR "DB_MATDIM"."ZDBSIGNON"='KR-PAT-APP' OR "DB_MATDIM"."ZDBSIGNON"='MARKMAN-ALL' OR "DB_MATDIM"."ZDBSIGNON"='MARKMAN-CLAIMCHT' OR "DB_MATDIM"."ZDBSIGNON"='MARKMAN-DCT' OR "DB_MATDIM"."ZDBSIGNON"='MARKMAN-ORDERS' OR "DB_MATDIM"."ZDBSIGNON"='PAT-ACCGRPH' OR "DB_MATDIM"."ZDBSIGNON"='PAT-AMENDED-LINK' OR "DB_MATDIM"."ZDBSIGNON"='PAT-APPRESP' OR "DB_MATDIM"."ZDBSIGNON"='PAT-FILEHIS-LINK' OR "DB_MATDIM"."ZDBSIGNON"='PAT-GPHCLMS-LINK' OR "DB_MATDIM"."ZDBSIGNON"='PAT-ORIGFIN-LINK' OR "DB_MATDIM"."ZDBSIGNON"='PATCLAIM' OR "DB_MATDIM"."ZDBSIGNON"='PATCLAIMSFINAL' OR "DB_MATDIM"."ZDBSIGNON"='PATCLAIMSORIGIN' OR "DB_MATDIM"."ZDBSIGNON"='PATCLAIMSVERS' OR "DB_MATDIM"."ZDBSIGNON"='PATFILEHIST-PDF' OR "DB_MATDIM"."ZDBSIGNON"='PATFILELINK' OR "DB_MATDIM"."ZDBSIGNON"='PATFILEPDF' OR "DB_MATDIM"."ZDBSIGNON"='PATFILEWRAP' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-ALL' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-ALL-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-CA' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-CA-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-DE' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-DE-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-GA' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-GA-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-IL' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-IL-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-MN' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-MN-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-NJ' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-NJ-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-PA' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-PA-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-TX' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-TX-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-WA' OR "DB_MATDIM"."ZDBSIGNON"='PATRULES-WA-TOC' OR "DB_MATDIM"."ZDBSIGNON"='PROFILER-IP' OR "DB_MATDIM"."ZDBSIGNON"='PROFILER-PATEX' OR "DB_MATDIM"."ZDBSIGNON"='PROFILER-PATJ' OR "DB_MATDIM"."ZDBSIGNON"='PROFILER-TMEX' OR "DB_MATDIM"."ZDBSIGNON"='PROFILER-TMJ' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-ALL' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-ALL-TOC' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-AZ' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-AZ-TOC' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-CA' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-CA-TOC' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-FL' OR "DB_MATDIM"."ZDBSIGNON"='TMRULES-FL-TOC' OR "DB_MATDIM"."Z) 76 - storage(SYS_OP_BLOOM_FILTER(:BF0001,"WLR_CUST_DB_MTH"."ZWL_SUB_LOC")) filter(SYS_OP_BLOOM_FILTER(:BF0001,"WLR_CUST_DB_MTH"."ZWL_SUB_LOC"))