<<1>> ==================================== Query: Select * From (Select * From doc_mgmt.worklist_summary WS Where WS.WL_Stat_Type_Num in (3, 10, 14, 15, 32, 16) AND ((WS.Days_In_Queue - sysdate)*24 + (Decode(Region, NULL, category_val, Null)) + (Select Count(1)*24 From DOC_MGMT.SLA_HOLIDAY Where DATED Between WS.Days_In_Queue AND sysdate)) Between 00 and 2 Order By 1 ) Where Rownum <= 500 Output: (No rows) ---------------- .. <<2>> ==================================== Query: (without rownum) Select * From (Select * From doc_mgmt.worklist_summary WS Where WS.WL_Stat_Type_Num in (3, 10, 14, 15, 32, 16) AND ((WS.Days_In_Queue - sysdate)*24 + (Decode(Region, NULL, category_val, Null)) + (Select Count(1)*24 From DOC_MGMT.SLA_HOLIDAY Where DATED Between WS.Days_In_Queue AND sysdate)) Between 00 and 2 Order By 1 ) Output: (2 rows) ---------------- [..see the excel file attached for a better format...] WL_ID || BB_ID || PRIORITY||CATEGORY_VAL || CATEGORY_DESC || COMPANY_NAME || TICKER || COUNTRY || REGION || DOC_TYPE||DOC_FORMAT ||DOC_PERIOD_END_DATE || PERIOD_END_DATE ||INDEXED ||MARKET_CAP ||DAYS_IN_QUEUE || COMPANY_TYPE || INDUSTRY_SECTOR || INDUSTRY_GROUP || LANGUAGE||REJECT_REASON_CODE || REJECT_REASON_NOTE || UUID || ACCESSION_ID || RECEIVED_DATE || WL_STAGE_NUM || WL_STAGE_DESC || WL_STAT_TYPE_NUM || WL_STAT_TYPE_DESC || CREATE_USER_ID || CREATE_TS || UPDATE_USER_ID || UPDATE_TS || EXCHANGE || FISCAL_YEAR || ANNOUNCEMENT_DATE || SOURCE_DOC_ID || SLA_TO_VENDOR_ESTIMATED_TIME || SLA_TO_BB_ESTIMATED_TIME || ANALYST_ID_VENDOR || POD_COUNT_VENDOR || POD_COUNT_BLOOMBERG_QA || SLA_TIER_TO_BLOOMBERG || SLA_TIER_TO_VENDOR || LANGUAGE_SUPPLIED_BY_VENDOR || PROCESSING_DELAY_MIN_BY_VENDOR || NEWS_WIRE || NEWS_CLASS || CF_PACKAGE || MULTI_MEDIA_ATTACHMENT || MULTI_MEDIA_NSN_DOCUMENT || FISCAL_PERIOD || HEADLINE || BDAP_BYPASS_TEXT_ANALYSIS || BDAP_BYPASS_RULES || ID_TYPE || ID_VALUE || FUND_COUNTRY_ID || REGION_ID || AGENT_ID || AGENT_NAME || SUBSCRIPTION_NAME || SUBSCRIPTION_AUTHOR || TIME_OF_ARRIVAL || DOC_DATA || TIME_OF_PUBLISH || LINK_TEXT || LINK_URL || SOURCE_URL || DOCUMENT_CLASS || DOC_TYPE_NUM || LANGUAGE_ID || PUBLIC_PRIVATE || BDAP_RESTRICTION || AMEND_TO || SEARCH_FOR || TIME_TO_PROCESS || WCWL_ANALYST || PUBLIC_PRIVATE_UPDATABLE || COMPLETION_DATE || CF_GROUP_ID || CF_STATUS || CF_ERROR_CODE || CF_ERROR_REASON || PAGE_COUNT || BB_NUMBER || CUSIP || ISIN || BB_MESSAGE_ID || MESSAGE_RECEIVED_DATE_TIME || MESSAGE_SUBJECT || MESSAGE_SENDER || MESSAGE_RECEIVER || LEAD_MANAGER || NIM_DEAL || BUNDLEID || MARKET_OF_ISSUE || COUPON_TYPE || MATURITY_TYPE || COVENANT_DFLT_INFO_AVAILABLE || ISUP || PRIVILEGE || AMOUNT_OUTSTANDING || AGGREGATE_AMOUNT_ISSUED_FLAG || MATURITY || FIRST_SETTLE_DATE || FIRST_COUPON_DATE || IN_LEAGUE_TABLE || BB_COMPOSITE_RATING || FINALIZATION_STATUS || STRUCTURED_NOTE || REVERSE_COVENANT || CREDIT_LINKED || PRIVATE_PLACEMENT || CERTIFICATE || VARIABLE_REDEMPTION || PROCESSING_COUNTRY_CODE || DOC_SIZE || SECURITY_ID || ITEM_READ || ITEM_NOTE || BB_YELLOW_KEY_DESC || MESSAGE_SENDER_NAME || PRODUCT_TYPE || ADD_UPDATE || FIRST_IN_PROCESS_TIME -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 432170 || 159373 || || 4 || Company Filings || WATERS CORP || WAT || United States || || 10-Q || html || 2007-09-29 || 2007-09-29 || Yes || 5740.28 || 31-JAN-08 || Industrial || Industrial || Electronics || English || || || || 0000950135-07-006667 || 2007-11-02 || 32 || Company Info || 14 || Available || 1 || 31-JAN-08 11.47.47.280202000 AM || 1 || 31-JAN-08 11.54.47.747701000 AM || US || 2008-12 || 2007-10-23 || 111500fns1b00a01f167 || || || || || || || || || || || || 121400fns1b00a01f163 || || || || || false || false || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || 1 || 538480 || || || || || || || || 432171 || 100756 || || 4 || Company Filings || STARWOOD HOTELS & RESORTS WORLDWIDE INC || HOT || United States || || 10-Q || html || 2007-09-30 || 2007-09-30 || Yes || 8975.42 || 31-JAN-08 || Industrial || Consumer, Cyclical || Lodging || English || || || || 0000950153-07-002357 || 2007-11-09 || 32 || Company Info || 14 || Available || 1 || 31-JAN-08 11.47.47.280887000 AM || 1 || 31-JAN-08 11.54.23.100251000 AM || US || 2008-12 || 2007-10-25 || 111500fns1b00a01f166 || || || || || || || || || || || || 121400fns1b00a01f162 || || || || || false || false || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || 1 || 708563 || || || || || || || ||