[Home] [Help]
1767: 1 PRIORITY
1768: FROM
1769: ZX_TAXES_B taxes,
1770: -- AR_VAT_TAX_ALL_B vat,
1771: zx_party_tax_profile ptp,
1772: ar_system_parameters_all sys
1773: WHERE
1774: taxes.RECORD_TYPE_CODE = 'MIGRATED'
1775: AND taxes.tax_type_code = 'LOCATION'
1813: (taxgrp.tax_group_id * 2) + taxgrp.DISPLAY_ORDER PRIORITY
1814: FROM
1815: ZX_TAXES_B taxes,
1816: AR_VAT_TAX_ALL_B vat,
1817: zx_party_tax_profile ptp,
1818: ar_system_parameters_all sys,
1819: AR_TAX_GROUP_CODES_ALL taxgrp
1820:
1821: WHERE
1973: taxes.CONTENT_OWNER_ID,
1974: srvtype.service_type_code l_service_type_code
1975: FROM
1976: ZX_TAXES_B taxes,
1977: zx_party_tax_profile ptp,
1978: ar_system_parameters_all sys,
1979: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1980: FROM DUAL
1981: UNION
2866: NULL EXCEPTION_SET_ID ,
2867: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT
2868: FROM ZX_TAXES_B TAXES,
2869: ZX_CONDITION_GROUPS_B CG,
2870: ZX_PARTY_TAX_PROFILE PTP,
2871: AR_VAT_TAX_ALL_B VAT ,
2872: ZX_RULES_B RULES,
2873: ar_system_parameters_all sys
2874: WHERE
2920: AR_TAX_CONDITIONS_ALL excp,
2921: ZX_TAXES_B TAXES,
2922: ZX_RULES_B rules,
2923: ZX_CONDITION_GROUPS_B cond_groups,
2924: ZX_PARTY_TAX_PROFILE PTP,
2925: ar_system_parameters_all sys
2926: WHERE
2927: gvat.vat_tax_id = gc.tax_group_id
2928: AND gc.tax_group_type = 'AR'
3114: ZX_TAXES_B TAXES,
3115: ZX_RULES_B rules,
3116: ZX_CONDITION_GROUPS_B cg,
3117: ar_system_parameters_all sys,
3118: zx_party_tax_profile ptp
3119:
3120: WHERE taxgrp.tax_group_type = 'AR'
3121: AND taxgrp.product_fisc_classification ||
3122: taxgrp.trx_business_category_code ||
3331: ZX_TAXES_B TAXES,
3332: ZX_RULES_B rules,
3333: ZX_CONDITION_GROUPS_B cg,
3334: ar_system_parameters_all sys,
3335: zx_party_tax_profile ptp,
3336: ZX_RATES_B oklrates,
3337: ZX_RATES_B rates
3338:
3339: WHERE taxgrp.tax_group_type = 'AR'