SELECT t15.conflict_id,
       t15.last_upd,
       t15.created,
       t15.last_upd_by,
       t15.created_by,
       t15.modification_num,
       t15.row_id,
       t15.paper_sign_flg,
       t15.par_evt_id,
       t15.todo_plan_start_dt,
       t15.todo_plan_end_dt,
       t15.x_postn_company,
       t15.owner_postn_id,
       t15.owner_login,
       t15.owner_per_id,
       t15.pr_prdin t_id,
       t15.recreate_rcpt_flg,
       t15.appt_rept_flg,
       t15.appt_rept_end_dt,
       t15.sign_capture_flg,
       t13.created,
       t15.appt_start_dt,
       t12.state,
       t15.call_submit_dt,
       t15.cal_disp_flg,
       t15.template_flg,
       t15.zipcode,
       t15.target_ou_id,
       t14.NAME,
       t15.comments,
       t15.alarm_flag,
       t15.area_id,
       t12.city,
       t15.target_per_addr_id,
       t6.fst_name,
       t15.target_per_id,
       t4.attrib_12,
       t4.attrib_03,
       t15.NAME,
       t15.cal_type_cd,
       t15.appt_duration_min,
       t15.x_bu_id,
       t1.x_freetext_flg,
       t7.annlrvw_stdt_offst,
       t15.x_sched_sys_status,
       t15.x_submit_override,
       t6.last_name,
       t4.attrib_13,
       t4.attrib_04,
       t4.attrib_05,
       t6.ok_to_sample_flg,
       t15.opty_id,
       t5.row_id,
       t15.row_status,
       t6.con_cd,
       t6.per_title,
       t15.todo_cd,
       t15.evt_stat_cd,
       t15.subtype_cd,
       t12.country,
       t9.row_id,
       t2.row_status,
       t3.fst_name,
       t3.last_name,
       t10.NAME,
       t11.prdint_id,
       t4.row_id,
       t4.modification_num,
       t4.created_by,
       t4.last_upd_by,
       t4.created,
       t4.last_upd,
       t4.conflict_id,
       t4.par_row_id,
       t2.row_id,
       t9.row_id,
       t11.row_id
FROM   siebel.s_org_ext t1,
       siebel.s_act_emp t2,
       siebel.s_contact t3,
       siebel.s_evt_act_x t4,
       siebel.s_act_emp t5,
       siebel.s_contact t6,
       siebel.s_bu t7,
       siebel.s_postn t8,
       siebel.s_party t9,
       siebel.s_prod_int t10,
       siebel.s_act_prod_appl t11,
       siebel.s_addr_per t12,
       siebel.s_act_sign t13,
       siebel.s_org_ext t14,
       siebel.s_evt_act t15
WHERE  t15.row_id = t13.activity_id (+)
       AND t15.target_per_addr_id = t12.row_id (+)
       AND t15.target_per_id = t6.par_row_id
       AND t15.target_ou_id = t14.par_row_id (+)
       AND t15.owner_postn_id = t8.par_row_id (+)
       AND t15.x_bu_id = t7.row_id
       AND t8.ou_id = t1.row_id (+)
       AND t15.row_id = t5.activity_id (+)
       AND t5.emp_id (+)  = :1
       AND t15.row_id = t4.par_row_id (+)
       AND t15.owner_per_id = t2.emp_id (+)
       AND t15.row_id = t2.activity_id (+)
       AND t2.emp_id = t9.row_id (+)
       AND t2.emp_id = t3.par_row_id (+)
       AND t15.pr_prdint_id = t11.row_id (+)
       AND t11.prdint_id = t10.row_id (+)
       AND ((t15.subtype_cd IN (:2)
              OR t15.subtype_cd IN (:3))
            AND t15.subtype_cd > '0')
       AND (t15.row_id IN (SELECT sq1_t2.activity_id
                           FROM   siebel.s_prod_int sq1_t1,
                                  siebel.s_act_prod_appl sq1_t2
                           WHERE  (sq1_t2.prdint_id = sq1_t1.row_id)
                                  AND (sq1_t1.NAME = :4))
            AND t15.todo_plan_start_dt >= To_date(:5,'MM/DD/YYYY HH24:MI:SS')
            AND t15.todo_plan_start_dt <= To_date(:6,'MM/DD/YYYY HH24:MI:SS')
            AND t15.row_id = :7
            AND t15.evt_stat_cd IN (:8))