Toad World® Forums

object search with long list of Schemas yields incorrect results

I don’t know what the limit is for the number of Schemas, but at some point Toad splits up the IN clause and adds an OR clause without the appropriate parentheses, which, of course gives incorrect results.

This is the SQL:

Select owner, object_type,
CASE
WHEN INSTR (object_type, ‘PARTITION’) <> 0
THEN object_name
ELSE ‘’
END result_type,
CASE
WHEN INSTR (object_type, ‘PARTITION’) <> 0
THEN subobject_name
ELSE object_name
END object_name
FROM SYS.DBA_OBJECTS
WHERE UPPER(object_name) LIKE :olike ESCAPE ‘’
AND owner IN (‘CLT$EVENT_READER_D1’,‘CLT$EVENT_READER_D3’,‘CLT$EVENT_READER_FC’,‘CLT$EVENT_READER_PILOT_D1’,‘CLT$EVENT_READER_PILOT_D3’,‘CLT$EVENT_READER_PILOT_FC’,‘CLT$EVENT_READER_PILOT_Q1’,‘CLT$EVENT_READER_PILOT_Q2’,‘CLT$EVENT_READER_PILOT_Q3’,‘CLT$EVENT_READER_PILOT_Q4’,‘CLT$EVENT_READER_PILOT_Q5’,‘CLT$EVENT_READER_Q1’,‘CLT$EVENT_READER_Q2’,‘CLT$EVENT_READER_Q3’,‘CLT$EVENT_READER_Q4’,‘CLT$EVENT_READER_Q5’,‘CLT$NTM_CONTROL_D1’,‘CLT$NTM_CONTROL_D2’,‘CLT$NTM_CONTROL_D3’,‘CLT$NTM_CONTROL_FC’,‘CLT$NTM_CONTROL_PILOT_D1’,‘CLT$NTM_CONTROL_PILOT_D2’,‘CLT$NTM_CONTROL_PILOT_D3’,‘CLT$NTM_CONTROL_PILOT_FC’,‘CLT$NTM_CONTROL_PILOT_Q1’,‘CLT$NTM_CONTROL_PILOT_Q2’,‘CLT$NTM_CONTROL_PILOT_Q3’,‘CLT$NTM_CONTROL_PILOT_Q4’,‘CLT$NTM_CONTROL_PILOT_Q5’,‘CLT$NTM_CONTROL_Q1’,‘CLT$NTM_CONTROL_Q2’,‘CLT$NTM_CONTROL_Q3’,‘CLT$NTM_CONTROL_Q4’,‘CLT$NTM_CONTROL_Q5’,‘CLT$OSF_SIMULATOR_D1’,‘CLT$OSF_SIMULATOR_D3’,‘CLT$OSF_SIMULATOR_FC’,‘CLT$OSF_SIMULATOR_PILOT_D1’,‘CLT$OSF_SIMULATOR_PILOT_D3’,‘CLT$OSF_SIMULATOR_PILOT_FC’,‘CLT$OSF_SIMULATOR_PILOT_Q1’,‘CLT$OSF_SIMULATOR_PILOT_Q2’,‘CLT$OSF_SIMULATOR_PILOT_Q3’,‘CLT$OSF_SIMULATOR_PILOT_Q4’,‘CLT$OSF_SIMULATOR_PILOT_Q5’,‘CLT$OSF_SIMULATOR_Q1’,‘CLT$OSF_SIMULATOR_Q2’,‘CLT$OSF_SIMULATOR_Q3’,‘CLT$OSF_SIMULATOR_Q4’,‘CLT$OSF_SIMULATOR_Q5’,‘SVR$ACTDBL_D1’,‘SVR$ACTDBL_D3’,‘SVR$ACTDBL_FC’,‘SVR$ACTDBL_PILOT_D1’,‘SVR$ACTDBL_PILOT_D3’,‘SVR$ACTDBL_PILOT_FC’,‘SVR$ACTDBL_PILOT_Q1’,‘SVR$ACTDBL_PILOT_Q2’,‘SVR$ACTDBL_PILOT_Q3’,‘SVR$ACTDBL_PILOT_Q4’,‘SVR$ACTDBL_PILOT_Q5’,‘SVR$ACTDBL_Q1’,‘SVR$ACTDBL_Q2’,‘SVR$ACTDBL_Q3’,‘SVR$ACTDBL_Q4’,‘SVR$ACTDBL_Q5’,‘SVR$ACTR_D1’,‘SVR$ACTR_D3’,‘SVR$ACTR_FC’,‘SVR$ACTR_PILOT_D1’,‘SVR$ACTR_PILOT_D3’,‘SVR$ACTR_PILOT_FC’,‘SVR$ACTR_PILOT_Q1’,‘SVR$ACTR_PILOT_Q2’,‘SVR$ACTR_PILOT_Q3’,‘SVR$ACTR_PILOT_Q4’,‘SVR$ACTR_PILOT_Q5’,‘SVR$ACTR_Q1’,‘SVR$ACTR_Q2’,‘SVR$ACTR_Q3’,‘SVR$ACTR_Q4’,‘SVR$ACTR_Q5’,‘SVR$AMD_D1’,‘SVR$AMD_D3’,‘SVR$AMD_FC’,‘SVR$AMD_PILOT_D1’,‘SVR$AMD_PILOT_D3’,‘SVR$AMD_PILOT_FC’,‘SVR$AMD_PILOT_Q1’,‘SVR$AMD_PILOT_Q2’,‘SVR$AMD_PILOT_Q3’,‘SVR$AMD_PILOT_Q4’,‘SVR$AMD_PILOT_Q5’,‘SVR$AMD_Q1’,‘SVR$AMD_Q2’,‘SVR$AMD_Q3’,‘SVR$AMD_Q4’,‘SVR$AMD_Q5’,‘SVR$AUDIT_REPORTS’,‘SVR$BBOD_D1’,‘SVR$BBOD_D3’,‘SVR$BBOD_FC’,‘SVR$BBOD_PILOT_D1’,‘SVR$BBOD_PILOT_D3’,‘SVR$BBOD_PILOT_FC’,‘SVR$BBOD_PILOT_Q1’,‘SVR$BBOD_PILOT_Q2’,‘SVR$BBOD_PILOT_Q3’,‘SVR$BBOD_PILOT_Q4’,‘SVR$BBOD_PILOT_Q5’,‘SVR$BBOD_Q1’,‘SVR$BBOD_Q2’,‘SVR$BBOD_Q3’,‘SVR$BBOD_Q4’,‘SVR$BBOD_Q5’,‘SVR$BBODBL_D1’,‘SVR$BBODBL_D3’,‘SVR$BBODBL_PILOT_D1’,‘SVR$BBODBL_PILOT_D3’,‘SVR$BBODR_D1’,‘SVR$BBODR_D3’,‘SVR$BBODR_FC’,‘SVR$BBODR_PILOT_D1’,‘SVR$BBODR_PILOT_D3’,‘SVR$BBODR_PILOT_FC’,‘SVR$BBODR_PILOT_Q1’,‘SVR$BBODR_PILOT_Q2’,‘SVR$BBODR_PILOT_Q3’,‘SVR$BBODR_PILOT_Q4’,‘SVR$BBODR_PILOT_Q5’,‘SVR$BBODR_Q1’,‘SVR$BBODR_Q2’,‘SVR$BBODR_Q3’,‘SVR$BBODR_Q4’,‘SVR$BBODR_Q5’,‘SVR$BDC_D1’,‘SVR$BDC_D3’,‘SVR$BDC_FC’,‘SVR$BDC_PILOT_D1’,‘SVR$BDC_PILOT_D3’,‘SVR$BDC_PILOT_FC’,‘SVR$BDC_PILOT_Q1’,‘SVR$BDC_PILOT_Q2’,‘SVR$BDC_PILOT_Q3’,‘SVR$BDC_PILOT_Q4’,‘SVR$BDC_PILOT_Q5’,‘SVR$BDC_Q1’,‘SVR$BDC_Q2’,‘SVR$BDC_Q3’,‘SVR$BDC_Q4’,‘SVR$BDC_Q5’,‘SVR$BFD_D1’,‘SVR$BFD_D2’,‘SVR$BFD_D3’,‘SVR$BFD_FC’,‘SVR$BFD_PILOT_D1’,‘SVR$BFD_PILOT_D2’,‘SVR$BFD_PILOT_D3’,‘SVR$BFD_PILOT_FC’,‘SVR$BFD_PILOT_Q1’,‘SVR$BFD_PILOT_Q2’,‘SVR$BFD_PILOT_Q3’,‘SVR$BFD_PILOT_Q4’,‘SVR$BFD_PILOT_Q5’,‘SVR$BFD_Q1’,‘SVR$BFD_Q2’,‘SVR$BFD_Q3’,‘SVR$BFD_Q4’,‘SVR$BFD_Q5’,‘SVR$BFDR_D1’,‘SVR$BFDR_D3’,‘SVR$BFDR_FC’,‘SVR$BFDR_PILOT_D1’,‘SVR$BFDR_PILOT_D3’,‘SVR$BFDR_PILOT_FC’,‘SVR$BFDR_PILOT_Q1’,‘SVR$BFDR_PILOT_Q2’,‘SVR$BFDR_PILOT_Q4’,‘SVR$BFDR_PILOT_Q5’,‘SVR$BFDR_Q1’,‘SVR$BFDR_Q2’,‘SVR$BFDR_Q4’,‘SVR$BFDR_Q5’,‘SVR$BFRD_D1’,‘SVR$BFRD_D3’,‘SVR$BFRD_FC’,‘SVR$BFRD_PILOT_D1’,‘SVR$BFRD_PILOT_D3’,‘SVR$BFRD_PILOT_FC’,‘SVR$BFRD_PILOT_Q1’,‘SVR$BFRD_PILOT_Q2’,‘SVR$BFRD_PILOT_Q3’,‘SVR$BFRD_PILOT_Q4’,‘SVR$BFRD_PILOT_Q5’,‘SVR$BFRD_Q1’,‘SVR$BFRD_Q2’,‘SVR$BFRD_Q3’,‘SVR$BFRD_Q4’,‘SVR$BFRD_Q5’,‘SVR$BLBD_D1’,‘SVR$BLBD_D3’,‘SVR$BLBD_FC’,‘SVR$BLBD_PILOT_D1’,‘SVR$BLBD_PILOT_D3’,‘SVR$BLBD_PILOT_FC’,‘SVR$BLBD_PILOT_Q1’,‘SVR$BLBD_PILOT_Q2’,‘SVR$BLBD_PILOT_Q3’,‘SVR$BLBD_PILOT_Q4’,‘SVR$BLBD_PILOT_Q5’,‘SVR$BLBD_Q1’,‘SVR$BLBD_Q2’,‘SVR$BLBD_Q3’,‘SVR$BLBD_Q4’,‘SVR$BLBD_Q5’,‘SVR$BLFM_D1’,‘SVR$BLFM_D3’,‘SVR$BLFM_FC’,‘SVR$BLFM_PILOT_D1’,‘SVR$BLFM_PILOT_D3’,‘SVR$BLFM_PILOT_FC’,‘SVR$BLFM_PILOT_Q1’,‘SVR$BLFM_PILOT_Q2’,‘SVR$BLFM_PILOT_Q4’,‘SVR$BLFM_PILOT_Q5’,‘SVR$BLFM_Q1’,‘SVR$BLFM_Q2’,‘SVR$BLFM_Q4’,‘SVR$BLFM_Q5’,‘SVR$BLLM_D1’,‘SVR$BLLM_D3’,‘SVR$BLLM_FC’,‘SVR$BLLM_PILOT_D1’,‘SVR$BLLM_PILOT_D3’,‘SVR$BLLM_PILOT_FC’,‘SVR$BLLM_PILOT_Q1’,‘SVR$BLLM_PILOT_Q2’,‘SVR$BLLM_PILOT_Q3’,‘SVR$BLLM_PILOT_Q4’,‘SVR$BLLM_PILOT_Q5’,‘SVR$BLLM_Q1’,‘SVR$BLLM_Q2’,‘SVR$BLLM_Q3’,‘SVR$BLLM_Q4’,‘SVR$BLLM_Q5’,‘SVR$BLOC_D1’,‘SVR$BLOC_D3’,‘SVR$BLOC_FC’,‘SVR$BLOC_PILOT_D1’,‘SVR$BLOC_PILOT_D3’,‘SVR$BLOC_PILOT_FC’,‘SVR$BLOC_PILOT_Q1’,‘SVR$BLOC_PILOT_Q2’,‘SVR$BLOC_PILOT_Q3’,‘SVR$BLOC_PILOT_Q4’,‘SVR$BLOC_PILOT_Q5’,‘SVR$BLOC_Q1’,‘SVR$BLOC_Q2’,‘SVR$BLOC_Q3’,‘SVR$BLOC_Q4’,‘SVR$BLOC_Q5’,‘SVR$BLQM_D1’,‘SVR$BLQM_D3’,‘SVR$BLQM_FC’,‘SVR$BLQM_PILOT_D1’,‘SVR$BLQM_PILOT_D3’,‘SVR$BLQM_PILOT_FC’,‘SVR$BLQM_PILOT_Q1’,‘SVR$BLQM_PILOT_Q2’,‘SVR$BLQM_PILOT_Q3’,‘SVR$BLQM_PILOT_Q4’,‘SVR$BLQM_PILOT_Q5’,‘SVR$BLQM_Q1’,‘SVR$BLQM_Q2’,‘SVR$BLQM_Q3’,‘SVR$BLQM_Q4’,‘SVR$BLQM_Q5’,‘SVR$BPLX_D1’,‘SVR$BPLX_D2’,‘SVR$BPLX_D3’,‘SVR$BPLX_FC’,‘SVR$BPLX_PILOT_D1’,‘SVR$BPLX_PILOT_D2’,‘SVR$BPLX_PILOT_D3’,‘SVR$BPLX_PILOT_FC’,‘SVR$BPLX_PILOT_Q1’,‘SVR$BPLX_PILOT_Q2’,‘SVR$BPLX_PILOT_Q3’,‘SVR$BPLX_PILOT_Q4’,‘SVR$BPLX_PILOT_Q5’,‘SVR$BPLX_Q1’,‘SVR$BPLX_Q2’,‘SVR$BPLX_Q3’,‘SVR$BPLX_Q4’,‘SVR$BPLX_Q5’,‘SVR$BRKR_BACK_OFFICE_D1’,‘SVR$BRKR_BACK_OFFICE_D3’,‘SVR$BRKR_BACK_OFFICE_FC’,‘SVR$BRKR_BACK_OFFICE_PILOT_D1’,‘SVR$BRKR_BACK_OFFICE_PILOT_D3’,‘SVR$BRKR_BACK_OFFICE_PILOT_FC’,‘SVR$BRKR_BACK_OFFICE_PILOT_Q1’,‘SVR$BRKR_BACK_OFFICE_PILOT_Q2’,‘SVR$BRKR_BACK_OFFICE_PILOT_Q3’,‘SVR$BRKR_BACK_OFFICE_PILOT_Q4’,‘SVR$BRKR_BACK_OFFICE_PILOT_Q5’,‘SVR$BRKR_BACK_OFFICE_Q1’,‘SVR$BRKR_BACK_OFFICE_Q2’,‘SVR$BRKR_BACK_OFFICE_Q3’,‘SVR$BRKR_BACK_OFFICE_Q4’,‘SVR$BRKR_BACK_OFFICE_Q5’,‘SVR$CAS_D1’,‘SVR$CAS_PILOT_D1’,‘SVR$CMA_D1’,‘SVR$CMA_D2’,‘SVR$CMA_D3’,‘SVR$CMA_FC’,‘SVR$CMA_PILOT_D1’,‘SVR$CMA_PILOT_D2’,‘SVR$CMA_PILOT_D3’,‘SVR$CMA_PILOT_FC’,‘SVR$CMA_PILOT_Q1’,‘SVR$CMA_PILOT_Q2’,‘SVR$CMA_PILOT_Q3’,‘SVR$CMA_PILOT_Q4’,‘SVR$CMA_PILOT_Q5’,‘SVR$CMA_Q1’,‘SVR$CMA_Q2’,‘SVR$CMA_Q3’,‘SVR$CMA_Q4’,‘SVR$CMA_Q5’,‘SVR$CSI_D1’,‘SVR$CSI_D2’,‘SVR$CSI_D3’,‘SVR$CSI_FC’,‘SVR$CSI_PILOT_D1’,‘SVR$CSI_PILOT_D2’,‘SVR$CSI_PILOT_D3’,‘SVR$CSI_PILOT_FC’,‘SVR$CSI_PILOT_Q1’,‘SVR$CSI_PILOT_Q2’,‘SVR$CSI_PILOT_Q3’,‘SVR$CSI_PILOT_Q4’,‘SVR$CSI_PILOT_Q5’,‘SVR$CSI_Q1’,‘SVR$CSI_Q2’,‘SVR$CSI_Q3’,‘SVR$CSI_Q4’,‘SVR$CSI_Q5’,‘SVR$CWAS_D1’,‘SVR$CWAS_D3’,‘SVR$CWAS_PILOT_D1’,‘SVR$CWAS_PILOT_D3’,‘SVR$CWAS_PILOT_Q2’,‘SVR$CWAS_Q2’,‘SVR$CWDP_D1’,‘SVR$CWDP_D3’,‘SVR$CWDP_PILOT_D1’,‘SVR$CWDP_PILOT_D3’,‘SVR$CWDP_PILOT_Q2’,‘SVR$CWDP_Q2’,‘SVR$CWRG_D1’,‘SVR$CWRG_D3’,‘SVR$CWRG_FC’,‘SVR$CWRG_PILOT_D1’,‘SVR$CWRG_PILOT_D3’,‘SVR$CWRG_PILOT_FC’,‘SVR$CWRG_PILOT_Q1’,‘SVR$CWRG_PILOT_Q2’,‘SVR$CWRG_PILOT_Q3’,‘SVR$CWRG_PILOT_Q4’,‘SVR$CWRG_PILOT_Q5’,‘SVR$CWRG_Q1’,‘SVR$CWRG_Q2’,‘SVR$CWRG_Q3’,‘SVR$CWRG_Q4’,‘SVR$CWRG_Q5’,‘SVR$CWTM_D1’,‘SVR$CWTM_D3’,‘SVR$CWTM_PILOT_D1’,‘SVR$CWTM_PILOT_D3’,‘SVR$CWTM_PILOT_Q2’,‘SVR$CWTM_Q2’,‘SVR$DAS_D1’,‘SVR$DAS_D2’,‘SVR$DAS_D3’,‘SVR$DAS_FC’,‘SVR$DAS_PILOT_D1’,‘SVR$DAS_PILOT_D2’,‘SVR$DAS_PILOT_D3’,‘SVR$DAS_PILOT_FC’,‘SVR$DAS_PILOT_Q1’,‘SVR$DAS_PILOT_Q2’,‘SVR$DAS_PILOT_Q3’,‘SVR$DAS_PILOT_Q4’,‘SVR$DAS_PILOT_Q5’,‘SVR$DAS_Q1’,‘SVR$DAS_Q2’,‘SVR$DAS_Q3’,‘SVR$DAS_Q4’,‘SVR$DAS_Q5’,‘SVR$DCS_D1’,‘SVR$DCS_D3’,‘SVR$DCS_FC’,‘SVR$DCS_PILOT_D1’,‘SVR$DCS_PILOT_D3’,‘SVR$DCS_PILOT_FC’,‘SVR$DCS_PILOT_Q1’,‘SVR$DCS_PILOT_Q2’,‘SVR$DCS_PILOT_Q3’,‘SVR$DCS_PILOT_Q4’,‘SVR$DCS_PILOT_Q5’,‘SVR$DCS_Q1’,‘SVR$DCS_Q2’,‘SVR$DCS_Q3’,‘SVR$DCS_Q4’,‘SVR$DCS_Q5’,‘SVR$DCSF_D1’,‘SVR$DCSF_D3’,‘SVR$DCSF_FC’,‘SVR$DCSF_PILOT_D1’,‘SVR$DCSF_PILOT_D3’,‘SVR$DCSF_PILOT_FC’,‘SVR$DCSF_PILOT_Q1’,‘SVR$DCSF_PILOT_Q2’,‘SVR$DCSF_PILOT_Q3’,‘SVR$DCSF_PILOT_Q4’,‘SVR$DCSF_PILOT_Q5’,‘SVR$DCSF_Q1’,‘SVR$DCSF_Q2’,‘SVR$DCSF_Q3’,‘SVR$DCSF_Q4’,‘SVR$DCSF_Q5’,‘SVR$DCSR_D1’,‘SVR$DCSR_D3’,‘SVR$DCSR_FC’,‘SVR$DCSR_PILOT_D1’,‘SVR$DCSR_PILOT_D3’,‘SVR$DCSR_PILOT_FC’,‘SVR$DCSR_PILOT_Q1’,‘SVR$DCSR_PILOT_Q2’,‘SVR$DCSR_PILOT_Q3’,‘SVR$DCSR_PILOT_Q4’,‘SVR$DCSR_PILOT_Q5’,‘SVR$DCSR_Q1’,‘SVR$DCSR_Q2’,‘SVR$DCSR_Q3’,‘SVR$DCSR_Q4’,‘SVR$DCSR_Q5’,‘SVR$DLAC_D1’,‘SVR$DLAC_D3’,‘SVR$DLAC_FC’,‘SVR$DLAC_PILOT_D1’,‘SVR$DLAC_PILOT_D3’,‘SVR$DLAC_PILOT_FC’,‘SVR$DLAC_PILOT_Q1’,‘SVR$DLAC_PILOT_Q2’,‘SVR$DLAC_PILOT_Q3’,‘SVR$DLAC_PILOT_Q4’,‘SVR$DLAC_PILOT_Q5’,‘SVR$DLAC_Q1’,‘SVR$DLAC_Q2’,‘SVR$DLAC_Q3’,‘SVR$DLAC_Q4’,‘SVR$DLAC_Q5’,‘SVR$DLBP_D1’,‘SVR$DLBP_D3’,‘SVR$DLBP_FC’,‘SVR$DLBP_PILOT_D1’,‘SVR$DLBP_PILOT_D3’,‘SVR$DLBP_PILOT_FC’,‘SVR$DLBP_PILOT_Q1’,‘SVR$DLBP_PILOT_Q2’,‘SVR$DLBP_PILOT_Q4’,‘SVR$DLBP_PILOT_Q5’,‘SVR$DLBP_Q1’,‘SVR$DLBP_Q2’,‘SVR$DLBP_Q4’,‘SVR$DLBP_Q5’,‘SVR$DLCM_D1’,‘SVR$DLCM_D3’,‘SVR$DLCM_FC’,‘SVR$DLCM_PILOT_D1’,‘SVR$DLCM_PILOT_D3’,‘SVR$DLCM_PILOT_FC’,‘SVR$DLCM_PILOT_Q1’,‘SVR$DLCM_PILOT_Q2’,‘SVR$DLCM_PILOT_Q4’,‘SVR$DLCM_PILOT_Q5’,‘SVR$DLCM_Q1’,‘SVR$DLCM_Q2’,‘SVR$DLCM_Q4’,‘SVR$DLCM_Q5’,‘SVR$DLKS_D1’,‘SVR$DLKS_D3’,‘SVR$DLKS_FC’,‘SVR$DLKS_PILOT_D1’,‘SVR$DLKS_PILOT_D3’,‘SVR$DLKS_PILOT_FC’,‘SVR$DLKS_PILOT_Q1’,‘SVR$DLKS_PILOT_Q2’,‘SVR$DLKS_PILOT_Q4’,‘SVR$DLKS_PILOT_Q5’,‘SVR$DLKS_Q1’,‘SVR$DLKS_Q2’,‘SVR$DLKS_Q4’,‘SVR$DLKS_Q5’,‘SVR$DLME_D1’,‘SVR$DLME_D3’,‘SVR$DLME_FC’,‘SVR$DLME_PILOT_D1’,‘SVR$DLME_PILOT_D3’,‘SVR$DLME_PILOT_FC’,‘SVR$DLME_PILOT_Q1’,‘SVR$DLME_PILOT_Q2’,‘SVR$DLME_PILOT_Q4’,‘SVR$DLME_PILOT_Q5’,‘SVR$DLME_Q1’,‘SVR$DLME_Q2’,‘SVR$DLME_Q4’,‘SVR$DLME_Q5’,‘SVR$DLMM_D1’,‘SVR$DLMM_D3’,‘SVR$DLMM_FC’,‘SVR$DLMM_PILOT_D1’,‘SVR$DLMM_PILOT_D3’,‘SVR$DLMM_PILOT_FC’,‘SVR$DLMM_PILOT_Q1’,‘SVR$DLMM_PILOT_Q2’,‘SVR$DLMM_PILOT_Q4’,‘SVR$DLMM_PILOT_Q5’,‘SVR$DLMM_Q1’,‘SVR$DLMM_Q2’,‘SVR$DLMM_Q4’,‘SVR$DLMM_Q5’,‘SVR$DLOM_D1’,‘SVR$DLOM_D3’,‘SVR$DLOM_FC’,‘SVR$DLOM_PILOT_D1’,‘SVR$DLOM_PILOT_D3’,‘SVR$DLOM_PILOT_FC’,‘SVR$DLOM_PILOT_Q1’,‘SVR$DLOM_PILOT_Q2’,‘SVR$DLOM_PILOT_Q4’,‘SVR$DLOM_PILOT_Q5’,‘SVR$DLOM_Q1’,‘SVR$DLOM_Q2’,‘SVR$DLOM_Q4’,‘SVR$DLOM_Q5’,‘SVR$DLOR_D1’,‘SVR$DLOR_D3’,‘SVR$DLOR_FC’,‘SVR$DLOR_PILOT_D1’,‘SVR$DLOR_PILOT_D3’,‘SVR$DLOR_PILOT_FC’,‘SVR$DLOR_PILOT_Q1’,‘SVR$DLOR_PILOT_Q2’,‘SVR$DLOR_PILOT_Q4’,‘SVR$DLOR_PILOT_Q5’,‘SVR$DLOR_Q1’,‘SVR$DLOR_Q2’,‘SVR$DLOR_Q4’,‘SVR$DLOR_Q5’,‘SVR$DLQR_D1’,‘SVR$DLQR_D2’,‘SVR$DLQR_D3’,‘SVR$DLQR_FC’,‘SVR$DLQR_PILOT_D1’,‘SVR$DLQR_PILOT_D2’,‘SVR$DLQR_PILOT_D3’,‘SVR$DLQR_PILOT_FC’,‘SVR$DLQR_PILOT_Q1’,‘SVR$DLQR_PILOT_Q2’,‘SVR$DLQR_PILOT_Q3’,‘SVR$DLQR_PILOT_Q4’,‘SVR$DLQR_PILOT_Q5’,‘SVR$DLQR_Q1’,‘SVR$DLQR_Q2’,‘SVR$DLQR_Q3’,‘SVR$DLQR_Q4’,‘SVR$DLQR_Q5’,‘SVR$DLTR_D1’,‘SVR$DLTR_D2’,‘SVR$DLTR_D3’,‘SVR$DLTR_FC’,‘SVR$DLTR_PILOT_D1’,‘SVR$DLTR_PILOT_D2’,‘SVR$DLTR_PILOT_D3’,‘SVR$DLTR_PILOT_FC’,‘SVR$DLTR_PILOT_Q1’,‘SVR$DLTR_PILOT_Q2’,‘SVR$DLTR_PILOT_Q3’,‘SVR$DLTR_PILOT_Q4’,‘SVR$DLTR_PILOT_Q5’,‘SVR$DLTR_Q1’,‘SVR$DLTR_Q2’,‘SVR$DLTR_Q3’,‘SVR$DLTR_Q4’,‘SVR$DLTR_Q5’,‘SVR$DPB_D1’,‘SVR$DPB_D3’,‘SVR$DPB_FC’,‘SVR$DPB_PILOT_D1’,‘SVR$DPB_PILOT_D3’,‘SVR$DPB_PILOT_FC’,‘SVR$DPB_PILOT_Q1’,‘SVR$DPB_PILOT_Q2’,‘SVR$DPB_PILOT_Q4’,‘SVR$DPB_PILOT_Q5’,‘SVR$DPB_Q1’,‘SVR$DPB_Q2’,‘SVR$DPB_Q4’,‘SVR$DPB_Q5’,‘SVR$DSP_D1’,‘SVR$DSP_PILOT_D1’,‘SVR$DTCC_D1’,‘SVR$DTCC_D2’,‘SVR$DTCC_D3’,‘SVR$DTCC_FC’,‘SVR$DTCC_PILOT_D1’,‘SVR$DTCC_PILOT_D2’,‘SVR$DTCC_PILOT_D3’,‘SVR$DTCC_PILOT_FC’,‘SVR$DTCC_PILOT_Q1’,‘SVR$DTCC_PILOT_Q2’,‘SVR$DTCC_PILOT_Q3’,‘SVR$DTCC_PILOT_Q4’,‘SVR$DTCC_PILOT_Q5’,‘SVR$DTCC_Q1’,‘SVR$DTCC_Q2’,‘SVR$DTCC_Q3’,‘SVR$DTCC_Q4’,‘SVR$DTCC_Q5’,‘SVR$DTRF_D1’,‘SVR$DTRF_D3’,‘SVR$DTRF_FC’,‘SVR$DTRF_PILOT_D1’,‘SVR$DTRF_PILOT_D3’,‘SVR$DTRF_PILOT_FC’,‘SVR$DTRF_PILOT_Q1’,‘SVR$DTRF_PILOT_Q2’,‘SVR$DTRF_PILOT_Q4’,‘SVR$DTRF_PILOT_Q5’,‘SVR$DTRF_Q1’,‘SVR$DTRF_Q2’,‘SVR$DTRF_Q4’,‘SVR$DTRF_Q5’,‘SVR$ECHX_D1’,‘SVR$ECHX_D2’,‘SVR$ECHX_D3’,‘SVR$ECHX_FC’,‘SVR$ECHX_PILOT_D1’,‘SVR$ECHX_PILOT_D2’,‘SVR$ECHX_PILOT_D3’,‘SVR$ECHX_PILOT_FC’,‘SVR$ECHX_PILOT_Q1’,‘SVR$ECHX_PILOT_Q2’,‘SVR$ECHX_PILOT_Q3’,‘SVR$ECHX_PILOT_Q4’,‘SVR$ECHX_PILOT_Q5’,‘SVR$ECHX_Q1’,‘SVR$ECHX_Q2’,‘SVR$ECHX_Q3’,‘SVR$ECHX_Q4’,‘SVR$ECHX_Q5’,‘SVR$EMT_D1’,‘SVR$EMT_D2’,‘SVR$EMT_D3’,‘SVR$EMT_FC’,‘SVR$EMT_PILOT_D1’,‘SVR$EMT_PILOT_D2’,‘SVR$EMT_PILOT_D3’,‘SVR$EMT_PILOT_FC’,‘SVR$EMT_PILOT_Q1’,‘SVR$EMT_PILOT_Q2’,‘SVR$EMT_PILOT_Q3’,‘SVR$EMT_PILOT_Q4’,‘SVR$EMT_PILOT_Q5’,‘SVR$EMT_Q1’,‘SVR$EMT_Q2’,‘SVR$EMT_Q3’,‘SVR$EMT_Q4’,‘SVR$EMT_Q5’,‘SVR$FMR_D1’,‘SVR$FMR_D3’,‘SVR$FMR_FC’,‘SVR$FMR_PILOT_D1’,‘SVR$FMR_PILOT_D3’,‘SVR$FMR_PILOT_FC’,‘SVR$FMR_PILOT_Q1’,‘SVR$FMR_PILOT_Q2’,‘SVR$FMR_PILOT_Q3’,‘SVR$FMR_PILOT_Q4’,‘SVR$FMR_PILOT_Q5’,‘SVR$FMR_Q1’,‘SVR$FMR_Q2’,‘SVR$FMR_Q3’,‘SVR$FMR_Q4’,‘SVR$FMR_Q5’,‘SVR$FSD_D1’,‘SVR$FSD_D3’,‘SVR$FSD_FC’,‘SVR$FSD_PILOT_D1’,‘SVR$FSD_PILOT_D3’,‘SVR$FSD_PILOT_FC’,‘SVR$FSD_PILOT_Q1’,‘SVR$FSD_PILOT_Q2’,‘SVR$FSD_PILOT_Q4’,‘SVR$FSD_PILOT_Q5’,‘SVR$FSD_Q1’,‘SVR$FSD_Q2’,‘SVR$FSD_Q4’,‘SVR$FSD_Q5’,‘SVR$KILL_SWITCH_D1’,‘SVR$KILL_SWITCH_D3’,‘SVR$KILL_SWITCH_FC’,‘SVR$KILL_SWITCH_PILOT_D1’,‘SVR$KILL_SWITCH_PILOT_D3’,‘SVR$KILL_SWITCH_PILOT_FC’,‘SVR$KILL_SWITCH_PILOT_Q1’,‘SVR$KILL_SWITCH_PILOT_Q2’,‘SVR$KILL_SWITCH_PILOT_Q3’,‘SVR$KILL_SWITCH_PILOT_Q4’,‘SVR$KILL_SWITCH_PILOT_Q5’,‘SVR$KILL_SWITCH_Q1’,‘SVR$KILL_SWITCH_Q2’,‘SVR$KILL_SWITCH_Q3’,‘SVR$KILL_SWITCH_Q4’,‘SVR$KILL_SWITCH_Q5’,‘SVR$KSP_D1’,‘SVR$KSP_D3’,‘SVR$KSP_FC’,‘SVR$KSP_PILOT_D1’,‘SVR$KSP_PILOT_D3’,‘SVR$KSP_PILOT_FC’,‘SVR$KSP_PILOT_Q1’,‘SVR$KSP_PILOT_Q2’,‘SVR$KSP_PILOT_Q3’,‘SVR$KSP_PILOT_Q4’,‘SVR$KSP_PILOT_Q5’,‘SVR$KSP_Q1’,‘SVR$KSP_Q2’,‘SVR$KSP_Q3’,‘SVR$KSP_Q4’,‘SVR$KSP_Q5’,‘SVR$LSMR_D1’,‘SVR$LSMR_D3’,‘SVR$LSMR_FC’,‘SVR$LSMR_PILOT_D1’,‘SVR$LSMR_PILOT_D3’,‘SVR$LSMR_PILOT_FC’,‘SVR$LSMR_PILOT_Q1’,‘SVR$LSMR_PILOT_Q2’,‘SVR$LSMR_PILOT_Q3’,‘SVR$LSMR_PILOT_Q4’,‘SVR$LSMR_PILOT_Q5’,‘SVR$LSMR_Q1’,‘SVR$LSMR_Q2’,‘SVR$LSMR_Q3’,‘SVR$LSMR_Q4’,‘SVR$LSMR_Q5’,‘SVR$MAINT_D1’,‘SVR$MAINT_D2’,‘SVR$MAINT_D3’,‘SVR$MAINT_FC’,‘SVR$MAINT_PILOT_D1’,‘SVR$MAINT_PILOT_D2’,‘SVR$MAINT_PILOT_D3’,‘SVR$MAINT_PILOT_FC’,‘SVR$MAINT_PILOT_Q1’,‘SVR$MAINT_PILOT_Q2’,‘SVR$MAINT_PILOT_Q3’,‘SVR$MAINT_PILOT_Q4’,‘SVR$MAINT_PILOT_Q5’,‘SVR$MAINT_Q1’,‘SVR$MAINT_Q2’,‘SVR$MAINT_Q3’,‘SVR$MAINT_Q4’,‘SVR$MAINT_Q5’,‘SVR$MARS_D1’,‘SVR$MARS_D2’,‘SVR$MARS_D3’,‘SVR$MARS_FC’,‘SVR$MARS_PILOT_D1’,‘SVR$MARS_PILOT_D2’,‘SVR$MARS_PILOT_D3’,‘SVR$MARS_PILOT_FC’,‘SVR$MARS_PILOT_Q1’,‘SVR$MARS_PILOT_Q2’,‘SVR$MARS_PILOT_Q3’,‘SVR$MARS_PILOT_Q4’,‘SVR$MARS_PILOT_Q5’,‘SVR$MARS_Q1’,‘SVR$MARS_Q2’,‘SVR$MARS_Q3’,‘SVR$MARS_Q4’,‘SVR$MARS_Q5’,‘SVR$MD_MATCH_D1’,‘SVR$MD_MATCH_D3’,‘SVR$MD_MATCH_FC’,‘SVR$MD_MATCH_PILOT_D1’,‘SVR$MD_MATCH_PILOT_D3’,‘SVR$MD_MATCH_PILOT_FC’,‘SVR$MD_MATCH_PILOT_Q1’,‘SVR$MD_MATCH_PILOT_Q2’,‘SVR$MD_MATCH_PILOT_Q3’,‘SVR$MD_MATCH_PILOT_Q4’,‘SVR$MD_MATCH_PILOT_Q5’,‘SVR$MD_MATCH_Q1’,‘SVR$MD_MATCH_Q2’,‘SVR$MD_MATCH_Q3’,‘SVR$MD_MATCH_Q4’,‘SVR$MD_MATCH_Q5’,‘SVR$MDM_D1’,‘SVR$MDM_D3’,‘SVR$MDM_FC’,‘SVR$MDM_PILOT_D1’,‘SVR$MDM_PILOT_D3’,‘SVR$MDM_PILOT_FC’,‘SVR$MDM_PILOT_Q1’,‘SVR$MDM_PILOT_Q2’,‘SVR$MDM_PILOT_Q4’,‘SVR$MDM_PILOT_Q5’,‘SVR$MDM_Q1’,‘SVR$MDM_Q2’,‘SVR$MDM_Q4’,‘SVR$MDM_Q5’,‘SVR$MDP_D1’,‘SVR$MDP_D2’,‘SVR$MDP_D3’,‘SVR$MDP_FC’,‘SVR$MDP_PILOT_D1’,‘SVR$MDP_PILOT_D2’,‘SVR$MDP_PILOT_D3’,‘SVR$MDP_PILOT_FC’,‘SVR$MDP_PILOT_Q1’,‘SVR$MDP_PILOT_Q2’,‘SVR$MDP_PILOT_Q3’,‘SVR$MDP_PILOT_Q4’,‘SVR$MDP_PILOT_Q5’,‘SVR$MDP_Q1’,‘SVR$MDP_Q2’,‘SVR$MDP_Q3’,‘SVR$MDP_Q4’,‘SVR$MDP_Q5’,‘SVR$ME_D1’,‘SVR$ME_D3’,‘SVR$ME_FC’,‘SVR$ME_PILOT_D1’,‘SVR$ME_PILOT_D3’,‘SVR$ME_PILOT_FC’,‘SVR$ME_PILOT_Q1’,‘SVR$ME_PILOT_Q2’,‘SVR$ME_PILOT_Q4’,‘SVR$ME_PILOT_Q5’,‘SVR$ME_Q1’,‘SVR$ME_Q2’,‘SVR$ME_Q4’,‘SVR$ME_Q5’,‘SVR$MKT_DATA_D1’,‘SVR$MKT_DATA_D2’,‘SVR$MKT_DATA_D3’,‘SVR$MKT_DATA_FC’,‘SVR$MKT_DATA_PILOT_D1’,‘SVR$MKT_DATA_PILOT_D2’,‘SVR$MKT_DATA_PILOT_D3’,‘SVR$MKT_DATA_PILOT_FC’,‘SVR$MKT_DATA_PILOT_Q1’,‘SVR$MKT_DATA_PILOT_Q2’,‘SVR$MKT_DATA_PILOT_Q3’,‘SVR$MKT_DATA_PILOT_Q4’,‘SVR$MKT_DATA_PILOT_Q5’,‘SVR$MKT_DATA_Q1’,‘SVR$MKT_DATA_Q2’,‘SVR$MKT_DATA_Q3’,‘SVR$MKT_DATA_Q4’,‘SVR$MKT_DATA_Q5’,‘SVR$MPU_D1’,‘SVR$MPU_D3’,‘SVR$MPU_FC’,‘SVR$MPU_PILOT_D1’,‘SVR$MPU_PILOT_D3’,‘SVR$MPU_PILOT_FC’,‘SVR$MPU_PILOT_Q1’,‘SVR$MPU_PILOT_Q2’,‘SVR$MPU_PILOT_Q4’,‘SVR$MPU_PILOT_Q5’,‘SVR$MPU_Q1’,‘SVR$MPU_Q2’,‘SVR$MPU_Q4’,‘SVR$MPU_Q5’,‘SVR$NSPR_D1’,‘SVR$NSPR_D3’,‘SVR$NSPR_FC’,‘SVR$NSPR_PILOT_D1’,‘SVR$NSPR_PILOT_D3’,‘SVR$NSPR_PILOT_FC’,‘SVR$NSPR_PILOT_Q1’,‘SVR$NSPR_PILOT_Q2’,‘SVR$NSPR_PILOT_Q4’,‘SVR$NSPR_PILOT_Q5’,‘SVR$NSPR_Q1’,‘SVR$NSPR_Q2’,‘SVR$NSPR_Q4’,‘SVR$NSPR_Q5’,‘SVR$OATS_D1’,‘SVR$OATS_D3’,‘SVR$OATS_FC’,‘SVR$OATS_Q1’,‘SVR$OATS_Q2’,‘SVR$OATS_Q3’,‘SVR$OATS_Q4’,‘SVR$OATS_Q5’,‘SVR$OC_D1’,‘SVR$OC_D2’,‘SVR$OC_D3’,‘SVR$OC_FC’,‘SVR$OC_PILOT_D1’,‘SVR$OC_PILOT_D2’,‘SVR$OC_PILOT_D3’,‘SVR$OC_PILOT_FC’,‘SVR$OC_PILOT_Q1’,‘SVR$OC_PILOT_Q2’,‘SVR$OC_PILOT_Q3’,‘SVR$OC_PILOT_Q4’,‘SVR$OC_PILOT_Q5’,‘SVR$OC_Q1’,‘SVR$OC_Q2’,‘SVR$OC_Q3’,‘SVR$OC_Q4’,‘SVR$OC_Q5’,‘SVR$OCS_D1’,‘SVR$OCS_D3’,‘SVR$OCS_FC’,‘SVR$OCS_PILOT_D1’,‘SVR$OCS_PILOT_D3’,‘SVR$OCS_PILOT_FC’,‘SVR$OCS_PILOT_Q1’,‘SVR$OCS_PILOT_Q2’,‘SVR$OCS_PILOT_Q3’,‘SVR$OCS_PILOT_Q4’,‘SVR$OCS_PILOT_Q5’,‘SVR$OCS_Q1’,‘SVR$OCS_Q2’,‘SVR$OCS_Q3’,‘SVR$OCS_Q4’,‘SVR$OCS_Q5’,‘SVR$OMS_D1’,‘SVR$OMS_D2’,‘SVR$OMS_D3’,‘SVR$OMS_FC’,‘SVR$OMS_PILOT_D1’,‘SVR$OMS_PILOT_D2’,‘SVR$OMS_PILOT_D3’,‘SVR$OMS_PILOT_FC’,‘SVR$OMS_PILOT_Q1’,‘SVR$OMS_PILOT_Q2’,‘SVR$OMS_PILOT_Q3’,‘SVR$OMS_PILOT_Q4’,‘SVR$OMS_PILOT_Q5’,‘SVR$OMS_Q1’,‘SVR$OMS_Q2’,‘SVR$OMS_Q3’,‘SVR$OMS_Q4’,‘SVR$OMS_Q5’,‘SVR$OMSB_D1’,‘SVR$OMSB_D3’,‘SVR$OMSB_FC’,‘SVR$OMSB_PILOT_D1’,‘SVR$OMSB_PILOT_D3’,‘SVR$OMSB_PILOT_FC’,‘SVR$OMSB_PILOT_Q1’,‘SVR$OMSB_PILOT_Q2’,‘SVR$OMSB_PILOT_Q3’,‘SVR$OMSB_PILOT_Q4’,‘SVR$OMSB_PILOT_Q5’,‘SVR$OMSB_Q1’,‘SVR$OMSB_Q2’,‘SVR$OMSB_Q3’,‘SVR$OMSB_Q4’,‘SVR$OMSB_Q5’,‘SVR$ORS_D1’,‘SVR$ORS_D3’,‘SVR$ORS_FC’,‘SVR$ORS_PILOT_D1’,‘SVR$ORS_PILOT_D3’,‘SVR$ORS_PILOT_FC’,‘SVR$ORS_PILOT_Q1’,‘SVR$ORS_PILOT_Q2’,‘SVR$ORS_PILOT_Q3’,‘SVR$ORS_PILOT_Q4’,‘SVR$ORS_PILOT_Q5’,‘SVR$ORS_Q1’,‘SVR$ORS_Q2’,‘SVR$ORS_Q3’,‘SVR$ORS_Q4’,‘SVR$ORS_Q5’,‘SVR$QMTR_D1’,‘SVR$QMTR_D3’,‘SVR$QMTR_FC’) OR owner IN (‘SVR$QMTR_PILOT_D1’,‘SVR$QMTR_PILOT_D3’,‘SVR$QMTR_PILOT_FC’,‘SVR$QMTR_PILOT_Q1’,‘SVR$QMTR_PILOT_Q2’,‘SVR$QMTR_PILOT_Q3’,‘SVR$QMTR_PILOT_Q4’,‘SVR$QMTR_PILOT_Q5’,‘SVR$QMTR_Q1’,‘SVR$QMTR_Q2’,‘SVR$QMTR_Q3’,‘SVR$QMTR_Q4’,‘SVR$QMTR_Q5’,‘SVR$QRS_D1’,‘SVR$QRS_D3’,‘SVR$QRS_FC’,‘SVR$QRS_PILOT_D1’,‘SVR$QRS_PILOT_D3’,‘SVR$QRS_PILOT_FC’,‘SVR$QRS_PILOT_Q1’,‘SVR$QRS_PILOT_Q2’,‘SVR$QRS_PILOT_Q3’,‘SVR$QRS_PILOT_Q4’,‘SVR$QRS_PILOT_Q5’,‘SVR$QRS_Q1’,‘SVR$QRS_Q2’,‘SVR$QRS_Q3’,‘SVR$QRS_Q4’,‘SVR$QRS_Q5’,‘SVR$QRSR_D1’,‘SVR$QRSR_D3’,‘SVR$QRSR_FC’,‘SVR$QRSR_PILOT_D1’,‘SVR$QRSR_PILOT_D3’,‘SVR$QRSR_PILOT_FC’,‘SVR$QRSR_PILOT_Q1’,‘SVR$QRSR_PILOT_Q2’,‘SVR$QRSR_PILOT_Q4’,‘SVR$QRSR_PILOT_Q5’,‘SVR$QRSR_Q1’,‘SVR$QRSR_Q2’,‘SVR$QRSR_Q4’,‘SVR$QRSR_Q5’,‘SVR$RDC_D1’,‘SVR$RDC_D2’,‘SVR$RDC_D3’,‘SVR$RDC_FC’,‘SVR$RDC_PILOT_D1’,‘SVR$RDC_PILOT_D2’,‘SVR$RDC_PILOT_D3’,‘SVR$RDC_PILOT_FC’,‘SVR$RDC_PILOT_Q1’,‘SVR$RDC_PILOT_Q2’,‘SVR$RDC_PILOT_Q3’,‘SVR$RDC_PILOT_Q4’,‘SVR$RDC_PILOT_Q5’,‘SVR$RDC_Q1’,‘SVR$RDC_Q2’,‘SVR$RDC_Q3’,‘SVR$RDC_Q4’,‘SVR$RDC_Q5’,‘SVR$RTC_D1’,‘SVR$RTC_D3’,‘SVR$RTC_FC’,‘SVR$RTC_PILOT_D1’,‘SVR$RTC_PILOT_D3’,‘SVR$RTC_PILOT_FC’,‘SVR$RTC_PILOT_Q1’,‘SVR$RTC_PILOT_Q2’,‘SVR$RTC_PILOT_Q3’,‘SVR$RTC_PILOT_Q4’,‘SVR$RTC_PILOT_Q5’,‘SVR$RTC_Q1’,‘SVR$RTC_Q2’,‘SVR$RTC_Q3’,‘SVR$RTC_Q4’,‘SVR$RTC_Q5’,‘SVR$TAS_D1’,‘SVR$TAS_D3’,‘SVR$TAS_FC’,‘SVR$TAS_PILOT_D1’,‘SVR$TAS_PILOT_D3’,‘SVR$TAS_PILOT_FC’,‘SVR$TAS_PILOT_Q1’,‘SVR$TAS_PILOT_Q2’,‘SVR$TAS_PILOT_Q4’,‘SVR$TAS_PILOT_Q5’,‘SVR$TAS_Q1’,‘SVR$TAS_Q2’,‘SVR$TAS_Q4’,‘SVR$TAS_Q5’,‘SVR$TMS_D1’,‘SVR$TMS_PILOT_D1’,‘SVR$TRADE_ACK_D1’,‘SVR$TRADE_ACK_D3’,‘SVR$TRADE_ACK_FC’,‘SVR$TRADE_ACK_PILOT_D1’,‘SVR$TRADE_ACK_PILOT_D3’,‘SVR$TRADE_ACK_PILOT_FC’,‘SVR$TRADE_ACK_PILOT_Q1’,‘SVR$TRADE_ACK_PILOT_Q2’,‘SVR$TRADE_ACK_PILOT_Q3’,‘SVR$TRADE_ACK_PILOT_Q4’,‘SVR$TRADE_ACK_PILOT_Q5’,‘SVR$TRADE_ACK_Q1’,‘SVR$TRADE_ACK_Q2’,‘SVR$TRADE_ACK_Q3’,‘SVR$TRADE_ACK_Q4’,‘SVR$TRADE_ACK_Q5’,‘SVR$TRF_D1’,‘SVR$TRF_D3’,‘SVR$TRF_FC’,‘SVR$TRF_PILOT_D1’,‘SVR$TRF_PILOT_D3’,‘SVR$TRF_PILOT_FC’,‘SVR$TRF_PILOT_Q1’,‘SVR$TRF_PILOT_Q2’,‘SVR$TRF_PILOT_Q3’,‘SVR$TRF_PILOT_Q4’,‘SVR$TRF_PILOT_Q5’,‘SVR$TRF_Q1’,‘SVR$TRF_Q2’,‘SVR$TRF_Q3’,‘SVR$TRF_Q4’,‘SVR$TRF_Q5’,‘SVR$TRS_D1’,‘SVR$TRS_D3’,‘SVR$TRS_FC’,‘SVR$TRS_PILOT_D1’,‘SVR$TRS_PILOT_D3’,‘SVR$TRS_PILOT_FC’,‘SVR$TRS_PILOT_Q1’,‘SVR$TRS_PILOT_Q2’,‘SVR$TRS_PILOT_Q3’,‘SVR$TRS_PILOT_Q4’,‘SVR$TRS_PILOT_Q5’,‘SVR$TRS_Q1’,‘SVR$TRS_Q2’,‘SVR$TRS_Q3’,‘SVR$TRS_Q4’,‘SVR$TRS_Q5’,‘SVR$TRSR_D1’,‘SVR$TRSR_D3’,‘SVR$TRSR_FC’,‘SVR$TRSR_PILOT_D1’,‘SVR$TRSR_PILOT_D3’,‘SVR$TRSR_PILOT_FC’,‘SVR$TRSR_PILOT_Q1’,‘SVR$TRSR_PILOT_Q2’,‘SVR$TRSR_PILOT_Q3’,‘SVR$TRSR_PILOT_Q4’,‘SVR$TRSR_PILOT_Q5’,‘SVR$TRSR_Q1’,‘SVR$TRSR_Q2’,‘SVR$TRSR_Q3’,‘SVR$TRSR_Q4’,‘SVR$TRSR_Q5’,‘SVR$TXR_D1’,‘SVR$TXR_D3’,‘SVR$TXR_FC’,‘SVR$TXR_PILOT_D1’,‘SVR$TXR_PILOT_D3’,‘SVR$TXR_PILOT_FC’,‘SVR$TXR_PILOT_Q1’,‘SVR$TXR_PILOT_Q2’,‘SVR$TXR_PILOT_Q3’,‘SVR$TXR_PILOT_Q4’,‘SVR$TXR_PILOT_Q5’,‘SVR$TXR_Q1’,‘SVR$TXR_Q2’,‘SVR$TXR_Q3’,‘SVR$TXR_Q4’,‘SVR$TXR_Q5’)
AND object_type in (‘PACKAGE’,‘PACKAGE BODY’,‘PROCEDURE’,‘SEQUENCE’,‘SYNONYM’,‘TABLE’,‘VIEW’)
:olike(VARCHAR[18])=‘ME_RECOVERY_QRY%’

The limit is 1000. I’ll take a look at the query. Thanks.

Thanks.