|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2008-11-04 : 06:31:12
|
| The 2000 server which has been "crashing" apparently with my SELECT queries doesn't have AWE ticked. I read your AWE link. What would change if I told the bosses to activate AWE? Is it significant? The RAM is only 3.3Gb and I thought more could do no harm but it Standard Edition. No chance of more RAM I think.Is this even a problem at all??My view is a really reduced version of.... the below. All my work relies on it and no errors running this in Management Studio. Problems arise when a web-based report viewer (I'm not reponsible for) uses the viewUSE [ServiceDeskDB]GO/****** Object: View [dbo].[v_service_today] Script Date: 11/04/2008 12:46:44 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER VIEW [dbo].[v_service_today] AS SELECT T10101.prj_oid AS object_id,T10101.prj_description AS description,T10101.prj_id AS id, CAST(281478598230022 AS NUMERIC) AS item_type,T10101.prj_actual_cost AS actual_cost,T10101.prj_actual_duration AS actual_duration,T10101.prj_actual_start + CAST(1.0 AS DECIMAL)/24 AS actual_start,T10103.rct_name AS category_service_today_,T10101.prj_cat_oid AS category_service_today_object_,T10104.per_name AS change_owner_name,T10101.prj_initiator_per_oid AS change_owner_object_id,T10101.prj_actual_finish + CAST(1.0 AS DECIMAL)/24 AS closed_date,T10101.prj_deadline + CAST(1.0 AS DECIMAL)/24 AS deadline,T10101.prj_early_finish + CAST(1.0 AS DECIMAL)/24 AS early_finish,T10101.prj_early_start + CAST(1.0 AS DECIMAL)/24 AS early_start,T10105.per_name AS entered_by_person_name,T10101.slc_prj_per_oid AS entered_by_person_object_id,T10107.rct_name AS folder,T10101.prj_poo_oid AS folder_object_id,T10109.cdl_name AS impact,T10101.prj_imp_oid AS impact_object_id,T10110.pif_information AS information,T10101.prj_late_finish + CAST(1.0 AS DECIMAL)/24 AS late_finish,T10101.prj_late_start + CAST(1.0 AS DECIMAL)/24 AS late_start,T10101.prj_maximum_duration AS max_duration,T10101.prj_planned_cost AS planned_cost,T10101.prj_plan_duration AS planned_duration,T10101.prj_plan_finish + CAST(1.0 AS DECIMAL)/24 AS planned_finish,T10101.prj_plan_start + CAST(1.0 AS DECIMAL)/24 AS planned_start,T10112.cdl_name AS priority,T10101.prj_pri_oid AS priority_object_id,T10113.per_name AS requestor_name,T10101.prj_requestor_per_oid AS requestor_object_id,T10101.prj_sourceid AS source_id,T10115.rct_name AS status_service_today_,T10101.prj_sta_oid AS status_service_today_object_id,T10116.tem_name AS template_name,T10101.prj_tem_oid AS template_object_id,T10101.prj_apt_nrofapproversrequired AS approvers_required,T10117.wog_name AS approval_group_name,T10101.prj_apt_wog_oid AS approval_group_object_id,T10119.cdl_name AS approval_status,T10101.prj_apt_status AS approval_status_object_id,T10101.prj_apt_deadline + CAST(1.0 AS DECIMAL)/24 AS approval_approvaldeadline,T10101.prj_apt_description AS approval_description,T10121.cdl_name AS assignment_priority,T10101.prj_assign_priority AS assignment_priority_object_id,T10123.cdl_name AS assignment_status,T10101.prj_assign_status AS assignment_status_object_id,T10101.prj_assign_extdeadline + CAST(1.0 AS DECIMAL)/24 AS external_deadline,T10124.per_name AS from_person_name,T10101.prj_ass_per_from_oid AS from_person_object_id,T10125.wog_name AS from_workgroup_name,T10101.prj_ass_wog_from_oid AS from_workgroup_object_id,T10126.pra_ass_information AS information_from_sender,T10101.prj_assign_reference AS reference_,T10127.org_name1 AS to_external_organization_name,T10101.prj_ass_contr_out_org AS to_external_organization_objec,T10128.per_name AS to_external_person_name,T10101.prj_ass_contr_out_per AS to_external_person_object_id,T10129.per_name AS to_person_name,T10101.prj_ass_per_to_oid AS to_person_object_id,T10130.wog_name AS to_workgroup_name,T10101.prj_ass_wog_oid AS to_workgroup_object_id,T10101.prj_attachment_exists AS attachment_exists,T10101.prj_created + CAST(1.0 AS DECIMAL)/24 AS created,T10131.acc_showname AS created_by_display_name,T10101.prj_cre_acc_oid AS created_by_object_id,T10101.prj_modified + CAST(1.0 AS DECIMAL)/24 AS modified,T10132.acc_showname AS modified_by_display_name,T10101.prj_mod_acc_oid AS modified_by_object_idFROM ((((((((((((((((((((((((((((((( itsm_projects T10101 LEFT OUTER JOIN rep_accounts T10132 ON (T10132.acc_oid = T10101.prj_mod_acc_oid)) LEFT OUTER JOIN itsm_workgroups T10130 ON (T10130.wog_oid = T10101.prj_ass_wog_oid)) LEFT OUTER JOIN itsm_persons T10129 ON (T10129.per_oid = T10101.prj_ass_per_to_oid)) LEFT OUTER JOIN itsm_persons T10128 ON (T10128.per_oid = T10101.prj_ass_contr_out_per)) LEFT OUTER JOIN itsm_organizations T10127 ON (T10127.org_oid = T10101.prj_ass_contr_out_org)) LEFT OUTER JOIN itsm_prj_ass_information T10126 ON (T10126.pra_prj_oid = T10101.prj_oid)) LEFT OUTER JOIN itsm_workgroups T10125 ON (T10125.wog_oid = T10101.prj_ass_wog_from_oid)) LEFT OUTER JOIN itsm_persons T10124 ON (T10124.per_oid = T10101.prj_ass_per_from_oid)) LEFT OUTER JOIN itsm_codes T10122 ON (T10122.cod_oid = T10101.prj_assign_status)) LEFT OUTER JOIN itsm_codes_locale T10123 ON (T10123.cdl_cod_oid = T10122.cod_oid)) LEFT OUTER JOIN itsm_codes T10120 ON (T10120.cod_oid = T10101.prj_assign_priority)) LEFT OUTER JOIN itsm_codes_locale T10121 ON (T10121.cdl_cod_oid = T10120.cod_oid)) LEFT OUTER JOIN itsm_codes T10118 ON (T10118.cod_oid = T10101.prj_apt_status)) LEFT OUTER JOIN itsm_codes_locale T10119 ON (T10119.cdl_cod_oid = T10118.cod_oid)) LEFT OUTER JOIN itsm_workgroups T10117 ON (T10117.wog_oid = T10101.prj_apt_wog_oid)) LEFT OUTER JOIN rep_templates T10116 ON (T10116.tem_oid = T10101.prj_tem_oid)) LEFT OUTER JOIN rep_codes T10114 ON (T10114.rcd_oid = T10101.prj_sta_oid)) LEFT OUTER JOIN rep_codes_text T10115 ON (T10115.rct_rcd_oid = T10114.rcd_oid)) LEFT OUTER JOIN itsm_persons T10113 ON (T10113.per_oid = T10101.prj_requestor_per_oid)) LEFT OUTER JOIN itsm_codes T10111 ON (T10111.cod_oid = T10101.prj_pri_oid)) LEFT OUTER JOIN itsm_codes_locale T10112 ON (T10112.cdl_cod_oid = T10111.cod_oid)) LEFT OUTER JOIN itsm_prj_information T10110 ON (T10110.pif_prj_oid = T10101.prj_oid)) LEFT OUTER JOIN itsm_codes T10108 ON (T10108.cod_oid = T10101.prj_imp_oid)) LEFT OUTER JOIN itsm_codes_locale T10109 ON (T10109.cdl_cod_oid = T10108.cod_oid)) LEFT OUTER JOIN rep_codes T10106 ON (T10106.rcd_oid = T10101.prj_poo_oid)) LEFT OUTER JOIN rep_codes_text T10107 ON (T10107.rct_rcd_oid = T10106.rcd_oid)) LEFT OUTER JOIN itsm_persons T10105 ON (T10105.per_oid = T10101.slc_prj_per_oid)) LEFT OUTER JOIN itsm_persons T10104 ON (T10104.per_oid = T10101.prj_initiator_per_oid)) LEFT OUTER JOIN rep_codes T10102 ON (T10102.rcd_oid = T10101.prj_cat_oid)) LEFT OUTER JOIN rep_codes_text T10103 ON (T10103.rct_rcd_oid = T10102.rcd_oid)) INNER JOIN rep_accounts T10131 ON (T10131.acc_oid = T10101.prj_cre_acc_oid))WHERE ((T10103.rct_lng_oid IS NULL OR T10103.rct_lng_oid = 1033)AND (T10107.rct_lng_oid IS NULL OR T10107.rct_lng_oid = 1033)AND (T10109.cdl_lng_oid IS NULL OR T10109.cdl_lng_oid = 1033)AND (T10112.cdl_lng_oid IS NULL OR T10112.cdl_lng_oid = 1033)AND (T10115.rct_lng_oid IS NULL OR T10115.rct_lng_oid = 1033)AND (T10119.cdl_lng_oid IS NULL OR T10119.cdl_lng_oid = 1033)AND (T10121.cdl_lng_oid IS NULL OR T10121.cdl_lng_oid = 1033)AND (T10123.cdl_lng_oid IS NULL OR T10123.cdl_lng_oid = 1033))UNION ALLSELECT T30101.wor_oid AS object_id,T30101.wor_description AS description,T30101.wor_id AS id, CAST(556859410 AS NUMERIC) AS item_type,T30101.wor_actualcost AS actual_cost,T30101.wor_actualduration AS actual_duration,T30101.wor_actualstart + CAST(1.0 AS DECIMAL)/24 AS actual_start,T30103.rct_name AS category_service_today_,T30101.wor_cat_oid AS category_service_today_object_,T30104.per_name AS change_owner_name,T30101.wor_initiator_per_oid AS change_owner_object_id,T30101.wor_actualfinish + CAST(1.0 AS DECIMAL)/24 AS closed_date,T30101.wor_deadline + CAST(1.0 AS DECIMAL)/24 AS deadline,T30101.wor_earlyfinish + CAST(1.0 AS DECIMAL)/24 AS early_finish,T30101.wor_earlystart + CAST(1.0 AS DECIMAL)/24 AS early_start,T30105.per_name AS entered_by_person_name,T30101.slc_wor_per_oid AS entered_by_person_object_id,T30107.rct_name AS folder,T30101.wor_poo_oid AS folder_object_id,T30109.cdl_name AS impact,T30101.wor_imp_oid AS impact_object_id,T30110.woi_information AS information,T30101.wor_latefinish + CAST(1.0 AS DECIMAL)/24 AS late_finish,T30101.wor_latestart + CAST(1.0 AS DECIMAL)/24 AS late_start,T30101.wor_maximumduration AS max_duration,T30101.wor_plannedcost AS planned_cost,T30101.wor_planduration AS planned_duration,T30101.wor_planfinish + CAST(1.0 AS DECIMAL)/24 AS planned_finish,T30101.wor_planstart + CAST(1.0 AS DECIMAL)/24 AS planned_start,T30112.cdl_name AS priority,T30101.wor_pri_oid AS priority_object_id,T30113.per_name AS requestor_name,T30101.wor_requestor_per_oid AS requestor_object_id,T30101.wor_sourceid AS source_id,T30115.rct_name AS status_service_today_,T30101.wor_sta_oid AS status_service_today_object_id,T30116.tem_name AS template_name,T30101.wor_tem_oid AS template_object_id,T30101.wor_apt_nrofapproversrequired AS approvers_required,T30117.wog_name AS approval_group_name,T30101.wor_apt_wog_oid AS approval_group_object_id,T30119.cdl_name AS approval_status,T30101.wor_apt_status AS approval_status_object_id,T30101.wor_apt_deadline + CAST(1.0 AS DECIMAL)/24 AS approval_approvaldeadline,T30101.wor_apt_description AS approval_description,T30121.cdl_name AS assignment_priority,T30101.wor_assignpriority AS assignment_priority_object_id,T30123.cdl_name AS assignment_status,T30101.ass_assignstatus AS assignment_status_object_id,T30101.wor_assign_extdeadline + CAST(1.0 AS DECIMAL)/24 AS external_deadline,T30124.per_name AS from_person_name,T30101.ass_per_from_oid AS from_person_object_id,T30125.wog_name AS from_workgroup_name,T30101.ass_wog_from_oid AS from_workgroup_object_id,T30126.wai_ass_information AS information_from_sender,T30101.wor_assign_referencenumber AS reference_,T30127.org_name1 AS to_external_organization_name,T30101.ass_contr_out_org AS to_external_organization_objec,T30128.per_name AS to_external_person_name,T30101.ass_contr_out_per AS to_external_person_object_id,T30129.per_name AS to_person_name,T30101.ass_per_to_oid AS to_person_object_id,T30130.wog_name AS to_workgroup_name,T30101.ass_workgroup AS to_workgroup_object_id,T30101.wor_attachment_exists AS attachment_exists,T30101.reg_created + CAST(1.0 AS DECIMAL)/24 AS created,T30131.acc_showname AS created_by_display_name,T30101.reg_created_by_oid AS created_by_object_id,T30101.reg_modified + CAST(1.0 AS DECIMAL)/24 AS modified,T30132.acc_showname AS modified_by_display_name,T30101.reg_modified_by_oid AS modified_by_object_idFROM ((((((((((((((((((((((((((((((( itsm_workorders T30101 LEFT OUTER JOIN rep_accounts T30132 ON (T30132.acc_oid = T30101.reg_modified_by_oid)) LEFT OUTER JOIN itsm_workgroups T30130 ON (T30130.wog_oid = T30101.ass_workgroup)) LEFT OUTER JOIN itsm_persons T30129 ON (T30129.per_oid = T30101.ass_per_to_oid)) LEFT OUTER JOIN itsm_persons T30128 ON (T30128.per_oid = T30101.ass_contr_out_per)) LEFT OUTER JOIN itsm_organizations T30127 ON (T30127.org_oid = T30101.ass_contr_out_org)) LEFT OUTER JOIN itsm_wor_ass_information T30126 ON (T30126.wai_wor_oid = T30101.wor_oid)) LEFT OUTER JOIN itsm_workgroups T30125 ON (T30125.wog_oid = T30101.ass_wog_from_oid)) LEFT OUTER JOIN itsm_persons T30124 ON (T30124.per_oid = T30101.ass_per_from_oid)) LEFT OUTER JOIN itsm_codes T30122 ON (T30122.cod_oid = T30101.ass_assignstatus)) LEFT OUTER JOIN itsm_codes_locale T30123 ON (T30123.cdl_cod_oid = T30122.cod_oid)) LEFT OUTER JOIN itsm_codes T30120 ON (T30120.cod_oid = T30101.wor_assignpriority)) LEFT OUTER JOIN itsm_codes_locale T30121 ON (T30121.cdl_cod_oid = T30120.cod_oid)) LEFT OUTER JOIN itsm_codes T30118 ON (T30118.cod_oid = T30101.wor_apt_status)) LEFT OUTER JOIN itsm_codes_locale T30119 ON (T30119.cdl_cod_oid = T30118.cod_oid)) LEFT OUTER JOIN itsm_workgroups T30117 ON (T30117.wog_oid = T30101.wor_apt_wog_oid)) LEFT OUTER JOIN rep_templates T30116 ON (T30116.tem_oid = T30101.wor_tem_oid)) LEFT OUTER JOIN rep_codes T30114 ON (T30114.rcd_oid = T30101.wor_sta_oid)) LEFT OUTER JOIN rep_codes_text T30115 ON (T30115.rct_rcd_oid = T30114.rcd_oid)) LEFT OUTER JOIN itsm_persons T30113 ON (T30113.per_oid = T30101.wor_requestor_per_oid)) LEFT OUTER JOIN itsm_codes T30111 ON (T30111.cod_oid = T30101.wor_pri_oid)) LEFT OUTER JOIN itsm_codes_locale T30112 ON (T30112.cdl_cod_oid = T30111.cod_oid)) LEFT OUTER JOIN itsm_wor_information T30110 ON (T30110.woi_wor_oid = T30101.wor_oid)) LEFT OUTER JOIN itsm_codes T30108 ON (T30108.cod_oid = T30101.wor_imp_oid)) LEFT OUTER JOIN itsm_codes_locale T30109 ON (T30109.cdl_cod_oid = T30108.cod_oid)) LEFT OUTER JOIN rep_codes T30106 ON (T30106.rcd_oid = T30101.wor_poo_oid)) LEFT OUTER JOIN rep_codes_text T30107 ON (T30107.rct_rcd_oid = T30106.rcd_oid)) LEFT OUTER JOIN itsm_persons T30105 ON (T30105.per_oid = T30101.slc_wor_per_oid)) LEFT OUTER JOIN itsm_persons T30104 ON (T30104.per_oid = T30101.wor_initiator_per_oid)) LEFT OUTER JOIN rep_codes T30102 ON (T30102.rcd_oid = T30101.wor_cat_oid)) LEFT OUTER JOIN rep_codes_text T30103 ON (T30103.rct_rcd_oid = T30102.rcd_oid)) INNER JOIN rep_accounts T30131 ON (T30131.acc_oid = T30101.reg_created_by_oid))WHERE ((T30103.rct_lng_oid IS NULL OR T30103.rct_lng_oid = 1033)AND (T30107.rct_lng_oid IS NULL OR T30107.rct_lng_oid = 1033)AND (T30109.cdl_lng_oid IS NULL OR T30109.cdl_lng_oid = 1033)AND (T30112.cdl_lng_oid IS NULL OR T30112.cdl_lng_oid = 1033)AND (T30115.rct_lng_oid IS NULL OR T30115.rct_lng_oid = 1033)AND (T30119.cdl_lng_oid IS NULL OR T30119.cdl_lng_oid = 1033)AND (T30121.cdl_lng_oid IS NULL OR T30121.cdl_lng_oid = 1033)AND (T30123.cdl_lng_oid IS NULL OR T30123.cdl_lng_oid = 1033))UNION ALLSELECT T50101.pro_oid AS object_id,T50101.pro_description AS description,T50101.pro_id AS id, CAST(717488173 AS NUMERIC) AS item_type,T50101.pro_actualcost AS actual_cost,T50101.pro_actualduration AS actual_duration,T50101.pro_actualstart + CAST(1.0 AS DECIMAL)/24 AS actual_start,T50103.rct_name AS category_service_today_,T50101.pro_cat_oid AS category_service_today_object_,T50104.per_name AS change_owner_name,T50101.pro_initiator_per_oid AS change_owner_object_id,T50101.pro_actualfinish + CAST(1.0 AS DECIMAL)/24 AS closed_date,T50101.pro_deadline + CAST(1.0 AS DECIMAL)/24 AS deadline,T50101.pro_earlyfinish + CAST(1.0 AS DECIMAL)/24 AS early_finish,T50101.pro_earlystart + CAST(1.0 AS DECIMAL)/24 AS early_start,T50105.per_name AS entered_by_person_name,T50101.slc_pro_per_oid AS entered_by_person_object_id,T50107.rct_name AS folder,T50101.pro_poo_oid AS folder_object_id,T50109.cdl_name AS impact,T50101.pro_imp_oid AS impact_object_id,T50110.pri_information AS information,T50101.pro_latefinish + CAST(1.0 AS DECIMAL)/24 AS late_finish,T50101.pro_latestart + CAST(1.0 AS DECIMAL)/24 AS late_start,T50101.pro_maximumduration AS max_duration,T50101.pro_plannedcost AS planned_cost,T50101.pro_planduration AS planned_duration,T50101.pro_planfinish + CAST(1.0 AS DECIMAL)/24 AS planned_finish,T50101.pro_planstart + CAST(1.0 AS DECIMAL)/24 AS planned_start,T50112.cdl_name AS priority,T50101.pro_pri_oid AS priority_object_id,T50113.per_name AS requestor_name,T50101.pro_requestor_per_oid AS requestor_object_id,T50101.pro_sourceid AS source_id,T50115.rct_name AS status_service_today_,T50101.pro_sta_oid AS status_service_today_object_id,T50116.tem_name AS template_name,T50101.pro_tem_oid AS template_object_id,T50101.pro_apt_nrofapproversrequired AS approvers_required,T50117.wog_name AS approval_group_name,T50101.pro_apt_wog_oid AS approval_group_object_id,T50119.cdl_name AS approval_status,T50101.pro_apt_status AS approval_status_object_id,T50101.pro_apt_deadline + CAST(1.0 AS DECIMAL)/24 AS approval_approvaldeadline,T50101.pro_apt_description AS approval_description,T50121.cdl_name AS assignment_priority,T50101.pro_assign_priority AS assignment_priority_object_id,T50123.cdl_name AS assignment_status,T50101.pro_assign_status AS assignment_status_object_id,T50101.pro_assign_extdeadline + CAST(1.0 AS DECIMAL)/24 AS external_deadline,T50124.per_name AS from_person_name,T50101.ass_per_from_oid AS from_person_object_id,T50125.wog_name AS from_workgroup_name,T50101.ass_wog_from_oid AS from_workgroup_object_id,T50126.pas_ass_information AS information_from_sender,T50101.pro_assign_referencenumber AS reference_,T50127.org_name1 AS to_external_organization_name,T50101.ass_contr_out_org AS to_external_organization_objec,T50128.per_name AS to_external_person_name,T50101.ass_contr_out_per AS to_external_person_object_id,T50129.per_name AS to_person_name,T50101.ass_per_to_oid AS to_person_object_id,T50130.wog_name AS to_workgroup_name,T50101.ass_wog_oid AS to_workgroup_object_id,T50101.pro_attachment_exists AS attachment_exists,T50101.reg_created + CAST(1.0 AS DECIMAL)/24 AS created,T50131.acc_showname AS created_by_display_name,T50101.reg_created_by_oid AS created_by_object_id,T50101.reg_modified + CAST(1.0 AS DECIMAL)/24 AS modified,T50132.acc_showname AS modified_by_display_name,T50101.reg_modified_by_oid AS modified_by_object_idFROM ((((((((((((((((((((((((((((((( itsm_problems T50101 LEFT OUTER JOIN rep_accounts T50132 ON (T50132.acc_oid = T50101.reg_modified_by_oid)) LEFT OUTER JOIN itsm_workgroups T50130 ON (T50130.wog_oid = T50101.ass_wog_oid)) LEFT OUTER JOIN itsm_persons T50129 ON (T50129.per_oid = T50101.ass_per_to_oid)) LEFT OUTER JOIN itsm_persons T50128 ON (T50128.per_oid = T50101.ass_contr_out_per)) LEFT OUTER JOIN itsm_organizations T50127 ON (T50127.org_oid = T50101.ass_contr_out_org)) LEFT OUTER JOIN itsm_pro_ass_information T50126 ON (T50126.pas_pro_oid = T50101.pro_oid)) LEFT OUTER JOIN itsm_workgroups T50125 ON (T50125.wog_oid = T50101.ass_wog_from_oid)) LEFT OUTER JOIN itsm_persons T50124 ON (T50124.per_oid = T50101.ass_per_from_oid)) LEFT OUTER JOIN itsm_codes T50122 ON (T50122.cod_oid = T50101.pro_assign_status)) LEFT OUTER JOIN itsm_codes_locale T50123 ON (T50123.cdl_cod_oid = T50122.cod_oid)) LEFT OUTER JOIN itsm_codes T50120 ON (T50120.cod_oid = T50101.pro_assign_priority)) LEFT OUTER JOIN itsm_codes_locale T50121 ON (T50121.cdl_cod_oid = T50120.cod_oid)) LEFT OUTER JOIN itsm_codes T50118 ON (T50118.cod_oid = T50101.pro_apt_status)) LEFT OUTER JOIN itsm_codes_locale T50119 ON (T50119.cdl_cod_oid = T50118.cod_oid)) LEFT OUTER JOIN itsm_workgroups T50117 ON (T50117.wog_oid = T50101.pro_apt_wog_oid)) LEFT OUTER JOIN rep_templates T50116 ON (T50116.tem_oid = T50101.pro_tem_oid)) LEFT OUTER JOIN rep_codes T50114 ON (T50114.rcd_oid = T50101.pro_sta_oid)) LEFT OUTER JOIN rep_codes_text T50115 ON (T50115.rct_rcd_oid = T50114.rcd_oid)) LEFT OUTER JOIN itsm_persons T50113 ON (T50113.per_oid = T50101.pro_requestor_per_oid)) LEFT OUTER JOIN itsm_codes T50111 ON (T50111.cod_oid = T50101.pro_pri_oid)) LEFT OUTER JOIN itsm_codes_locale T50112 ON (T50112.cdl_cod_oid = T50111.cod_oid)) LEFT OUTER JOIN itsm_pro_information T50110 ON (T50110.pri_pro_oid = T50101.pro_oid)) LEFT OUTER JOIN itsm_codes T50108 ON (T50108.cod_oid = T50101.pro_imp_oid)) LEFT OUTER JOIN itsm_codes_locale T50109 ON (T50109.cdl_cod_oid = T50108.cod_oid)) LEFT OUTER JOIN rep_codes T50106 ON (T50106.rcd_oid = T50101.pro_poo_oid)) LEFT OUTER JOIN rep_codes_text T50107 ON (T50107.rct_rcd_oid = T50106.rcd_oid)) LEFT OUTER JOIN itsm_persons T50105 ON (T50105.per_oid = T50101.slc_pro_per_oid)) LEFT OUTER JOIN itsm_persons T50104 ON (T50104.per_oid = T50101.pro_initiator_per_oid)) LEFT OUTER JOIN rep_codes T50102 ON (T50102.rcd_oid = T50101.pro_cat_oid)) LEFT OUTER JOIN rep_codes_text T50103 ON (T50103.rct_rcd_oid = T50102.rcd_oid)) INNER JOIN rep_accounts T50131 ON (T50131.acc_oid = T50101.reg_created_by_oid))WHERE ((T50103.rct_lng_oid IS NULL OR T50103.rct_lng_oid = 1033)AND (T50107.rct_lng_oid IS NULL OR T50107.rct_lng_oid = 1033)AND (T50109.cdl_lng_oid IS NULL OR T50109.cdl_lng_oid = 1033)AND (T50112.cdl_lng_oid IS NULL OR T50112.cdl_lng_oid = 1033)AND (T50115.rct_lng_oid IS NULL OR T50115.rct_lng_oid = 1033)AND (T50119.cdl_lng_oid IS NULL OR T50119.cdl_lng_oid = 1033)AND (T50121.cdl_lng_oid IS NULL OR T50121.cdl_lng_oid = 1033)AND (T50123.cdl_lng_oid IS NULL OR T50123.cdl_lng_oid = 1033))UNION ALLSELECT T70101.ser_oid AS object_id,T70101.ser_description AS description,T70101.ser_id AS id, CAST(563019801 AS NUMERIC) AS item_type,T70101.ser_actualcost AS actual_cost,T70101.ser_actualduration AS actual_duration,T70101.ser_actualstart + CAST(1.0 AS DECIMAL)/24 AS actual_start,T70103.rct_name AS category_service_today_,T70101.ser_cat_oid AS category_service_today_object_,T70104.per_name AS change_owner_name,T70101.ser_initiator_per_oid AS change_owner_object_id,T70101.ser_actualfinish + CAST(1.0 AS DECIMAL)/24 AS closed_date,T70101.ser_deadline + CAST(1.0 AS DECIMAL)/24 AS deadline,T70101.ser_earlyfinish + CAST(1.0 AS DECIMAL)/24 AS early_finish,T70101.ser_earlystart + CAST(1.0 AS DECIMAL)/24 AS early_start,T70105.per_name AS entered_by_person_name,T70101.slc_ser_per_oid AS entered_by_person_object_id,T70107.rct_name AS folder,T70101.ser_poo_oid AS folder_object_id,T70109.cdl_name AS impact,T70101.ser_imp_oid AS impact_object_id,T70110.sei_information AS information,T70101.ser_latefinish + CAST(1.0 AS DECIMAL)/24 AS late_finish,T70101.ser_latestart + CAST(1.0 AS DECIMAL)/24 AS late_start,T70101.ser_maximumduration AS max_duration,T70101.ser_plannedcost AS planned_cost,T70101.ser_planduration AS planned_duration,T70101.ser_planfinish + CAST(1.0 AS DECIMAL)/24 AS planned_finish,T70101.ser_planstart + CAST(1.0 AS DECIMAL)/24 AS planned_start,T70112.cdl_name AS priority,T70101.ser_pri_oid AS priority_object_id,T70113.per_name AS requestor_name,T70101.ser_requestor_per_oid AS requestor_object_id,T70101.ser_sourceid AS source_id,T70115.rct_name AS status_service_today_,T70101.ser_sta_oid AS status_service_today_object_id,T70116.tem_name AS template_name,T70101.ser_tem_oid AS template_object_id,T70101.ser_apt_nrofapproversrequired AS approvers_required,T70117.wog_name AS approval_group_name,T70101.ser_apt_wog_oid AS approval_group_object_id,T70119.cdl_name AS approval_status,T70101.ser_apt_status AS approval_status_object_id,T70101.ser_apt_deadline + CAST(1.0 AS DECIMAL)/24 AS approval_approvaldeadline,T70101.ser_apt_description AS approval_description,T70121.cdl_name AS assignment_priority,T70101.ser_assignpriority AS assignment_priority_object_id,T70123.cdl_name AS assignment_status,T70101.ser_assignstatus AS assignment_status_object_id,T70101.ser_assign_extdeadline + CAST(1.0 AS DECIMAL)/24 AS external_deadline,T70124.per_name AS from_person_name,T70101.ser_ass_per_from_oid AS from_person_object_id,T70125.wog_name AS from_workgroup_name,T70101.ser_ass_wog_from_oid AS from_workgroup_object_id,T70126.sai_ass_information AS information_from_sender,T70101.ser_assign_referencenumber AS reference_,T70127.org_name1 AS to_external_organization_name,T70101.ser_ass_contr_out_org AS to_external_organization_objec,T70128.per_name AS to_external_person_name,T70101.ser_ass_contr_out_per AS to_external_person_object_id,T70129.per_name AS to_person_name,T70101.ser_ass_per_to_oid AS to_person_object_id,T70130.wog_name AS to_workgroup_name,T70101.ser_ass_wog_oid AS to_workgroup_object_id,T70101.ser_attachment_exists AS attachment_exists,T70101.reg_created + CAST(1.0 AS DECIMAL)/24 AS created,T70131.acc_showname AS created_by_display_name,T70101.reg_created_by_oid AS created_by_object_id,T70101.reg_modified + CAST(1.0 AS DECIMAL)/24 AS modified,T70132.acc_showname AS modified_by_display_name,T70101.reg_modified_by_oid AS modified_by_object_idFROM ((((((((((((((((((((((((((((((( itsm_servicecalls T70101 LEFT OUTER JOIN rep_accounts T70132 ON (T70132.acc_oid = T70101.reg_modified_by_oid)) LEFT OUTER JOIN itsm_workgroups T70130 ON (T70130.wog_oid = T70101.ser_ass_wog_oid)) LEFT OUTER JOIN itsm_persons T70129 ON (T70129.per_oid = T70101.ser_ass_per_to_oid)) LEFT OUTER JOIN itsm_persons T70128 ON (T70128.per_oid = T70101.ser_ass_contr_out_per)) LEFT OUTER JOIN itsm_organizations T70127 ON (T70127.org_oid = T70101.ser_ass_contr_out_org)) LEFT OUTER JOIN itsm_ser_ass_information T70126 ON (T70126.sai_ser_oid = T70101.ser_oid)) LEFT OUTER JOIN itsm_workgroups T70125 ON (T70125.wog_oid = T70101.ser_ass_wog_from_oid)) LEFT OUTER JOIN itsm_persons T70124 ON (T70124.per_oid = T70101.ser_ass_per_from_oid)) LEFT OUTER JOIN itsm_codes T70122 ON (T70122.cod_oid = T70101.ser_assignstatus)) LEFT OUTER JOIN itsm_codes_locale T70123 ON (T70123.cdl_cod_oid = T70122.cod_oid)) LEFT OUTER JOIN itsm_codes T70120 ON (T70120.cod_oid = T70101.ser_assignpriority)) LEFT OUTER JOIN itsm_codes_locale T70121 ON (T70121.cdl_cod_oid = T70120.cod_oid)) LEFT OUTER JOIN itsm_codes T70118 ON (T70118.cod_oid = T70101.ser_apt_status)) LEFT OUTER JOIN itsm_codes_locale T70119 ON (T70119.cdl_cod_oid = T70118.cod_oid)) LEFT OUTER JOIN itsm_workgroups T70117 ON (T70117.wog_oid = T70101.ser_apt_wog_oid)) LEFT OUTER JOIN rep_templates T70116 ON (T70116.tem_oid = T70101.ser_tem_oid)) LEFT OUTER JOIN rep_codes T70114 ON (T70114.rcd_oid = T70101.ser_sta_oid)) LEFT OUTER JOIN rep_codes_text T70115 ON (T70115.rct_rcd_oid = T70114.rcd_oid)) LEFT OUTER JOIN itsm_persons T70113 ON (T70113.per_oid = T70101.ser_requestor_per_oid)) LEFT OUTER JOIN itsm_codes T70111 ON (T70111.cod_oid = T70101.ser_pri_oid)) LEFT OUTER JOIN itsm_codes_locale T70112 ON (T70112.cdl_cod_oid = T70111.cod_oid)) LEFT OUTER JOIN itsm_ser_information T70110 ON (T70110.sei_ser_oid = T70101.ser_oid)) LEFT OUTER JOIN itsm_codes T70108 ON (T70108.cod_oid = T70101.ser_imp_oid)) LEFT OUTER JOIN itsm_codes_locale T70109 ON (T70109.cdl_cod_oid = T70108.cod_oid)) LEFT OUTER JOIN rep_codes T70106 ON (T70106.rcd_oid = T70101.ser_poo_oid)) LEFT OUTER JOIN rep_codes_text T70107 ON (T70107.rct_rcd_oid = T70106.rcd_oid)) LEFT OUTER JOIN itsm_persons T70105 ON (T70105.per_oid = T70101.slc_ser_per_oid)) LEFT OUTER JOIN itsm_persons T70104 ON (T70104.per_oid = T70101.ser_initiator_per_oid)) LEFT OUTER JOIN rep_codes T70102 ON (T70102.rcd_oid = T70101.ser_cat_oid)) LEFT OUTER JOIN rep_codes_text T70103 ON (T70103.rct_rcd_oid = T70102.rcd_oid)) INNER JOIN rep_accounts T70131 ON (T70131.acc_oid = T70101.reg_created_by_oid))WHERE ((T70103.rct_lng_oid IS NULL OR T70103.rct_lng_oid = 1033)AND (T70107.rct_lng_oid IS NULL OR T70107.rct_lng_oid = 1033)AND (T70109.cdl_lng_oid IS NULL OR T70109.cdl_lng_oid = 1033)AND (T70112.cdl_lng_oid IS NULL OR T70112.cdl_lng_oid = 1033)AND (T70115.rct_lng_oid IS NULL OR T70115.rct_lng_oid = 1033)AND (T70119.cdl_lng_oid IS NULL OR T70119.cdl_lng_oid = 1033)AND (T70121.cdl_lng_oid IS NULL OR T70121.cdl_lng_oid = 1033)AND (T70123.cdl_lng_oid IS NULL OR T70123.cdl_lng_oid = 1033))UNION ALLSELECT T80101.inc_oid AS object_id,T80101.inc_description AS description,T80101.inc_id AS id, CAST(743309320 AS NUMERIC) AS item_type,T80101.inc_actualcost AS actual_cost,T80101.inc_actualduration AS actual_duration,T80101.inc_actualstart + CAST(1.0 AS DECIMAL)/24 AS actual_start,T80103.rct_name AS category_service_today_,T80101.inc_cat_oid AS category_service_today_object_,T80104.per_name AS change_owner_name,T80101.inc_initiator_per_oid AS change_owner_object_id,T80101.inc_actualfinish + CAST(1.0 AS DECIMAL)/24 AS closed_date,T80101.inc_deadline + CAST(1.0 AS DECIMAL)/24 AS deadline,T80101.inc_earlyfinish + CAST(1.0 AS DECIMAL)/24 AS early_finish,T80101.inc_earlystart + CAST(1.0 AS DECIMAL)/24 AS early_start,T80105.per_name AS entered_by_person_name,T80101.slc_inc_per_oid AS entered_by_person_object_id,T80107.rct_name AS folder,T80101.inc_poo_oid AS folder_object_id,T80109.cdl_name AS impact,T80101.inc_imp_oid AS impact_object_id,T80110.ini_information AS information,T80101.inc_latefinish + CAST(1.0 AS DECIMAL)/24 AS late_finish,T80101.inc_latestart + CAST(1.0 AS DECIMAL)/24 AS late_start,T80101.inc_maximumduration AS max_duration,T80101.inc_plannedcost AS planned_cost,T80101.inc_planduration AS planned_duration,T80101.inc_planfinish + CAST(1.0 AS DECIMAL)/24 AS planned_finish,T80101.inc_planstart + CAST(1.0 AS DECIMAL)/24 AS planned_start,T80112.cdl_name AS priority,T80101.inc_pri_oid AS priority_object_id,T80113.per_name AS requestor_name,T80101.inc_requestor_per_oid AS requestor_object_id,T80101.inc_sourceid AS source_id,T80115.rct_name AS status_service_today_,T80101.inc_sta_oid AS status_service_today_object_id,T80116.tem_name AS template_name,T80101.inc_tem_oid AS template_object_id,T80101.inc_apt_nrofapproversrequired AS approvers_required,T80117.wog_name AS approval_group_name,T80101.inc_apt_wog_oid AS approval_group_object_id,T80119.cdl_name AS approval_status,T80101.inc_apt_status AS approval_status_object_id,T80101.inc_apt_deadline + CAST(1.0 AS DECIMAL)/24 AS approval_approvaldeadline,T80101.inc_apt_description AS approval_description,T80121.cdl_name AS assignment_priority,T80101.inc_assign_priority AS assignment_priority_object_id,T80123.cdl_name AS assignment_status,T80101.inc_assign_status AS assignment_status_object_id,T80101.inc_assign_extdeadline + CAST(1.0 AS DECIMAL)/24 AS external_deadline,T80124.per_name AS from_person_name,T80101.inc_assign_person_from AS from_person_object_id,T80125.wog_name AS from_workgroup_name,T80101.inc_assign_workgroup_from AS from_workgroup_object_id,T80126.iai_ass_information AS information_from_sender,T80101.inc_assign_referencenumber AS reference_,T80127.org_name1 AS to_external_organization_name,T80101.ass_contr_out_org AS to_external_organization_objec,T80128.per_name AS to_external_person_name,T80101.ass_contr_out_per AS to_external_person_object_id,T80129.per_name AS to_person_name,T80101.inc_assign_person_to AS to_person_object_id,T80130.wog_name AS to_workgroup_name,T80101.inc_assign_workgroup AS to_workgroup_object_id,T80101.inc_attachment_exists AS attachment_exists,T80101.reg_created + CAST(1.0 AS DECIMAL)/24 AS created,T80131.acc_showname AS created_by_display_name,T80101.reg_createdby AS created_by_object_id,T80101.reg_modified + CAST(1.0 AS DECIMAL)/24 AS modified,T80132.acc_showname AS modified_by_display_name,T80101.reg_modifiedby AS modified_by_object_idFROM ((((((((((((((((((((((((((((((( itsm_incidents T80101 LEFT OUTER JOIN rep_accounts T80132 ON (T80132.acc_oid = T80101.reg_modifiedby)) LEFT OUTER JOIN itsm_workgroups T80130 ON (T80130.wog_oid = T80101.inc_assign_workgroup)) LEFT OUTER JOIN itsm_persons T80129 ON (T80129.per_oid = T80101.inc_assign_person_to)) LEFT OUTER JOIN itsm_persons T80128 ON (T80128.per_oid = T80101.ass_contr_out_per)) LEFT OUTER JOIN itsm_organizations T80127 ON (T80127.org_oid = T80101.ass_contr_out_org)) LEFT OUTER JOIN itsm_inc_ass_information T80126 ON (T80126.iai_inc_oid = T80101.inc_oid)) LEFT OUTER JOIN itsm_workgroups T80125 ON (T80125.wog_oid = T80101.inc_assign_workgroup_from)) LEFT OUTER JOIN itsm_persons T80124 ON (T80124.per_oid = T80101.inc_assign_person_from)) LEFT OUTER JOIN itsm_codes T80122 ON (T80122.cod_oid = T80101.inc_assign_status)) LEFT OUTER JOIN itsm_codes_locale T80123 ON (T80123.cdl_cod_oid = T80122.cod_oid)) LEFT OUTER JOIN itsm_codes T80120 ON (T80120.cod_oid = T80101.inc_assign_priority)) LEFT OUTER JOIN itsm_codes_locale T80121 ON (T80121.cdl_cod_oid = T80120.cod_oid)) LEFT OUTER JOIN itsm_codes T80118 ON (T80118.cod_oid = T80101.inc_apt_status)) LEFT OUTER JOIN itsm_codes_locale T80119 ON (T80119.cdl_cod_oid = T80118.cod_oid)) LEFT OUTER JOIN itsm_workgroups T80117 ON (T80117.wog_oid = T80101.inc_apt_wog_oid)) LEFT OUTER JOIN rep_templates T80116 ON (T80116.tem_oid = T80101.inc_tem_oid)) LEFT OUTER JOIN rep_codes T80114 ON (T80114.rcd_oid = T80101.inc_sta_oid)) LEFT OUTER JOIN rep_codes_text T80115 ON (T80115.rct_rcd_oid = T80114.rcd_oid)) LEFT OUTER JOIN itsm_persons T80113 ON (T80113.per_oid = T80101.inc_requestor_per_oid)) LEFT OUTER JOIN itsm_codes T80111 ON (T80111.cod_oid = T80101.inc_pri_oid)) LEFT OUTER JOIN itsm_codes_locale T80112 ON (T80112.cdl_cod_oid = T80111.cod_oid)) LEFT OUTER JOIN itsm_inc_information T80110 ON (T80110.ini_inc_oid = T80101.inc_oid)) LEFT OUTER JOIN itsm_codes T80108 ON (T80108.cod_oid = T80101.inc_imp_oid)) LEFT OUTER JOIN itsm_codes_locale T80109 ON (T80109.cdl_cod_oid = T80108.cod_oid)) LEFT OUTER JOIN rep_codes T80106 ON (T80106.rcd_oid = T80101.inc_poo_oid)) LEFT OUTER JOIN rep_codes_text T80107 ON (T80107.rct_rcd_oid = T80106.rcd_oid)) LEFT OUTER JOIN itsm_persons T80105 ON (T80105.per_oid = T80101.slc_inc_per_oid)) LEFT OUTER JOIN itsm_persons T80104 ON (T80104.per_oid = T80101.inc_initiator_per_oid)) LEFT OUTER JOIN rep_codes T80102 ON (T80102.rcd_oid = T80101.inc_cat_oid)) LEFT OUTER JOIN rep_codes_text T80103 ON (T80103.rct_rcd_oid = T80102.rcd_oid)) INNER JOIN rep_accounts T80131 ON (T80131.acc_oid = T80101.reg_createdby))WHERE ((T80103.rct_lng_oid IS NULL OR T80103.rct_lng_oid = 1033)AND (T80107.rct_lng_oid IS NULL OR T80107.rct_lng_oid = 1033)AND (T80109.cdl_lng_oid IS NULL OR T80109.cdl_lng_oid = 1033)AND (T80112.cdl_lng_oid IS NULL OR T80112.cdl_lng_oid = 1033)AND (T80115.rct_lng_oid IS NULL OR T80115.rct_lng_oid = 1033)AND (T80119.cdl_lng_oid IS NULL OR T80119.cdl_lng_oid = 1033)AND (T80121.cdl_lng_oid IS NULL OR T80121.cdl_lng_oid = 1033)AND (T80123.cdl_lng_oid IS NULL OR T80123.cdl_lng_oid = 1033))UNION ALLSELECT T90101.cha_oid AS object_id,T90101.cha_description AS description,T90101.cha_id AS id, CAST(724041768 AS NUMERIC) AS item_type,T90101.cha_actualcost AS actual_cost,T90101.cha_actualduration AS actual_duration,T90101.cha_actualstart + CAST(1.0 AS DECIMAL)/24 AS actual_start,T90103.rct_name AS category_service_today_,T90101.cha_cat_oid AS category_service_today_object_,T90104.per_name AS change_owner_name,T90101.cha_initiator_per_oid AS change_owner_object_id,T90101.cha_actualfinish + CAST(1.0 AS DECIMAL)/24 AS closed_date,T90101.cha_deadline + CAST(1.0 AS DECIMAL)/24 AS deadline,T90101.cha_earlyfinish + CAST(1.0 AS DECIMAL)/24 AS early_finish,T90101.cha_earlystart + CAST(1.0 AS DECIMAL)/24 AS early_start,T90105.per_name AS entered_by_person_name,T90101.cha_per_oid AS entered_by_person_object_id,T90107.rct_name AS folder,T90101.cha_poo_oid AS folder_object_id,T90109.cdl_name AS impact,T90101.cha_imp_oid AS impact_object_id,T90110.chi_information AS information,T90101.cha_latefinish + CAST(1.0 AS DECIMAL)/24 AS late_finish,T90101.cha_latestart + CAST(1.0 AS DECIMAL)/24 AS late_start,T90101.cha_maximumduration AS max_duration,T90101.cha_plannedcost AS planned_cost,T90101.cha_planduration AS planned_duration,T90101.cha_planfinish + CAST(1.0 AS DECIMAL)/24 AS planned_finish,T90101.cha_planstart + CAST(1.0 AS DECIMAL)/24 AS planned_start,T90112.cdl_name AS priority,T90101.cha_pri_oid AS priority_object_id,T90113.per_name AS requestor_name,T90101.cha_requestor_per_oid AS requestor_object_id,T90101.cha_sourceid AS source_id,T90115.rct_name AS status_service_today_,T90101.cha_sta_oid AS status_service_today_object_id,T90116.tem_name AS template_name,T90101.cha_tem_oid AS template_object_id,T90101.cha_apt_nrofapproversrequired AS approvers_required,T90117.wog_name AS approval_group_name,T90101.cha_apt_wog_oid AS approval_group_object_id,T90119.cdl_name AS approval_status,T90101.cha_apt_status AS approval_status_object_id,T90101.cha_apt_deadline + CAST(1.0 AS DECIMAL)/24 AS approval_approvaldeadline,T90101.cha_apt_description AS approval_description,T90121.cdl_name AS assignment_priority,T90101.cha_assign_priority AS assignment_priority_object_id,T90123.cdl_name AS assignment_status,T90101.cha_assign_status AS assignment_status_object_id,T90101.cha_assign_extdeadline + CAST(1.0 AS DECIMAL)/24 AS external_deadline,T90124.per_name AS from_person_name,T90101.ass_per_from_oid AS from_person_object_id,T90125.wog_name AS from_workgroup_name,T90101.ass_wog_from_oid AS from_workgroup_object_id,T90126.cas_ass_information AS information_from_sender,T90101.cha_assign_referencenumber AS reference_,T90127.org_name1 AS to_external_organization_name,T90101.ass_contr_out_org AS to_external_organization_objec,T90128.per_name AS to_external_person_name,T90101.ass_contr_out_per AS to_external_person_object_id,T90129.per_name AS to_person_name,T90101.ass_per_to_oid AS to_person_object_id,T90130.wog_name AS to_workgroup_name,T90101.ass_wog_oid AS to_workgroup_object_id,T90101.cha_attachment_exists AS attachment_exists,T90101.reg_created + CAST(1.0 AS DECIMAL)/24 AS created,T90131.acc_showname AS created_by_display_name,T90101.reg_created_by_oid AS created_by_object_id,T90101.reg_modified + CAST(1.0 AS DECIMAL)/24 AS modified,T90132.acc_showname AS modified_by_display_name,T90101.reg_modified_by_oid AS modified_by_object_idFROM ((((((((((((((((((((((((((((((( itsm_changes T90101 LEFT OUTER JOIN rep_accounts T90132 ON (T90132.acc_oid = T90101.reg_modified_by_oid)) LEFT OUTER JOIN itsm_workgroups T90130 ON (T90130.wog_oid = T90101.ass_wog_oid)) LEFT OUTER JOIN itsm_persons T90129 ON (T90129.per_oid = T90101.ass_per_to_oid)) LEFT OUTER JOIN itsm_persons T90128 ON (T90128.per_oid = T90101.ass_contr_out_per)) LEFT OUTER JOIN itsm_organizations T90127 ON (T90127.org_oid = T90101.ass_contr_out_org)) LEFT OUTER JOIN itsm_cha_ass_information T90126 ON (T90126.cas_cha_oid = T90101.cha_oid)) LEFT OUTER JOIN itsm_workgroups T90125 ON (T90125.wog_oid = T90101.ass_wog_from_oid)) LEFT OUTER JOIN itsm_persons T90124 ON (T90124.per_oid = T90101.ass_per_from_oid)) LEFT OUTER JOIN itsm_codes T90122 ON (T90122.cod_oid = T90101.cha_assign_status)) LEFT OUTER JOIN itsm_codes_locale T90123 ON (T90123.cdl_cod_oid = T90122.cod_oid)) LEFT OUTER JOIN itsm_codes T90120 ON (T90120.cod_oid = T90101.cha_assign_priority)) LEFT OUTER JOIN itsm_codes_locale T90121 ON (T90121.cdl_cod_oid = T90120.cod_oid)) LEFT OUTER JOIN itsm_codes T90118 ON (T90118.cod_oid = T90101.cha_apt_status)) LEFT OUTER JOIN itsm_codes_locale T90119 ON (T90119.cdl_cod_oid = T90118.cod_oid)) LEFT OUTER JOIN itsm_workgroups T90117 ON (T90117.wog_oid = T90101.cha_apt_wog_oid)) LEFT OUTER JOIN rep_templates T90116 ON (T90116.tem_oid = T90101.cha_tem_oid)) LEFT OUTER JOIN rep_codes T90114 ON (T90114.rcd_oid = T90101.cha_sta_oid)) LEFT OUTER JOIN rep_codes_text T90115 ON (T90115.rct_rcd_oid = T90114.rcd_oid)) LEFT OUTER JOIN itsm_persons T90113 ON (T90113.per_oid = T90101.cha_requestor_per_oid)) LEFT OUTER JOIN itsm_codes T90111 ON (T90111.cod_oid = T90101.cha_pri_oid)) LEFT OUTER JOIN itsm_codes_locale T90112 ON (T90112.cdl_cod_oid = T90111.cod_oid)) LEFT OUTER JOIN itsm_cha_information T90110 ON (T90110.chi_cha_oid = T90101.cha_oid)) LEFT OUTER JOIN itsm_codes T90108 ON (T90108.cod_oid = T90101.cha_imp_oid)) LEFT OUTER JOIN itsm_codes_locale T90109 ON (T90109.cdl_cod_oid = T90108.cod_oid)) LEFT OUTER JOIN rep_codes T90106 ON (T90106.rcd_oid = T90101.cha_poo_oid)) LEFT OUTER JOIN rep_codes_text T90107 ON (T90107.rct_rcd_oid = T90106.rcd_oid)) LEFT OUTER JOIN itsm_persons T90105 ON (T90105.per_oid = T90101.cha_per_oid)) LEFT OUTER JOIN itsm_persons T90104 ON (T90104.per_oid = T90101.cha_initiator_per_oid)) LEFT OUTER JOIN rep_codes T90102 ON (T90102.rcd_oid = T90101.cha_cat_oid)) LEFT OUTER JOIN rep_codes_text T90103 ON (T90103.rct_rcd_oid = T90102.rcd_oid)) INNER JOIN rep_accounts T90131 ON (T90131.acc_oid = T90101.reg_created_by_oid))WHERE ((T90103.rct_lng_oid IS NULL OR T90103.rct_lng_oid = 1033)AND (T90107.rct_lng_oid IS NULL OR T90107.rct_lng_oid = 1033)AND (T90109.cdl_lng_oid IS NULL OR T90109.cdl_lng_oid = 1033)AND (T90112.cdl_lng_oid IS NULL OR T90112.cdl_lng_oid = 1033)AND (T90115.rct_lng_oid IS NULL OR T90115.rct_lng_oid = 1033)AND (T90119.cdl_lng_oid IS NULL OR T90119.cdl_lng_oid = 1033)AND (T90121.cdl_lng_oid IS NULL OR T90121.cdl_lng_oid = 1033)AND (T90123.cdl_lng_oid IS NULL OR T90123.cdl_lng_oid = 1033)) |
 |
|
What's AWE?
_______________________________________________Causing trouble since 1980Blog: