This Query is used to extract all the TAX Type that are available in the system, Especially used when Migrating the data and reporting purpose.
Script:
SELECT
‘GST’ “Tax Regime Code”,
tax_type_name,
tax_type_code,
NULL “START_DATE”,
recoverable_flag “Recoverable tax”,
self_assessed_flag “Self assessed/RCM”,
tax_point_basis_desc,
c.name “LEDGER NAME”,
d.name “Operating Unit Name”,
e.organization_name,
location_code,
gcc1.concatenated_segments Conc_Segments1,
gcc2.concatenated_segments Conc_Segments2,
gcc3.concatenated_segments Conc_Segments3,
gcc4.concatenated_segments Conc_Segments4
FROM
jai_tax_types_v a,
jai_tax_accounts b,
gl_ledgers c,
hr_operating_units d,
org_organization_definitions e,
hr_locations loc,
gl_code_combinations_kfv gcc1,
gl_code_combinations_kfv gcc2,
gl_code_combinations_kfv gcc3,
gl_code_combinations_kfv gcc4
WHERE
1 = 1
AND b.tax_account_entity_id = a.tax_type_id
AND b.ledger_id = c.ledger_id
AND b.org_id = d.organization_id
AND b.organization_id = e.organization_id
AND loc.location_id = b.location_id
AND gcc1.code_combination_id = interim_recovery_ccid
AND gcc2.code_combination_id = recovery_ccid
AND gcc3.code_combination_id = interim_liability_ccid
AND gcc4.code_combination_id = liability_ccid;
