[Home] [Help]
1523:
1524: ar_grp_tax.TAX_CONSTRAINT_ID CONSTRAINT_ID
1525: FROM
1526: AR_VAT_TAX_ALL_B ar_vat,
1527: AR_TAX_GROUP_CODES_ALL ar_grp,
1528: ar_vat_tax_all_b ar_grp_tax
1529: WHERE ar_grp_tax.tax_type = 'TAX_GROUP'
1530: AND ar_grp_tax.vat_tax_id = ar_grp.TAX_GROUP_ID
1531: AND ar_vat.vat_tax_id = ar_grp.tax_code_id
1785: taxgrp.tax_group_code_id PRIORITY
1786: FROM
1787: ZX_TAXES_B taxes ,
1788: ZX_RATES_B rates,
1789: AR_TAX_GROUP_CODES_ALL taxgrp,
1790: ZX_ID_TCC_MAPPING_ALL idmap
1791: WHERE taxgrp.ENABLED_FLAG = 'Y'
1792: AND taxgrp.tax_code_id = idmap.tax_rate_code_id
1793: AND taxgrp.tax_group_type =idmap.source
1976: ZX_TAXES_B taxes,
1977: AR_VAT_TAX_ALL_B vat,
1978: zx_party_tax_profile ptp,
1979: ar_system_parameters_all sys,
1980: AR_TAX_GROUP_CODES_ALL taxgrp
1981:
1982: WHERE
1983: taxes.RECORD_TYPE_CODE = 'MIGRATED'
1984: AND taxes.tax_type_code = 'LOCATION'
2103: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET','LOCATION')
2104: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
2105: AND EXISTS (SELECT 1
2106: FROM zx_rates_b rates,
2107: ar_tax_group_codes_all taxgrp,
2108: ar_vat_tax_all tax
2109: WHERE taxgrp.tax_group_type = 'AR'
2110: AND taxgrp.tax_code_id = tax.vat_tax_id
2111: AND taxgrp.org_id = tax.org_id
2160: -- only create the rate determining rules for the tax codes in the tax group with
2161: -- at least one not NULL PFC, PTFC, TBC and not the migrated disabled leasing location taxes
2162: AND EXISTS (SELECT 1
2163: FROM zx_rates_b rates,
2164: ar_tax_group_codes_all taxgrp,
2165: ar_vat_tax_all tax
2166: WHERE taxgrp.tax_group_type = 'AR'
2167: AND taxgrp.tax_code_id = tax.vat_tax_id
2168: AND taxgrp.org_id = tax.org_id
2725: rates.CONTENT_OWNER_ID CONTENT_OWNER_ID ,
2726: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2727: rules.TAX_RULE_ID TAX_RULE_ID
2728: FROM
2729: AR_TAX_GROUP_CODES_ALL GROUPS,
2730: AP_TAX_CODES_ALL GROUP_CODES,
2731: AP_TAX_CODES_ALL CODES,
2732: ZX_RATES_B rates,
2733: ZX_RULES_B rules,
2903: rules.TAX_RULE_ID TAX_RULE_ID ,
2904: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
2905: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID
2906: FROM AR_VAT_TAX_ALL_B gvat,
2907: AR_TAX_GROUP_CODES_ALL gc,
2908: AR_VAT_TAX_ALL_B vat,
2909: AR_TAX_CONDITIONS_ALL cond,
2910: AR_TAX_CONDITIONS_ALL excp,
2911: ZX_RATES_B rates,
3089: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
3090: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
3091: NULL RATE_RESULT
3092: FROM AR_VAT_TAX_ALL_B gvat,
3093: AR_TAX_GROUP_CODES_ALL gc,
3094: AR_VAT_TAX_ALL_B vat,
3095: AR_TAX_CONDITIONS_ALL cond,
3096: AR_TAX_CONDITIONS_ALL excp,
3097: ZX_TAXES_B TAXES,
3236: taxgrp.TAX_CONDITION_ID CONDITION_SET_ID ,
3237: taxgrp.TAX_EXCEPTION_ID EXCEPTION_SET_ID
3238:
3239: FROM AR_VAT_TAX_ALL_B gvat,
3240: AR_TAX_GROUP_CODES_ALL taxgrp,
3241: ZX_TAXES_B TAXES,
3242: ZX_RULES_B rules,
3243: ZX_CONDITION_GROUPS_B cg
3244: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3292: taxgrp.tax_condition_id CONDITION_SET_ID ,
3293: taxgrp.tax_exception_id EXCEPTION_SET_ID
3294:
3295: FROM AR_VAT_TAX_ALL_B gvat,
3296: AR_TAX_GROUP_CODES_ALL taxgrp,
3297: ZX_TAXES_B TAXES,
3298: ZX_RULES_B rules,
3299: ZX_CONDITION_GROUPS_B cg,
3300: ar_system_parameters_all sys,
3452: rates.tax_status_code STATUS_RESULT ,
3453: rates.tax_rate_code RATE_RESULT
3454:
3455: FROM AR_VAT_TAX_ALL_B gvat,
3456: AR_TAX_GROUP_CODES_ALL taxgrp,
3457: AR_VAT_TAX_ALL_B vat,
3458: -- ZX_TAXES_B TAXES,
3459: ZX_RULES_B rules,
3460: ZX_CONDITION_GROUPS_B cg,
3508: rates.tax_status_code STATUS_RESULT ,
3509: rates.tax_rate_code RATE_RESULT
3510:
3511: FROM AR_VAT_TAX_ALL_B gvat,
3512: AR_TAX_GROUP_CODES_ALL taxgrp,
3513: AR_VAT_TAX_ALL_B vat,
3514: ZX_TAXES_B TAXES,
3515: ZX_RULES_B rules,
3516: ZX_CONDITION_GROUPS_B cg,