,
115 T3.ROW_ID,
116 T11.CITY,
117 T11.ADDR,
118 T11.STATE,
119 T11.ZIPCODE,
120 T11.COUNTY,
121 T11.X_COUNTY_CD,
122 T8.LOGIN,
123 T33.ROW_ID,
124 T33.PAR_ROW_ID,
125 T33.MODIFICATION_NUM,
126 T33.CREATED_BY,
127 T33.LAST_UPD_BY,
128 T33.CREATED,
129 T33.LAST_UPD,
130 T33.CONFLICT_ID,
131 T33.PAR_ROW_ID,
132 T18.ROW_ID,
133 T18.PAR_ROW_ID,
134 T18.MODIFICATION_NUM,
135 T18.CREATED_BY,
136 T18.LAST_UPD_BY,
137 T18.CREATED,
138 T18.LAST_UPD,
139 T18.CONFLICT_ID,
140 T18.PAR_ROW_ID,
141 T20.ROW_ID,
142 T20.PAR_ROW_ID,
143 T20.MODIFICATION_NUM,
144 T20.CREATED_BY,
145 T20.LAST_UPD_BY,
146 T20.CREATED,
147 T20.LAST_UPD,
148 T20.CONFLICT_ID,
149 T20.PAR_ROW_ID,
150 T9.ROW_ID,
151 T9.PAR_ROW_ID,
152 T9.MODIFICATION_NUM,
153 T9.CREATED_BY,
154 T9.LAST_UPD_BY,
155 T9.CREATED,
156 T9.LAST_UPD,
157 T9.CONFLICT_ID,
158 T9.PAR_ROW_ID,
159 T7.ROW_ID,
160 T7.PAR_ROW_ID,
161 T7.MODIFICATION_NUM,
162 T7.CREATED_BY,
163 T7.LAST_UPD_BY,
164 T7.CREATED,
165 T7.LAST_UPD,
166 T7.CONFLICT_ID,
167 T7.PAR_ROW_ID,
168 T27.ROW_ID,
169 T25.ROW_ID,
170 T3.ROW_ID,
171 T6.ROW_ID,
172 T11.ROW_ID,
173 T14.ROW_ID
174 FROM
175 SIEBEL.S_CONTACT_BU T1,
176 SIEBEL.S_ORG_EXT T2,
177 SIEBEL.S_PARTY T3,
178 SIEBEL.S_MED_SPEC T4,
179 SIEBEL.S_PARTY T5,
180 SIEBEL.S_CON_ADDR T6,
181 SIEBEL.S_CONTACT_SS T7,
182 SIEBEL.S_USER T8,
183 SIEBEL.S_CONTACT_LOYX T9,
184 SIEBEL.S_ORG_EXT T10,
185 SIEBEL.S_ADDR_PER T11,
186 SIEBEL.S_POSTN T12,
187 SIEBEL.S_PARTY T13,
188 SIEBEL.S_PARTY T14,
189 SIEBEL.S_PRI_LST T15,
190 SIEBEL.S_ORG_EXT_FNX T16,
191 SIEBEL.S_DQ_CON_KEY T17,
192 SIEBEL.S_CONTACT_X T18,
193 SIEBEL.S_POSTN T19,
194 SIEBEL.S_EMP_PER T20,
195 SIEBEL.S_USER T21,
196 SIEBEL.S_CASE T22,
197 SIEBEL.S_USER T23,
198 SIEBEL.S_USER T24,
199 SIEBEL.S_PARTY T25,
200 SIEBEL.S_USER T26,
201 SIEBEL.S_POSTN_CON T27,
202 SIEBEL.S_POSTN_CON T28,
203 SIEBEL.S_USER T29,
204 SIEBEL.S_POSTN T30,
205 SIEBEL.S_ADDR_PER T31,
206 SIEBEL.S_ORG_EXT T32,
207 SIEBEL.S_CONTACT T33
208 WHERE
209 T19.PR_EMP_ID = T26.PAR_ROW_ID (+) AND
210 T2.PR_POSTN_ID = T30.PAR_ROW_ID (+) AND
211 T33.PR_POSTN_ID = T19.PAR_ROW_ID (+) AND
212 T33.PR_DEPT_OU_ID = T2.PAR_ROW_ID (+) AND
213 T5.ROW_ID = T28.CON_ID (+) AND T28.POSTN_ID (+) = '1234' AND
214 T30.PR_EMP_ID = T21.PAR_ROW_ID (+) AND
215 T33.PR_PER_ADDR_ID = T31.ROW_ID (+) AND
216 T5.ROW_ID = T22.PR_SUBJECT_ID (+) AND
217 T33.BU_ID = T32.PAR_ROW_ID (+) AND
218 T33.MED_SPEC_ID = T4.ROW_ID (+) AND
219 T33.CURR_P |