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 1628: from zx_rates_b rates, FND_LOOKUP_VALUES codes

1624:
1625: /* Commented Bug : 5061471
1626: INSERT ALL
1627: WHEN (exists (select 1
1628: from zx_rates_b rates, FND_LOOKUP_VALUES codes
1629: where codes.language = userenv('LANG')
1630: and codes.view_application_id = 0
1631: and rates.tax_rate_code = NVL(codes.tag,codes.lookup_code)
1632: and codes.lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_OUTPUT_CLASSIFICATIONS')

Line 1788: ZX_RATES_B rates,

1784: taxes.CONTENT_OWNER_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

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

1830: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1831: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1832: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1833: and exists ( select 1
1834: from zx_rates_b rates,zx_id_tcc_mapping_all idmap,ar_system_parameters_all sys
1835: where idmap.ledger_id = sys.set_of_books_id
1836: AND idmap.org_id = sys.org_id
1837: AND idmap.source = 'AR'
1838: AND sys.tax_method = 'SALES_TAX'

Line 2106: FROM zx_rates_b rates,

2102: WHERE
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

Line 2163: FROM zx_rates_b rates,

2159: AND taxes.tax = nvl(p_tax,taxes.tax)
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

Line 2687: ZX_RATES_B rates,

2683: rules.CONTENT_OWNER_ID CONTENT_OWNER_ID ,
2684: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2685: rules.TAX_RULE_ID TAX_RULE_ID
2686: FROM
2687: ZX_RATES_B rates,
2688: FND_LOOKUPS fnd,
2689: ZX_RULES_B rules,
2690: ZX_CONDITION_GROUPS_B cond_groups,
2691: AP_TAX_CODES_ALL codes

Line 2732: ZX_RATES_B rates,

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,
2734: ZX_CONDITION_GROUPS_B cond_groups
2735: WHERE
2736: GROUP_CODES.TAX_ID = GROUPS.TAX_GROUP_ID

Line 2854: ZX_RATES_B rates,

2850: rules.TAX_RULE_ID TAX_RULE_ID ,
2851: NULL CONDITION_SET_ID ,
2852: NULL EXCEPTION_SET_ID
2853: FROM
2854: ZX_RATES_B rates,
2855: ZX_RULES_B rules,
2856: ZX_CONDITION_GROUPS_B cond_groups,
2857: AR_VAT_TAX_ALL_B codes,
2858: ar_system_parameters_all sys

Line 2911: ZX_RATES_B rates,

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,
2912: ZX_RULES_B rules,
2913: ZX_CONDITION_GROUPS_B cond_groups
2914: WHERE
2915: gvat.vat_tax_id = gc.tax_group_id

Line 3253: FROM zx_rates_b rates,

3249: taxgrp.party_fisc_classification IS NOT NULL
3250: AND taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET', 'LOCATION')
3251: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
3252: AND EXISTS (SELECT 1
3253: FROM zx_rates_b rates,
3254: ar_vat_tax_all vat
3255: WHERE taxgrp.tax_code_id = vat.vat_tax_id
3256: AND taxgrp.org_id = vat.org_id
3257: AND vat.vat_tax_id = rates.tax_rate_id

Line 3328: FROM zx_rates_b rates,

3324: ) */
3325: -- find the migrationed location based taxes in the tax group and
3326: -- filter the disabled location based tax
3327: AND EXISTS (SELECT 1
3328: FROM zx_rates_b rates,
3329: ar_vat_tax_all tax
3330: WHERE taxgrp.tax_code_id = tax.vat_tax_id
3331: AND taxgrp.org_id = tax.org_id
3332: AND tax.vat_tax_id = rates.tax_rate_id

Line 3461: ZX_RATES_B rates

3457: AR_VAT_TAX_ALL_B vat,
3458: -- ZX_TAXES_B TAXES,
3459: ZX_RULES_B rules,
3460: ZX_CONDITION_GROUPS_B cg,
3461: ZX_RATES_B rates
3462: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3463: AND taxgrp.tax_group_type = 'AR'
3464: AND gvat.tax_type = 'TAX_GROUP'
3465: AND taxgrp.product_fisc_classification ||

Line 3519: ZX_RATES_B oklrates,

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

Line 3520: ZX_RATES_B rates

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'
3523: AND taxgrp.product_fisc_classification ||
3524: taxgrp.trx_business_category_code ||