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_TAX_GROUP_CODES_ALL

Line 1371: AR_TAX_GROUP_CODES_ALL ar_grp,

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
1375: AND ar_vat.vat_tax_id = ar_grp.tax_code_id

Line 1633: AR_TAX_GROUP_CODES_ALL taxgrp,

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
1637: AND taxgrp.tax_group_type =idmap.source

Line 1819: AR_TAX_GROUP_CODES_ALL taxgrp

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
1822: taxes.RECORD_TYPE_CODE = 'MIGRATED'
1823: AND taxes.tax_type_code = 'LOCATION'

Line 1941: ar_tax_group_codes_all taxgrp,

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

Line 1998: ar_tax_group_codes_all taxgrp,

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

Line 2562: AR_TAX_GROUP_CODES_ALL GROUPS,

2558: rates.CONTENT_OWNER_ID CONTENT_OWNER_ID ,
2559: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2560: rules.TAX_RULE_ID TAX_RULE_ID
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,

Line 2739: AR_TAX_GROUP_CODES_ALL gc,

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,
2743: ZX_RATES_B rates,

Line 2917: AR_TAX_GROUP_CODES_ALL gc,

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,
2921: ZX_TAXES_B TAXES,

Line 3057: AR_TAX_GROUP_CODES_ALL taxgrp,

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
3061: WHERE gvat.vat_tax_id = taxgrp.tax_group_id

Line 3113: AR_TAX_GROUP_CODES_ALL taxgrp,

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,
3117: ar_system_parameters_all sys,

Line 3273: AR_TAX_GROUP_CODES_ALL taxgrp,

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,
3277: ZX_CONDITION_GROUPS_B cg,

Line 3329: AR_TAX_GROUP_CODES_ALL taxgrp,

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,
3333: ZX_CONDITION_GROUPS_B cg,