[Home] [Help]
1928: 1 PRIORITY
1929: FROM
1930: ZX_TAXES_B taxes,
1931: -- AR_VAT_TAX_ALL_B vat,
1932: zx_party_tax_profile ptp,
1933: ar_system_parameters_all sys
1934: WHERE
1935: taxes.RECORD_TYPE_CODE = 'MIGRATED'
1936: AND taxes.tax_type_code = 'LOCATION'
1974: taxgrp.tax_group_code_id PRIORITY
1975: FROM
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
2139: taxes.CONTENT_OWNER_ID,
2140: srvtype.service_type_code l_service_type_code
2141: FROM
2142: ZX_TAXES_B taxes,
2143: zx_party_tax_profile ptp,
2144: ar_system_parameters_all sys,
2145: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2146: FROM DUAL
2147: UNION
3041: NULL EXCEPTION_SET_ID ,
3042: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT
3043: FROM ZX_TAXES_B TAXES,
3044: ZX_CONDITION_GROUPS_B CG,
3045: ZX_PARTY_TAX_PROFILE PTP,
3046: AR_VAT_TAX_ALL_B VAT ,
3047: ZX_RULES_B RULES,
3048: ar_system_parameters_all sys
3049: WHERE
3096: AR_TAX_CONDITIONS_ALL excp,
3097: ZX_TAXES_B TAXES,
3098: ZX_RULES_B rules,
3099: ZX_CONDITION_GROUPS_B cond_groups,
3100: ZX_PARTY_TAX_PROFILE PTP,
3101: ar_system_parameters_all sys
3102: WHERE
3103: gvat.vat_tax_id = gc.tax_group_id
3104: AND gc.tax_group_type = 'AR'
3297: ZX_TAXES_B TAXES,
3298: ZX_RULES_B rules,
3299: ZX_CONDITION_GROUPS_B cg,
3300: ar_system_parameters_all sys,
3301: zx_party_tax_profile ptp
3302:
3303: WHERE taxgrp.tax_group_type = 'AR'
3304: AND taxgrp.product_fisc_classification ||
3305: taxgrp.trx_business_category_code ||
3514: ZX_TAXES_B TAXES,
3515: ZX_RULES_B rules,
3516: ZX_CONDITION_GROUPS_B cg,
3517: ar_system_parameters_all sys,
3518: zx_party_tax_profile ptp,
3519: ZX_RATES_B oklrates,
3520: ZX_RATES_B rates
3521:
3522: WHERE taxgrp.tax_group_type = 'AR'