rendered paste bodySELECT T49.LAST_UPD_BY, T49.ROW_ID, T49.CONFLICT_ID, T49.CREATED_BY, T49.CREATED, T49.LAST_UPD, T49.LAST_UPD, T49.MODIFICATION_NUM, T49.TARGET_OU_ADDR_ID, T1.REGION, T22.ZIPCODE, T47.CONFLICT_ID, T49.ACD_CALL_DURATION, T19.LAST_NAME, T44.EMAIL_FORWARD_FLG, T44.LAST_UPD, T11.ZIPCODE, T18.BL_CLASS_CD, T44.MSG_MANL_EDTD_FLG, T49.OWNER_PER_ID, T49.PREV_ACT_ID, T49.COMMENTS_LONG, T39.MODIFICATION_NUM, T49.OWNER_LOGIN, T30.MODIFICATION_NUM, T1.LOC, T49.APPT_START_DT, T47.CRMC_DTA_ACTV_FLG, T8.PLAN_START_DT, T49.TRAVEL_TM_MIN, T44.EMAIL_RECIP_ADDR, T48.ZIPCODE, T44.EMAIL_BCC_LINE, T49.PROJ_ITEM_ID, T49.ALLOW_BREAK_FLG, T17.ROW_ID, T49.TEMPLATE_FLG, T15.ROW_ID, T45.LAST_UPD, T17.MODIFICATION_NUM, T22.STATE, T21.MODIFICATION_NUM, T36.ROW_ID, T23.HOME_PH_NUM, T11.ADDR, T49.APPT_REPT_APPT_ID, T26.NAME, T45.LAST_UPD_BY, T47.ROW_ID, T22.ROW_ID, T49.LOC_DESC, T25.ACT_APPT_START_DT, T8.ACTL_END_DT, T1.ROW_ID, T35.FST_NAME, T14.NAME, T44.PAR_ROW_ID, T42.ROW_ID, T34.ROW_ID, T49.APPT_END_TM, T49.APPT_ALARM_TM_MIN, T6.MODIFICATION_NUM, T44.ROW_ID, T22.COUNTRY, T42.SR_STAT_ID, T25.ACT_TODO_PLNEND_DT, T49.PART_RPR_ID, T47.CREATED_BY, T25.ACT_CAL_TYPE_CD, T1.MAIN_PH_NUM, T18.NAME, T49.ASGN_MANL_FLG, T1.DIVISION, T8.PLAN_END_DT, T49.PR_EXPITEM_TYPE_ID, T49.BEST_ACTION_FLG, T37.CREATED_BY, T1.TAX_EXEMPT_NUM, T49.STATUS_RPT_FLG, T44.EMAIL_SNDR_NAME, T45.PAR_ROW_ID, T38.MODIFICATION_NUM, T49.EST_RMNG_WRK_TM, T49.ACCNT_ISSUE_ID, T41.LAST_UPD, T41.LAST_UPD_BY, T7.ROW_ID, T18.PROJ_NUM, T49.PUBLISH_CD, T1.MAIN_FAX_PH_NUM, T27.NAME, T49.ACCNT_OBJCTV_ID, T40.NAME, T49.MDF_ALLOC_ID, T33.MODIFICATION_NUM, T45.INTEGRATION_ID, T49.PCT_COMPLETE, T6.ROW_ID, T46.MODIFICATION_NUM, T41.PAR_ROW_ID, T28.FST_NAME, T49.COMM_SESSION_HNDL, T5.ROW_ID, T5.ROW_ID, T41.ATTRIB_03, T49.CAL_DISP_FLG, T49.PROJ_ID, T49.EXP_RLTD_FLG, T44.EMAIL_CC_LINE, T2.ROW_ID, T4.ROW_ID, T12.MODIFICATION_NUM, T29.MODIFICATION_NUM, T49.PR_TMSHT_LINE_ID, T17.TMSHT_ID, T49.SRA_DEFECT_ID, T44.CNTNT_CTG_DB_ID, T49.TARGET_OU_ID, T41.ROW_ID, T6.ROW_ID, T49.PRI_LST_ID, T44.CREATED, T23.MODIFICATION_NUM, T47.MODIFICATION_NUM, T48.ROW_ID, T31.ORDER_NUM, T49.SRA_SR_ID, T47.PAR_ROW_ID, T11.STATE, T20.NAME, T44.FORMAT_TYPE_CD, T41.CONFLICT_ID, T49.APPT_REPT_FLG, T49.TARGET_PER_ID, T12.ROW_ID, T23.FST_NAME, T49.TODO_CD, T41.ATTRIB_04, T28.LAST_NAME, T49.OBJCTV_ID, T44.CONFLICT_ID, T41.CREATED, T35.MODIFICATION_NUM, T49.DONE_FLG, T32.MODIFICATION_NUM, T36.NAME, T27.MODIFICATION_NUM, T49.ROW_STATUS, T49.EVT_PRIORITY_CD, T13.ROW_ID, T21.ROW_ID, T47.LAST_UPD_BY, T37.MODIFICATION_NUM, T7.ATTRIB_10, T49.USER_MSG_ID, T49.CREATOR_LOGIN, T26.MODIFICATION_NUM, T37.EXCH_DT, T49.SRA_RESOLUTION_CD, T49.OPTY_ID, T44.EMAIL_RECIP_NAME, T44.BODY_LANG_ID, T1.X_EM_POTENTIEL_QRC, T48.CITY, T30.ROW_ID, T49.ORDER_ITEM_ID, T33.NAME, T25.ROW_STATUS, T22.CITY, T46.SERIAL_NUM, T23.PER_TITLE, T11.MODIFICATION_NUM, T9.NAME, T44.EMAIL_ATT_FLG, T1.MODIFICATION_NUM, T40.MODIFICATION_NUM, T25.ACT_TEMPLATE_FLG, T49.APPT_REPT_END_DT, T14.MODIFICATION_NUM, T1.CUST_STAT_CD, T49.EVT_STAT_CD, T14.ROW_ID, T36.MODIFICATION_NUM, T30.ROW_ID, T35.LAST_NAME, T49.COMMENTS, T22.ADDR, T49.SRV_REGN_ID, T46.ASSET_NUM, T31.MODIFICATION_NUM, T43.ROW_ID, T49.RATE_LST_ID, T29.NAME, T15.ROW_ID, T8.ROW_ID, T34.MODIFICATION_NUM, T49.SCHED_LOCKED_FLG, T44.EMAIL_TO_LINE, T25.MODIFICATION_NUM, T44.MODIFICATION_NUM, T26.ROW_ID, T35.ROW_ID, T49.ACCNT_SRC_ID, T44.LAST_UPD_BY, T40.ROW_ID, T38.DEFECT_NUM, T24.ROW_ID, T47.CREATED, T33.ROW_ID, T46.ROW_ID, T49.ALARM_FLAG, T49.TODO_PLAN_END_DT, T37.CREATED, T28.ROW_ID, T28.ALIAS_NAME, T45.CONFLICT_ID, T37.LAST_UPD, T1.NAME, T16.ROW_ID, T42.MODIFICATION_NUM, T49.DURATION_HRS, T18.ROW_ID, T49.X_EM_PARTENAIRE_ID, T21.NAME, T23.ROW_ID, T45.CREATED_BY, T20.TIME_ZONE_ID, T2.CURCY_CD, T49.ACTIVITY_UID, T2.MODIFICATION_NUM, T49.SRC_ID, T19.ROW_ID, T25.ACT_CAL_DISP_FLG, T9.MODIFICATION_NUM, T47.WORK_ITEM_NUM, T48.STATE, T49.TODO_AFTER_DT, T16.MODIFICATION_NUM, T31.ROW_ID, T25.ACT_APPT_REPT_FLG, T13.NAME, T1.LOCATION_LEVEL, T1.ROW_ID, T3.MODIFICATION_NUM, T49.ASGN_SYS_FLG, T1.PR_ADDR_ID, T49.ASSET_ID, T25.EMP_ID, T3.EXP_RPT_NUM, T4.MODIFICATION_NUM, T49.CAL_TYPE_CD, T49.AGREEMENT_ID, T49.PAR_EVT_ID, T23.LAST_NAME, T44.MSG_NUM, T49.PR_EXP_RPT_ID, T34.NAME, T49.TODO_DUE_DT, T49.ASGN_DNRM_FLG, T49.COST_CURCY_CD, T1.LOC, T49.RPLY_PH_NUM, T13.MODIFICATION_NUM, T7.ATTRIB_42, T15.MODIFICATION_NUM, T23.MID_NAME, T10.NAME, T11.ROW_ID, T37.CURCY_CD, T49.TARGET_PER_ADDR_ID, T42.SR_TITLE, T20.MODIFICATION_NUM, T18.MODIFICATION_NUM, T11.PROVINCE, T49.TODO_ACTL_START_DT, T45.OWN_INST_ID, T24.MODIFICATION_NUM, T41.MODIFICATION_NUM, T41.ATTRIB_08, T9.ROW_ID, T29.ROW_ID, T25.ACT_ALARM_FLG, T25.ROW_ID, T43.MODIFICATION_NUM, T49.TODO_APPT_ID, T49.ASSOCIATED_COST, T8.MODIFICATION_NUM, T4.ROW_ID, T23.WORK_PH_NUM, T32.NAME, T37.CONFLICT_ID, T49.WC_START_VIEW, T25.ACT_APPT_RPTEND_DT, T49.WC_TYPE_CD, T42.SR_NUM, T49.MANDATORY_FLG, T23.JOB_TITLE, T8.NAME, T25.ACT_TODO_PLNSTRTDT, T25.ACT_EVT_STAT_CD, T48.ADDR, T37.ROW_ID, T25.EMP_ID, T5.MODIFICATION_NUM, T27.ROW_ID, T49.WORK_TM_MIN, T49.PR_ATT_ID, T49.BILLABLE_FLG, T37.LAST_UPD_BY, T44.EMAIL_SNDR_ADDR, T49.CALL_ID, T45.ROW_ID, T32.ROW_ID, T44.CREATED_BY, T47.LAST_UPD, T10.MODIFICATION_NUM, T12.PRDINT_ID, T28.MODIFICATION_NUM, T7.MODIFICATION_NUM, T11.ZIPCODE, T49.APPT_REPT_REPL_CD, T48.MODIFICATION_NUM, T10.ROW_ID, T49.PR_ORDER_ID, T39.NAME, T49.TODO_PLAN_START_DT, T49.NAME, T11.CITY, T2.NAME, T43.DMT_NUM, T48.COUNTRY, T49.APPT_DURATION_MIN, T22.MODIFICATION_NUM, T11.COUNTRY, T24.LOGIN, T3.ROW_ID, T37.ENTLMNT_ID, T49.COST_EXCH_DT, T16.SYMPTOM_CD, T21.PART_NUM, T26.NAME, T49.TMSHT_RLTD_FLG, T38.ROW_ID, T18.BL_CURCY_CD, T17.TMSHT_NUM, T49.APPT_REPT_TYPE, T8.ACTL_START_DT, T49.PR_SYMPTOM_CD, T37.PAR_ROW_ID, T19.MODIFICATION_NUM, T19.FST_NAME, T49.PROJ_ISS_ID, T49.TODO_ACTL_END_DT, T1.BASE_CURCY_CD, T39.ROW_ID, T49.DO_NOT_ROUTE_FLG, T49.SRA_TYPE_CD, T49.ASGN_USR_EXCLD_FLG, T45.CREATED, T45.MODIFICATION_NUM, T41.CREATED_BY, T20.ROW_ID, T49.PRIV_FLG, T44.EMAIL_BODY FROM SIEBEL.S_ORG_EXT T1, SIEBEL.S_OPTY T2, SIEBEL.S_EXP_RPT T3, SIEBEL.S_ACTIVITY_ATT T4, SIEBEL.S_PARTY T5, SIEBEL.S_PARTY T6, SIEBEL.S_ORG_EXT_X T7, SIEBEL.S_PROJITEM T8, SIEBEL.S_INT_INSTANCE T9, SIEBEL.S_PRI_LST T10, SIEBEL.S_ADDR_ORG T11, SIEBEL.S_ACT_PRDINT T12, SIEBEL.S_TIMEZONE_LANG T13, SIEBEL.S_ENTLMNT T14, SIEBEL.S_EVT_ACT T15, SIEBEL.S_SYMPTOM T16, SIEBEL.S_TMSHT_LINE T17, SIEBEL.S_PROJ T18, SIEBEL.S_CONTACT T19, SIEBEL.S_SRV_REGN T20, SIEBEL.S_PROD_INT T21, SIEBEL.S_ADDR_ORG T22, SIEBEL.S_CONTACT T23, SIEBEL.S_USER T24, SIEBEL.S_ACT_EMP T25, SIEBEL.S_SRC T26, SIEBEL.S_ORG_EXT T27, SIEBEL.S_CONTACT T28, SIEBEL.S_MDF_ALLOC T29, SIEBEL.S_PARTY T30, SIEBEL.S_ORDER T31, SIEBEL.S_EXP_ITEM_TYPE T32, SIEBEL.S_TIMEZONE T33, SIEBEL.S_LANG T34, SIEBEL.S_CONTACT T35, SIEBEL.S_EVT_ACT T36, SIEBEL.S_SRV_ACT T37, SIEBEL.S_PROD_DEFECT T38, SIEBEL.S_PRI_LST T39, SIEBEL.S_EVT_ACT T40, SIEBEL.S_EVT_ACT_X T41, SIEBEL.S_SRV_REQ T42, SIEBEL.S_PART_RPR T43, SIEBEL.S_EVT_MAIL T44, SIEBEL.S_EVT_ACT_SS T45, SIEBEL.S_ASSET T46, SIEBEL.S_EVT_COMM T47, SIEBEL.S_ADDR_PER T48, SIEBEL.S_EVT_ACT T49 WHERE T49.TODO_APPT_ID = T15.ROW_ID (+) AND T49.TARGET_OU_ID = T7.PAR_ROW_ID (+) AND T49.X_EM_PARTENAIRE_ID = T27.PAR_ROW_ID (+) AND T49.MDF_ALLOC_ID = T29.ROW_ID (+) AND T49.OWNER_PER_ID = T28.PAR_ROW_ID (+) AND T49.PAR_EVT_ID = T40.ROW_ID (+) AND T49.PREV_ACT_ID = T36.ROW_ID (+) AND T49.PRI_LST_ID = T10.ROW_ID (+) AND T49.RATE_LST_ID = T39.ROW_ID (+) AND T49.ROW_ID = T4.PAR_ROW_ID (+) AND T49.ROW_ID = T12.ACTIVITY_ID (+) AND T49.TARGET_OU_ADDR_ID = T22.ROW_ID (+) AND T49.TARGET_PER_ADDR_ID = T48.ROW_ID (+) AND T49.ASSET_ID = T46.ROW_ID (+) AND T49.TARGET_PER_ID = T35.PAR_ROW_ID (+) AND T37.ENTLMNT_ID = T14.ROW_ID (+) AND T49.PR_EXPITEM_TYPE_ID = T32.ROW_ID (+) AND T49.PR_EXP_RPT_ID = T3.ROW_ID (+) AND T45.OWN_INST_ID = T9.ROW_ID (+) AND T44.BODY_LANG_ID = T34.LANG_CD (+) AND T49.OPTY_ID = T2.ROW_ID (+) AND T49.TARGET_OU_ID = T1.PAR_ROW_ID (+) AND T49.PART_RPR_ID = T43.ROW_ID (+) AND T49.PART_RPR_ID = T43.ROW_ID (+) AND T49.SRA_DEFECT_ID = T38.ROW_ID (+) AND T12.PRDINT_ID = T21.ROW_ID (+) AND T49.PROJ_ID = T18.ROW_ID (+) AND T49.PROJ_ITEM_ID = T8.ROW_ID (+) AND T49.SRC_ID = T26.ROW_ID (+) AND T49.SRV_REGN_ID = T20.ROW_ID (+) AND T49.SRA_SR_ID = T42.ROW_ID (+) AND T20.TIME_ZONE_ID = T33.ROW_ID (+) AND T49.PR_TMSHT_LINE_ID = T17.ROW_ID (+) AND T33.ROW_ID = T13.PAR_ROW_ID (+) AND T13.LANG_ID (+) = 'FRA' AND T49.ROW_ID = T41.PAR_ROW_ID (+) AND T49.ROW_ID = T44.PAR_ROW_ID (+) AND T49.ROW_ID = T47.PAR_ROW_ID (+) AND T49.ROW_ID = T37.PAR_ROW_ID (+) AND T49.ROW_ID = T45.PAR_ROW_ID (+) AND T49.PR_ORDER_ID = T31.ROW_ID (+) AND T49.OWNER_PER_ID = T25.EMP_ID (+) AND T49.ROW_ID = T25.ACTIVITY_ID (+) AND T25.EMP_ID = T6.ROW_ID (+) AND T25.EMP_ID = T19.PAR_ROW_ID (+) AND T25.EMP_ID = T24.PAR_ROW_ID (+) AND T49.TARGET_PER_ID = T5.ROW_ID (+) AND T49.TARGET_PER_ID = T23.PAR_ROW_ID (+) AND T1.PR_ADDR_ID = T11.ROW_ID (+) AND T49.PR_SYMPTOM_CD = T16.ROW_ID (+) AND T49.TARGET_PER_ID = T30.ROW_ID (+) AND ((T49.TEMPLATE_FLG != 'Y' AND T49.TEMPLATE_FLG != 'P' OR T49.TEMPLATE_FLG IS NULL) AND (T49.PRIV_FLG = :1 OR T49.PRIV_FLG IS NULL OR T49.OWNER_PER_ID = :2) AND (T49.APPT_REPT_REPL_CD IS NULL)) AND (T49.TARGET_OU_ID = :3)