ebs r12国家表

SELECT b.rowid row_id,
       b.eu_code,
       b.territory_code,
       b.last_update_date,
       b.last_updated_by,
       b.creation_date,
       b.created_by,
       b.iso_numeric_code,
       b.alternate_territory_code,
       b.last_update_login,
       b.nls_territory,
       b.address_style,
       b.address_validation,
       b.bank_info_style,
       b.bank_info_validation,
       b.obsolete_flag,
       t.territory_short_name,
       t.description,
       b.iso_territory_code
  FROM fnd_territories_tl t, fnd_territories b
 WHERE b.territory_code = t.territory_code
   AND t.language ='ZHS' 
   
   and b.territory_code='CN'
   and t.territory_short_name= '中国'