E-Business suite tax rates and accounts query

1--Tax rate and account query
2
3  SELECT rb.tax_regime_code,
4         rb.tax,
5         rb.rate_type_code,
6         rb.percentage_rate,
7         rb.last_update_date,
8         za.last_update_date,
9         rb.tax_rate_code,
10         rb.rate_type_code,
11         rb.percentage_rate,
12         rb.recovery_type_code,
13         za.tax_account_ccid,
14         za.tax_account_entity_id,
15         za.tax_account_id,
16         gcc.concatenated_segments,
17         za.internal_organization_id,
18         za.ledger_id,
19         za.tax_account_ccid,
20         za.non_rec_account_ccid,
21         za.tax_account_entity_code,
22         za.interim_tax_ccid,
23         za.adj_ccid,
24         za.edisc_ccid,
25         za.unedisc_ccid,
26         za.finchrg_ccid,
27         za.adj_non_rec_tax_ccid,
28         za.edisc_non_rec_tax_ccid,
29         za.unedisc_non_rec_tax_ccid,
30         za.finchrg_non_rec_tax_ccid,
31         hrou.name,
32         za.object_version_number,
33         gl.name AS ledger_name,
34         gl.chart_of_accounts_id,
35         fifs.id_flex_structure_code
36    FROM zx_accounts            za,
37         hr_operating_units     hrou,
38         gl_ledgers             gl,
39         fnd_id_flex_structures fifs,
40         zx_rates_b             rb,
41         gl_code_combinations_kfv gcc
42   WHERE     za.internal_organization_id = hrou.organization_id
43         AND gl.ledger_id = za.ledger_id
44         AND fifs.application_id = 101
45         AND fifs.id_flex_code = 'GL#'
46         AND fifs.id_flex_num = gl.chart_of_accounts_id
47         AND hrou.name = '<your operating unit>'
48         AND rb.tax_rate_code = '<your tax rate code>'
49         AND za.tax_account_entity_code = 'RATES'
50         AND za.tax_account_entity_id = rb.tax_rate_id
51         AND za.tax_account_ccid = gcc.code_combination_id(+)
52ORDER BY za.last_update_date DESC;