1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
| SELECT t31.conflict_id, t31.last_upd, t31.created, t31.last_upd_by,
t31.created_by, t31.modification_num, t31.row_id, t31.x_date_debut_reel,
t31.x_date_fin_reelle, t31.x_description, t31.acd_log_entry_dt,
t30.mrkt_cap_pref_cd, t31.x_mot_cle3, t31.x_nom_or, t31.x_num_ac,
t31.x_num_rae, t4.order_num, t27.x_sice_reference, t31.x_remarques,
t31.x_sens, t31.x_sens_ecust, t31.x_supprime_flg, t8.name,
t27.master_ou_id, t31.x_visible_internaute, t31.acd_call_duration,
t27.base_curcy_cd, t31.target_ou_id, t27.loc, t27.name,
t31.sra_defect_id, t31.sra_sr_id, t31.agreement_id, t31.alarm_flag,
t31.appt_alarm_tm_min, t31.asset_id, t31.billable_flg, t31.src_id,
t20.name, t31.creator_login, t31.cost_curcy_cd, t31.name,
t31.todo_actl_end_dt, t31.done_flg, t31.appt_start_dt,
t31.appt_duration_min, t31.pr_exp_rpt_id, t31.todo_after_dt, t29.name,
t29.curcy_cd, t31.opty_id, t31.appt_rept_appt_id, t31.appt_rept_repl_cd,
t31.par_evt_id, t31.pct_complete, t31.target_per_addr_id,
t31.todo_plan_start_dt, t31.todo_plan_end_dt, t31.prev_act_id,
t31.target_per_id, t31.owner_login, t31.owner_per_id, t31.pr_symptom_cd,
t11.bl_class_cd, t11.bl_curcy_cd, t31.proj_id, t13.actl_end_dt,
t13.actl_start_dt, t13.plan_end_dt, t13.plan_start_dt, t11.name,
t11.proj_num, t31.appt_rept_flg, t31.appt_rept_end_dt,
t31.appt_rept_type, t15.own_inst_id, t15.integration_id, t21.sr_num,
t31.target_ou_addr_id, t31.todo_actl_start_dt, t31.evt_stat_cd,
t31.cal_disp_flg, t31.template_flg, t31.todo_cd, t31.cal_type_cd,
t31.pr_order_id, t16.entlmnt_id, t18.format_type_cd, t19.ams_act_id,
t6.max_capability_lvl, t6.min_capability_lvl, t6.rte_appr_flg, t6.name,
t31.caller_type_cd, t25.case_id, t31.subtype_cd, t31.comments,
t16.corr_actn_id, t31.appt_end_dt, t31.pymnt_flg, t24.asset_num,
t31.owner_ou_id, t31.pr_ful_req_id, t31.pr_prdint_id, t16.prod_cmplnt_id,
t19.ams_route_to_cd, t19.sub_type_cd, t25.sgroup_id, t25.suspct_id,
t26.pim_appt_flg, t26.sebl_appt_flg, t26.unsprtd_rept_flg,
t3.srm_request_id, t3.stage_id, t3.active_flg, t31.pr_prod_cat_id,
t1.emp_id, t14.x_montant_impaye, t23.x_mnt_imp_tt_group,
t14.x_prio_relance, t27.x_niveau, t21.x_nom_demande, t31.x_nom_activite,
t31.x_num_affaire, t27.accnt_flg, t27.bill_pblshr_flg,
t14.x_tete_factu_id, t17.name, t27.prtnr_flg, t28.x_mnt_imp_tt_group,
t7.login, t10.row_id, t2.row_status, t22.ams_capability_lvl, t9.fst_name,
t9.home_ph_num, t5.row_id, t9.last_name, t9.mid_name, t9.work_ph_num,
t12.access_lvl_cd, t9.cell_ph_num, t9.fax_ph_num, t25.row_id,
t25.modification_num, t25.created_by, t25.last_upd_by, t25.created,
t25.last_upd, t25.conflict_id, t25.par_row_id, t19.row_id,
t19.modification_num, t19.created_by, t19.last_upd_by, t19.created,
t19.last_upd, t19.conflict_id, t19.par_row_id, t18.row_id,
t18.modification_num, t18.created_by, t18.last_upd_by, t18.created,
t18.last_upd, t18.conflict_id, t18.par_row_id, t16.row_id,
t16.modification_num, t16.created_by, t16.last_upd_by, t16.created,
t16.last_upd, t16.conflict_id, t16.par_row_id, t15.row_id,
t15.modification_num, t15.created_by, t15.last_upd_by, t15.created,
t15.last_upd, t15.conflict_id, t15.par_row_id, t26.row_id,
t26.modification_num, t26.created_by, t26.last_upd_by, t26.created,
t26.last_upd, t26.conflict_id, t26.par_row_id, t3.row_id,
t3.modification_num, t3.created_by, t3.last_upd_by, t3.created,
t3.last_upd, t3.conflict_id, t3.par_row_id, t2.row_id, t10.row_id,
t5.row_id
FROM siebel.s_act_emp t1, siebel.s_act_emp t2, siebel.s_evt_mktg t3,
siebel.s_order t4, siebel.s_party t5, siebel.s_fn_appr t6,
siebel.s_user t7, siebel.s_org_ext t8, siebel.s_contact t9,
siebel.s_party t10, siebel.s_proj t11, siebel.s_contact_fnx t12,
siebel.s_projitem t13, siebel.s_org_ext_x t14, siebel.s_evt_act_ss t15,
siebel.s_srv_act t16, siebel.s_org_ext t17, siebel.s_evt_mail t18,
siebel.s_evt_act_fnx t19, siebel.s_src t20, siebel.s_srv_req t21,
siebel.s_contact_fnx t22, siebel.s_org_ext_x t23, siebel.s_asset t24,
siebel.s_susp_act t25, siebel.s_evt_cal t26, siebel.s_org_ext t27,
siebel.s_org_ext_x t28, siebel.s_opty t29, siebel.s_org_ext_fnx t30,
siebel.s_evt_act t31
WHERE t27.master_ou_id = t8.par_row_id (+)
AND t31.pr_order_id = t4.row_id (+)
AND t19.ams_act_id = t6.row_id (+)
AND t31.asset_id = t24.row_id (+)
AND t31.opty_id = t29.row_id (+)
AND t31.target_ou_id = t27.par_row_id (+)
AND t31.target_ou_id = t30.row_id (+)
AND t31.proj_id = t11.row_id (+)
AND t31.proj_item_id = t13.row_id (+)
AND t31.src_id = t20.row_id (+)
AND t31.sra_sr_id = t21.row_id (+)
AND t31.row_id = t1.activity_id (+)
AND t31.target_ou_id = t14.par_row_id (+)
AND t14.x_tete_factu_id = t17.par_row_id (+)
AND t27.master_ou_id = t23.par_row_id (+)
AND t14.x_tete_factu_id = t28.par_row_id (+)
AND t31.row_id = t25.par_row_id (+)
AND t31.row_id = t19.par_row_id (+)
AND t31.row_id = t18.par_row_id (+)
AND t31.row_id = t16.par_row_id (+)
AND t31.row_id = t15.par_row_id (+)
AND t31.row_id = t26.par_row_id (+)
AND t31.row_id = t3.par_row_id (+)
AND t31.owner_per_id = t2.emp_id (+)
AND t31.row_id = t2.activity_id (+)
AND t2.emp_id = t10.row_id (+)
AND t2.emp_id = t7.par_row_id (+)
AND t2.emp_id = t22.par_row_id (+)
AND t31.target_per_id = t5.row_id (+)
AND t31.target_per_id = t9.par_row_id (+)
AND t31.target_per_id = t12.par_row_id (+)
AND t31.x_supprime_flg != 'Y'
AND t31.appt_rept_repl_cd IS NULL
AND (t31.template_flg != 'Y'
AND t31.template_flg != 'P'
OR t31.template_flg IS NULL)
AND (t31.opty_id IS NULL
OR t29.secure_flg = 'N'
OR t31.opty_id IN (SELECT sq1_t1.opty_id
FROM siebel.s_opty_postn sq1_t1, siebel.s_contact sq1_t2,
siebel.s_party sq1_t3, siebel.s_postn sq1_t4
WHERE sq1_t4.pr_emp_id = sq1_t2.par_row_id
AND sq1_t3.row_id = sq1_t4.par_row_id
AND sq1_t1.position_id = sq1_t3.row_id
AND sq1_t2.row_id = '1-6SHEHR'))
AND (t31.priv_flg = 'N'
OR t31.priv_flg IS NULL
OR t31.owner_per_id = '1-6SHEHR')
AND t31.x_num_affaire = '24528080'
; |
Index sur une colonne VARCHAR2
Répondre avec citation
Envoyé par Milo59000
)
Partager