查询纳税账户

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 '%橡胶%'
;

 

转载于:https://www.cnblogs.com/lizicheng/p/8711588.html