<<1>> ==================================== Query: Select "Received_Date", "ReportingGroup", "WL_ID", "ACCESSION_ID" From (Select NVL(TO_CHAR(TO_DATE(WS.Received_Date, 'YYYY-MM-DD'), 'MM/DD/YYYY'), 'NA') As "Received_Date", NVL(pit.person_info_type_desc,' ') as "ReportingGroup", WS.WL_ID, NVL(WS.ACCESSION_ID, 'NA') As "ACCESSION_ID" From doc_mgmt.worklist_summary WS left join profiles.person_uuid U on ws.uuid = u.person_uuid left join profiles.person P on u.person_id = p.person_id left join profiles.person_info_list pil on p.person_id = pil.person_id and pil.person_info_cat_num = 5 and pil.person_info_actv = 'Y' left join profiles.person_info_type pit on pit.person_info_cat_num = pil.person_info_cat_num and pit.person_info_type_num = pil.person_info_type_num and pit.person_info_type_actv = 'Y' join DOC_MGMT.SLA_WORKLIST_SUMMARY WSUMM on WS.WL_ID = WSUMM.wl_id Where WSUMM.WL_STAT_TYPE_NUM IN (3, 10, 14, 15, 32, 16) AND ((WSUMM.SLA_Start_TS - sysdate)*24 + (Decode(SLA_Override_User_NM, NULL, SLA_VAL, Null)) + (Select Count(1)*24 From DOC_MGMT.SLA_HOLIDAY Where DATED Between WSUMM.SLA_Start_TS AND sysdate)) Between 0 and 2 Order By "Received_Date" Desc ) Where Rownum <= 500 Output: Recvd_Date| Report_Grp | Wl_id | acc_id ------------------------------------------------ 12/20/2007 361148 LI000000000074891022 12/20/2007 361149 LI000000000074891022 12/20/2007 361146 LI000000000074891022 11/22/2007 426640 LI000000000072942780 11/22/2007 361147 LI000000000072942780 11/22/2007 428754 LI000000000072942780 11/22/2007 428764 LI000000000072942780 11/09/2007 429173 0000723458-07-000096 10/31/2007 428739 LI000000000071029239 01/25/2008 429141 WD000000000076570235 01/25/2008 429171 WC000000000076560115 01/21/2008 428763 LI000000000076322318 01/17/2008 429146 SD000000000076188987 01/17/2008 429163 SD000000000076188535 01/17/2008 429161 SD000000000076188559 01/17/2008 429159 SD000000000076188583 01/17/2008 429157 SD000000000076188599 01/17/2008 429155 SD000000000076188667 01/17/2008 429153 SD000000000076188835 01/17/2008 429151 SD000000000076188971 01/17/2008 429170 SD000000000076188355 01/17/2008 429164 SD000000000076188527 01/17/2008 429162 SD000000000076188543 01/17/2008 429160 SD000000000076188567 01/17/2008 429158 SD000000000076188575 01/17/2008 429156 SD000000000076188591 01/17/2008 429154 SD000000000076188659 01/17/2008 429152 SD000000000076188703 01/17/2008 429150 SD000000000076188979 01/17/2008 429145 SD000000000076189243 01/17/2008 429166 SD000000000076188519 01/16/2008 429167 SD000000000076180575 01/16/2008 429168 SD000000000076187819 <<2>> ==================================== Query: Select NVL(TO_CHAR(TO_DATE(WS.Received_Date, 'YYYY-MM-DD'), 'MM/DD/YYYY'), 'NA') As "Received_Date", NVL(pit.person_info_type_desc,' ') as "ReportingGroup", WS.WL_ID, NVL(WS.ACCESSION_ID, 'NA') As "ACCESSION_ID" From doc_mgmt.worklist_summary WS left join profiles.person_uuid U on ws.uuid = u.person_uuid left join profiles.person P on u.person_id = p.person_id left join profiles.person_info_list pil on p.person_id = pil.person_id and pil.person_info_cat_num = 5 and pil.person_info_actv = 'Y' left join profiles.person_info_type pit on pit.person_info_cat_num = pil.person_info_cat_num and pit.person_info_type_num = pil.person_info_type_num and pit.person_info_type_actv = 'Y' join DOC_MGMT.SLA_WORKLIST_SUMMARY WSUMM on WS.WL_ID = WSUMM.wl_id Where WSUMM.WL_STAT_TYPE_NUM IN (3, 10, 14, 15, 32, 16) AND ((WSUMM.SLA_Start_TS - sysdate)*24 + (Decode(SLA_Override_User_NM, NULL, SLA_VAL, Null)) + (Select Count(1)*24 From DOC_MGMT.SLA_HOLIDAY Where DATED Between WSUMM.SLA_Start_TS AND sysdate)) Between 0 and 2 Order By "Received_Date" Desc Output:(no rows) Recvd_Date| Report_Grp | Wl_id | acc_id ------------------------------------------------ <<3>> ==================================== Query: Select "Received_Date", "ReportingGroup", "WL_ID", "ACCESSION_ID" From (Select NVL(TO_CHAR(TO_DATE(WS.Received_Date, 'YYYY-MM-DD'), 'MM/DD/YYYY'), 'NA') As "Received_Date", NVL(pit.person_info_type_desc,' ') as "ReportingGroup", WS.WL_ID, NVL(WS.ACCESSION_ID, 'NA') As "ACCESSION_ID" From doc_mgmt.worklist_summary WS left join profiles.person_uuid U on ws.uuid = u.person_uuid left join profiles.person P on u.person_id = p.person_id left join profiles.person_info_list pil on p.person_id = pil.person_id and pil.person_info_cat_num = 5 and pil.person_info_actv = 'Y' left join profiles.person_info_type pit on pit.person_info_cat_num = pil.person_info_cat_num and pit.person_info_type_num = pil.person_info_type_num and pit.person_info_type_actv = 'Y' join DOC_MGMT.SLA_WORKLIST_SUMMARY WSUMM on WS.WL_ID = WSUMM.wl_id Where WSUMM.WL_STAT_TYPE_NUM IN (3, 10, 14, 15, 32, 16) AND ((WSUMM.SLA_Start_TS - sysdate)*24 + (Decode(SLA_Override_User_NM, NULL, SLA_VAL, Null)) + (Select Count(1)*24 From DOC_MGMT.SLA_HOLIDAY Where DATED Between WSUMM.SLA_Start_TS AND sysdate)) Between 0 and 2 Order By "Received_Date" Desc ) Output:(no Rows) Recvd_Date| Report_Grp | Wl_id | acc_id ------------------------------------------------