select gcck.concatenated_segments 科目组合, -- xla_oa_functions_pkg.get_ccid_description(gcck.chart_of_accounts_id,gcck.code_combination_id) 科目组合描述, gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id, 3,gcck.segment3) 科目描述, zrb.tax_rate_code 税代码, hou.name 业务实体, gl.name 分类账, (select fu.description from fnd_user fu where fu.user_id=za.last_updated_by) 更新者, (select fu.description from fnd_user fu where fu.user_id=za.created_by) 创建者, zrb.rate_type_code 税率类型 from ZX_ACCOUNTS za ,zx_rates_b zrb ,gl_ledgers gl ,gl_code_combinations_kfv gcck ,hr_operating_units hou where za.tax_account_entity_id=zrb.tax_rate_id and gl.ledger_id=za.ledger_id --and gl.name like '1135%' and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and za.tax_account_ccid=gcck.code_combination_id and za.internal_organization_id=hou.organization_id --and hou.name like '%橡胶%' ;