Select
T3.position_id,
T1.pr_postn_id,
T5.sales_org_cd,
T1.last_upd,
T14.row_id,
T1.pr_rep_sys_flg,
T7.conflict_id,
T1.division,
T7.last_upd,
T15.name,
T3.row_id,
T7.attrib_06,
T1.disa_cleanse_flg,
T16.last_name,
T1.pr_ship_per_id,
T1.created_by,
T8.last_name,
T10.addr,
T10.zipcode,
T1.loc,
T1.pr_rep_dnrm_flg,
T3.accnt_loc,
T1.conflict_id,
T1.pr_addr_id,
T1.pr_terr_id,
T1.main_ph_num,
T1.pr_rep_manl_flg,
T1.par_ou_id,
T1.curr_pri_lst_id,
T1.pr_prtnr_ou_id,
T16.row_id,
T8.row_id,
T1.created,
T1.x_migrt_jde_flg,
T1.x_is_flg,
T1.pr_srv_agree_id,
T7.created,
T3.accnt_name,
T1.row_id,
T2.pr_emp_id,
T14.prtnr_ou_id,
T1.dedup_token,
T1.location_level,
T1.pr_ou_type_id,
T1.par_duns_num,
T1.x_bpcs_division,
T4.x_unit_type,
T7.attrib_04,
T1.x_pr_buy_grp_id,
T10.country,
T1.ou_num,
T9.row_id,
T8.fst_name,
T1.duns_num,
T1.bu_id,
T2.row_id,
T1.hist_sls_vol,
T1.base_curcy_cd,
T7.created_by,
T12.name,
T1.region,
T1.expertise_cd,
T13.country,
T1.ptntl_sls_exch_dt,
T13.city,
T6.loc,
T1.main_fax_ph_num,
T3.row_status,
T1.name,
T7.row_id,
T13.addr,
T1.modification_num,
T13.zipcode,
T2.row_id,
T1.pr_indust_id,
T1.ou_num_1,
T10.state,
T7.attrib_23,
T1.x_dflt_warehouse,
T7.par_row_id,
T10.county,
T1.url,
T17.city,
T11.prtnr_ou_id,
T7.attrib_34,
T5.name,
T17.addr,
T9.name,
T7.attrib_05,
T16.fst_name,
T13.row_id,
T2.name,
T3.asgn_sys_flg,
T6.name,
T1.pr_bl_addr_id,
T1.pr_rep_asgn_type,
T1.cust_stat_cd,
T7.attrib_10,
T10.row_id,
T1.x_dt_last_srvy,
T1.ptntl_sls_curcy_cd,
T1.last_upd_by,
T17.country,
T10.city,
T1.pr_bl_per_id,
T13.state,
T17.state,
T7.attrib_07,
T1.ou_type_cd,
T1.pr_syn_id,
T3.asgn_dnrm_flg,
T11.row_id,
T1.pr_ship_addr_id,
T7.attrib_18,
T7.modification_num,
T10.county,
T17.zipcode,
T9.x_unit_type,
T17.row_id,
T7.last_upd_by,
T1.asgn_ph_cc,
T18.login,
T1.ptntl_sls_vol,
T1.lang_id,
T1.hist_sls_exch_dt,
T3.asgn_manl_flg
From
Siebel.s_org_ext T1
Inner Join Siebel.s_postn T2 On T1.pr_postn_id = T2.row_id
Inner Join Siebel.s_accnt_postn T3 On T1.pr_postn_id = T3.position_id And T1.row_id = T3.ou_ext_id
Left Outer Join Siebel.s_indust T4 On T1.pr_indust_id = T4.row_id
Left Outer Join Siebel.s_org_int T5 On T1.bu_id = T5.row_id
Left Outer Join Siebel.s_org_ext T6 On T1.par_ou_id = T6.row_id
Left Outer Join Siebel.s_org_ext_x T7 On T1.row_id = T7.par_row_id
Left Outer Join Siebel.s_contact T8 On T1.pr_ship_per_id = T8.row_id
Left Outer Join Siebel.s_indust T9 On T1.pr_indust_id = T9.row_id
Left Outer Join Siebel.s_addr_org T10 On T1.pr_addr_id = T10.row_id
Left Outer Join Siebel.s_org_rel T11 On T1.pr_prtnr_ou_id = T11.row_id
Left Outer Join Siebel.s_org_ext T12 On T11.prtnr_ou_id = T12.row_id
Left Outer Join Siebel.s_addr_org T13 On T1.pr_ship_addr_id = T13.row_id
Left Outer Join Siebel.s_org_rel T14 On T1.x_pr_buy_grp_id = T14.row_id
Left Outer Join Siebel.s_org_ext T15 On T14.prtnr_ou_id = T15.row_id
Left Outer Join Siebel.s_contact T16 On T1.pr_bl_per_id = T16.row_id
Left Outer Join Siebel.s_addr_org T17 On T1.pr_bl_addr_id = T17.row_id
Left Outer Join Siebel.s_employee T18 On T2.pr_emp_id = T18.row_id
Where
((t1.ou_num_1 Like '92%') And Ucase(t1.ou_num_1) = Ucase(cast('9290163' As Varchar(4000))))
Order By
T1.name, T1.loc;