eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_RATES_B

Line 1472: from zx_rates_b rates, FND_LOOKUP_VALUES codes

1468:
1469: /* Commented Bug : 5061471
1470: INSERT ALL
1471: WHEN (exists (select 1
1472: from zx_rates_b rates, FND_LOOKUP_VALUES codes
1473: where codes.language = userenv('LANG')
1474: and codes.view_application_id = 0
1475: and rates.tax_rate_code = NVL(codes.tag,codes.lookup_code)
1476: and codes.lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_OUTPUT_CLASSIFICATIONS')

Line 1632: ZX_RATES_B rates,

1628: taxes.CONTENT_OWNER_ID,
1629: (taxgrp.tax_group_id * 2) + taxgrp.DISPLAY_ORDER PRIORITY
1630: FROM
1631: ZX_TAXES_B taxes ,
1632: ZX_RATES_B rates,
1633: AR_TAX_GROUP_CODES_ALL taxgrp,
1634: ZX_ID_TCC_MAPPING_ALL idmap
1635: WHERE
1636: taxgrp.tax_code_id = idmap.tax_rate_code_id

Line 1675: from zx_rates_b rates,zx_id_tcc_mapping_all idmap,ar_system_parameters_all sys

1671: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1672: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1673: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1674: and exists ( select 1
1675: from zx_rates_b rates,zx_id_tcc_mapping_all idmap,ar_system_parameters_all sys
1676: where idmap.ledger_id = sys.set_of_books_id
1677: AND idmap.org_id = sys.org_id
1678: AND idmap.source = 'AR'
1679: AND sys.tax_method = 'SALES_TAX'

Line 1940: FROM zx_rates_b rates,

1936: WHERE
1937: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET','LOCATION')
1938: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1939: AND EXISTS (SELECT 1
1940: FROM zx_rates_b rates,
1941: ar_tax_group_codes_all taxgrp,
1942: ar_vat_tax_all tax
1943: WHERE taxgrp.tax_group_type = 'AR'
1944: AND taxgrp.tax_code_id = tax.vat_tax_id

Line 1997: FROM zx_rates_b rates,

1993: AND taxes.tax = nvl(p_tax,taxes.tax)
1994: -- only create the rate determining rules for the tax codes in the tax group with
1995: -- at least one not NULL PFC, PTFC, TBC and not the migrated disabled leasing location taxes
1996: AND EXISTS (SELECT 1
1997: FROM zx_rates_b rates,
1998: ar_tax_group_codes_all taxgrp,
1999: ar_vat_tax_all tax
2000: WHERE taxgrp.tax_group_type = 'AR'
2001: AND taxgrp.tax_code_id = tax.vat_tax_id

Line 2521: ZX_RATES_B rates,

2517: rules.CONTENT_OWNER_ID CONTENT_OWNER_ID ,
2518: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2519: rules.TAX_RULE_ID TAX_RULE_ID
2520: FROM
2521: ZX_RATES_B rates,
2522: FND_LOOKUPS fnd,
2523: ZX_RULES_B rules,
2524: ZX_CONDITION_GROUPS_B cond_groups,
2525: AP_TAX_CODES_ALL codes

Line 2565: ZX_RATES_B rates,

2561: FROM
2562: AR_TAX_GROUP_CODES_ALL GROUPS,
2563: AP_TAX_CODES_ALL GROUP_CODES,
2564: AP_TAX_CODES_ALL CODES,
2565: ZX_RATES_B rates,
2566: ZX_RULES_B rules,
2567: ZX_CONDITION_GROUPS_B cond_groups
2568: WHERE
2569: GROUP_CODES.TAX_ID = GROUPS.TAX_GROUP_ID

Line 2687: ZX_RATES_B rates,

2683: rules.TAX_RULE_ID TAX_RULE_ID ,
2684: NULL CONDITION_SET_ID ,
2685: NULL EXCEPTION_SET_ID
2686: FROM
2687: ZX_RATES_B rates,
2688: ZX_RULES_B rules,
2689: ZX_CONDITION_GROUPS_B cond_groups,
2690: AR_VAT_TAX_ALL_B codes,
2691: ar_system_parameters_all sys

Line 2743: ZX_RATES_B rates,

2739: AR_TAX_GROUP_CODES_ALL gc,
2740: AR_VAT_TAX_ALL_B vat,
2741: AR_TAX_CONDITIONS_ALL cond,
2742: AR_TAX_CONDITIONS_ALL excp,
2743: ZX_RATES_B rates,
2744: ZX_RULES_B rules,
2745: ZX_CONDITION_GROUPS_B cond_groups
2746: WHERE
2747: gvat.vat_tax_id = gc.tax_group_id

Line 3070: FROM zx_rates_b rates,

3066: taxgrp.party_fisc_classification IS NOT NULL
3067: AND taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET', 'LOCATION')
3068: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
3069: AND EXISTS (SELECT 1
3070: FROM zx_rates_b rates,
3071: ar_vat_tax_all vat
3072: WHERE taxgrp.tax_code_id = vat.vat_tax_id
3073: AND taxgrp.org_id = vat.org_id
3074: AND vat.vat_tax_id = rates.tax_rate_id

Line 3145: FROM zx_rates_b rates,

3141: ) */
3142: -- find the migrationed location based taxes in the tax group and
3143: -- filter the disabled location based tax
3144: AND EXISTS (SELECT 1
3145: FROM zx_rates_b rates,
3146: ar_vat_tax_all tax
3147: WHERE taxgrp.tax_code_id = tax.vat_tax_id
3148: AND taxgrp.org_id = tax.org_id
3149: AND tax.vat_tax_id = rates.tax_rate_id

Line 3278: ZX_RATES_B rates

3274: AR_VAT_TAX_ALL_B vat,
3275: -- ZX_TAXES_B TAXES,
3276: ZX_RULES_B rules,
3277: ZX_CONDITION_GROUPS_B cg,
3278: ZX_RATES_B rates
3279: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3280: AND taxgrp.tax_group_type = 'AR'
3281: AND gvat.tax_type = 'TAX_GROUP'
3282: AND taxgrp.product_fisc_classification ||

Line 3336: ZX_RATES_B oklrates,

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'
3340: AND taxgrp.product_fisc_classification ||

Line 3337: ZX_RATES_B rates

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'
3340: AND taxgrp.product_fisc_classification ||
3341: taxgrp.trx_business_category_code ||