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 AR_VAT_TAX_ALL

Line 825: AR_VAT_TAX_ALL_B ar_vat --Bug 5061471

821: ar_vat.tax_code
822: ALPHANUMERIC_VALUE1 ,
823: ar_vat.TAX_CONSTRAINT_ID CONSTRAINT_ID
824: FROM
825: AR_VAT_TAX_ALL_B ar_vat --Bug 5061471
826: WHERE
827: ar_vat.tax_type IN ( 'TAX_GROUP','LOCATION')
828: OR EXISTS ( SELECT 1
829: FROM ar_system_parameters_all sys

Line 1370: AR_VAT_TAX_ALL_B ar_vat,

1366: ar_grp.party_fisc_classification ALPHANUMERIC_VALUE4 ,
1367:
1368: ar_grp_tax.TAX_CONSTRAINT_ID CONSTRAINT_ID
1369: FROM
1370: AR_VAT_TAX_ALL_B ar_vat,
1371: AR_TAX_GROUP_CODES_ALL ar_grp,
1372: ar_vat_tax_all_b ar_grp_tax
1373: WHERE ar_grp_tax.tax_type = 'TAX_GROUP'
1374: AND ar_grp_tax.vat_tax_id = ar_grp.TAX_GROUP_ID

Line 1372: ar_vat_tax_all_b ar_grp_tax

1368: ar_grp_tax.TAX_CONSTRAINT_ID CONSTRAINT_ID
1369: FROM
1370: AR_VAT_TAX_ALL_B ar_vat,
1371: AR_TAX_GROUP_CODES_ALL ar_grp,
1372: ar_vat_tax_all_b ar_grp_tax
1373: WHERE ar_grp_tax.tax_type = 'TAX_GROUP'
1374: AND ar_grp_tax.vat_tax_id = ar_grp.TAX_GROUP_ID
1375: AND ar_vat.vat_tax_id = ar_grp.tax_code_id
1376: AND ar_vat.tax_type <> 'TAX_GROUP'

Line 1770: -- AR_VAT_TAX_ALL_B vat,

1766: 'Y' ENABLED_FLAG, -- Bug 5209434
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'

Line 1788: SELECT 1 FROM ar_vat_tax_all_b vat WHERE vat.tax_type = 'LOCATION'

1784: -- Added following AND condition for Sync process
1785: AND taxes.tax = nvl(p_tax,taxes.tax)
1786: -- Bug 5209434
1787: AND EXISTS (
1788: SELECT 1 FROM ar_vat_tax_all_b vat WHERE vat.tax_type = 'LOCATION'
1789: AND vat.set_of_books_id = sys.set_of_books_id
1790: AND vat.org_id = sys.org_id
1791: AND vat.enabled_flag = 'Y'
1792: )

Line 1816: AR_VAT_TAX_ALL_B vat,

1812: 'Y' ENABLED_FLAG, -- Bug 5209434
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:

Line 1838: SELECT 1 FROM ar_vat_tax_all_b vat

1834: -- Added following AND condition for Sync process
1835: AND taxes.tax = nvl(p_tax,taxes.tax)
1836: -- Bug 5209434
1837: /*AND EXISTS (
1838: SELECT 1 FROM ar_vat_tax_all_b vat
1839: WHERE vat.tax_type = 'LOCATION'
1840: AND vat.set_of_books_id = sys.set_of_books_id
1841: AND vat.org_id = sys.org_id
1842: AND vat.enabled_flag = 'Y'

Line 1942: ar_vat_tax_all tax

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
1945: AND taxgrp.org_id = tax.org_id
1946: AND tax.vat_tax_id = rates.tax_rate_id

Line 1999: ar_vat_tax_all tax

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
2002: AND taxgrp.org_id = tax.org_id
2003: AND tax.vat_tax_id = rates.tax_rate_id

Line 2690: AR_VAT_TAX_ALL_B codes,

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
2692: WHERE
2693: rates.RECORD_TYPE_CODE = 'MIGRATED'
2694: AND codes.vat_tax_id = rates.tax_rate_id

Line 2738: FROM AR_VAT_TAX_ALL_B gvat,

2734: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2735: rules.TAX_RULE_ID TAX_RULE_ID ,
2736: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
2737: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID
2738: FROM AR_VAT_TAX_ALL_B gvat,
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,

Line 2740: AR_VAT_TAX_ALL_B vat,

2736: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
2737: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID
2738: FROM AR_VAT_TAX_ALL_B gvat,
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,

Line 2871: AR_VAT_TAX_ALL_B VAT ,

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
2875: taxes.RECORD_TYPE_CODE = 'MIGRATED'

Line 2916: FROM AR_VAT_TAX_ALL_B gvat,

2912: rules.TAX_RULE_ID TAX_RULE_ID ,
2913: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
2914: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
2915: NULL RATE_RESULT
2916: FROM AR_VAT_TAX_ALL_B gvat,
2917: AR_TAX_GROUP_CODES_ALL gc,
2918: AR_VAT_TAX_ALL_B vat,
2919: AR_TAX_CONDITIONS_ALL cond,
2920: AR_TAX_CONDITIONS_ALL excp,

Line 2918: AR_VAT_TAX_ALL_B vat,

2914: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
2915: NULL RATE_RESULT
2916: FROM AR_VAT_TAX_ALL_B gvat,
2917: AR_TAX_GROUP_CODES_ALL gc,
2918: AR_VAT_TAX_ALL_B vat,
2919: AR_TAX_CONDITIONS_ALL cond,
2920: AR_TAX_CONDITIONS_ALL excp,
2921: ZX_TAXES_B TAXES,
2922: ZX_RULES_B rules,

Line 3056: FROM AR_VAT_TAX_ALL_B gvat,

3052: rules.TAX_RULE_ID TAX_RULE_ID ,
3053: taxgrp.TAX_CONDITION_ID CONDITION_SET_ID ,
3054: taxgrp.TAX_EXCEPTION_ID EXCEPTION_SET_ID
3055:
3056: FROM AR_VAT_TAX_ALL_B gvat,
3057: AR_TAX_GROUP_CODES_ALL taxgrp,
3058: ZX_TAXES_B TAXES,
3059: ZX_RULES_B rules,
3060: ZX_CONDITION_GROUPS_B cg

Line 3071: ar_vat_tax_all vat

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
3075: AND rates.tax = taxes.tax

Line 3112: FROM AR_VAT_TAX_ALL_B gvat,

3108: rules.TAX_RULE_ID TAX_RULE_ID ,
3109: taxgrp.tax_condition_id CONDITION_SET_ID ,
3110: taxgrp.tax_exception_id EXCEPTION_SET_ID
3111:
3112: FROM AR_VAT_TAX_ALL_B gvat,
3113: AR_TAX_GROUP_CODES_ALL taxgrp,
3114: ZX_TAXES_B TAXES,
3115: ZX_RULES_B rules,
3116: ZX_CONDITION_GROUPS_B cg,

Line 3136: FROM ar_vat_tax_all_b vat

3132: AND gvat.org_id = sys.org_id
3133: AND sys.org_id = ptp.party_id
3134: AND ptp.party_type_code = 'OU'
3135: /* AND EXISTS (SELECT 1
3136: FROM ar_vat_tax_all_b vat
3137: WHERE vat.tax_type = 'LOCATION'
3138: AND vat.set_of_books_id = sys.set_of_books_id
3139: AND vat.org_id = sys.org_id
3140: AND vat.enabled_flag = 'Y'

Line 3146: ar_vat_tax_all tax

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
3150: AND tax.tax_type = 'LOCATION'

Line 3272: FROM AR_VAT_TAX_ALL_B gvat,

3268: taxgrp.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
3269: rates.tax_status_code STATUS_RESULT ,
3270: rates.tax_rate_code RATE_RESULT
3271:
3272: FROM AR_VAT_TAX_ALL_B gvat,
3273: AR_TAX_GROUP_CODES_ALL taxgrp,
3274: AR_VAT_TAX_ALL_B vat,
3275: -- ZX_TAXES_B TAXES,
3276: ZX_RULES_B rules,

Line 3274: AR_VAT_TAX_ALL_B vat,

3270: rates.tax_rate_code RATE_RESULT
3271:
3272: FROM AR_VAT_TAX_ALL_B gvat,
3273: AR_TAX_GROUP_CODES_ALL taxgrp,
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

Line 3328: FROM AR_VAT_TAX_ALL_B gvat,

3324: taxgrp.tax_exception_id EXCEPTION_SET_ID ,
3325: rates.tax_status_code STATUS_RESULT ,
3326: rates.tax_rate_code RATE_RESULT
3327:
3328: FROM AR_VAT_TAX_ALL_B gvat,
3329: AR_TAX_GROUP_CODES_ALL taxgrp,
3330: AR_VAT_TAX_ALL_B vat,
3331: ZX_TAXES_B TAXES,
3332: ZX_RULES_B rules,

Line 3330: AR_VAT_TAX_ALL_B vat,

3326: rates.tax_rate_code RATE_RESULT
3327:
3328: FROM AR_VAT_TAX_ALL_B gvat,
3329: AR_TAX_GROUP_CODES_ALL taxgrp,
3330: AR_VAT_TAX_ALL_B vat,
3331: ZX_TAXES_B TAXES,
3332: ZX_RULES_B rules,
3333: ZX_CONDITION_GROUPS_B cg,
3334: ar_system_parameters_all sys,