Oracle EBS 纳税账户信息查询 可退税/应纳税额
-- 纳税账户信息查询 -- 可退税/应纳税额
SELECT *
FROM (SELECT za.tax_account_entity_id
,za.tax_account_id
,za.internal_organization_id
,za.ledger_id
,za.tax_account_ccid
,za.non_rec_account_ccid
,za.tax_account_entity_code
,za.interim_tax_ccid
,za.adj_ccid
,za.edisc_ccid
,za.unedisc_ccid
,za.finchrg_ccid
,za.adj_non_rec_tax_ccid
,za.edisc_non_rec_tax_ccid
,za.unedisc_non_rec_tax_ccid
,za.finchrg_non_rec_tax_ccid
,hrou.name
,0 AS showtext
,NULL AS trans_attr
,za.object_version_number
,'RemoveDisabled' AS remove_image
,gl.name AS ledger_name
,gl.chart_of_accounts_id
,fifs.id_flex_structure_code
,gcc.SEGMENT1
,gcc.segment2
,gcc.segment3
,gcc.SEGMENT4
,gcc.segment5
,gcc.segment6
,gcc.SEGMENT7
,gcc.segment8
,gcc.segment9
FROM zx_accounts za
,hr_operating_units hrou
,gl_ledgers gl
,fnd_id_flex_structures fifs
,gl_code_combinations gcc
.apps.zx_mco_eo_rates_v ratesbeo
WHERE za.internal_organization_id = hrou.organization_id
AND gl.ledger_id = za.ledger_id
AND fifs.application_id = 101
AND fifs.id_flex_code = 'GL#'
AND fifs.id_flex_num = gl.chart_of_accounts_id
AND hrou.organization_id = 参数组织ID-- 参数组织ID
AND gcc.CODE_COMBINATION_ID = za.tax_account_ccid
) qrslt
WHERE tax_account_entity_id = 税率 ID -- 税率 ID
;
--查询税率ID tax_account_entity_id 参考 视图 zx_mco_eo_rates_v tax_rate_id
-- 刘轶鹤