E-Business suite tax rates and accounts query

E-Business suite tax rates and accounts query
EBTax tax rate details
Oracle apps tax tables
Oracle apps r12 tax rates tables
E-Business suite tax rates and GL accounts

--Tax rate and account query

  SELECT rb.tax_regime_code,
         rb.tax,
         rb.rate_type_code,
         rb.percentage_rate,
         rb.last_update_date,
         za.last_update_date,
         rb.tax_rate_code,
         rb.rate_type_code,
         rb.percentage_rate,
         rb.recovery_type_code,
         za.tax_account_ccid,
         za.tax_account_entity_id,
         za.tax_account_id,
         gcc.concatenated_segments,
         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,
         za.object_version_number,
         gl.name AS ledger_name,
         gl.chart_of_accounts_id,
         fifs.id_flex_structure_code
    FROM zx_accounts            za,
         hr_operating_units     hrou,
         gl_ledgers             gl,
         fnd_id_flex_structures fifs,
         zx_rates_b             rb,
         gl_code_combinations_kfv gcc
   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.name = '<your operating unit>'
         AND rb.tax_rate_code = '<your tax rate code>'
         AND za.tax_account_entity_code = 'RATES'
         AND za.tax_account_entity_id = rb.tax_rate_id
         AND za.tax_account_ccid = gcc.code_combination_id(+)
ORDER BY za.last_update_date DESC;

Related posts:

• Query to find all APIs of Oracle Apps modules
• E-Business suite tax rates and accounts query
• Query to get customer tax registration details in R12

Upload your own post and refer it anywhere anytime: