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_B

Line 838: AR_VAT_TAX_ALL_B ar_vat --Bug 5061471

834: ar_vat.tax_code
835: ALPHANUMERIC_VALUE1 ,
836: ar_vat.TAX_CONSTRAINT_ID CONSTRAINT_ID
837: FROM
838: AR_VAT_TAX_ALL_B ar_vat --Bug 5061471
839: WHERE
840: ar_vat.tax_type IN ( 'TAX_GROUP','LOCATION')
841: OR EXISTS ( SELECT 1
842: FROM ar_system_parameters_all sys

Line 981: FROM AR_VAT_TAX_ALL_B ar_vat --Bug 5061471

977: NULL DETERMINING_FACTOR_CQ1_CODE ,
978: '=' OPERATOR1_CODE ,
979: ar_vat.tax_code ALPHANUMERIC_VALUE1 ,
980: NULL CONSTRAINT_ID
981: FROM AR_VAT_TAX_ALL_B ar_vat --Bug 5061471
982: WHERE ar_vat.taxable_basis IN ('AFTER_EPD', 'QUANTITY')
983: AND ar_vat.global_attribute_category is null
984: AND ar_vat.tax_class = 'O'
985: AND ar_vat.tax_type <> 'TAX_GROUP'

Line 1526: AR_VAT_TAX_ALL_B ar_vat,

1522: ar_grp.party_fisc_classification ALPHANUMERIC_VALUE4 ,
1523:
1524: ar_grp_tax.TAX_CONSTRAINT_ID CONSTRAINT_ID
1525: FROM
1526: AR_VAT_TAX_ALL_B ar_vat,
1527: AR_TAX_GROUP_CODES_ALL ar_grp,
1528: ar_vat_tax_all_b ar_grp_tax
1529: WHERE ar_grp_tax.tax_type = 'TAX_GROUP'
1530: AND ar_grp_tax.vat_tax_id = ar_grp.TAX_GROUP_ID

Line 1528: ar_vat_tax_all_b ar_grp_tax

1524: ar_grp_tax.TAX_CONSTRAINT_ID CONSTRAINT_ID
1525: FROM
1526: AR_VAT_TAX_ALL_B ar_vat,
1527: AR_TAX_GROUP_CODES_ALL ar_grp,
1528: ar_vat_tax_all_b ar_grp_tax
1529: WHERE ar_grp_tax.tax_type = 'TAX_GROUP'
1530: AND ar_grp_tax.vat_tax_id = ar_grp.TAX_GROUP_ID
1531: AND ar_vat.vat_tax_id = ar_grp.tax_code_id
1532: AND ar_vat.tax_type <> 'TAX_GROUP'

Line 1931: -- AR_VAT_TAX_ALL_B vat,

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

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

1945: -- Added following AND condition for Sync process
1946: AND taxes.tax = nvl(p_tax,taxes.tax)
1947: -- Bug 5209434
1948: AND EXISTS (
1949: SELECT 1 FROM ar_vat_tax_all_b vat WHERE vat.tax_type = 'LOCATION'
1950: AND vat.set_of_books_id = sys.set_of_books_id
1951: AND vat.org_id = sys.org_id
1952: AND vat.enabled_flag = 'Y'
1953: )

Line 1977: AR_VAT_TAX_ALL_B vat,

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

Line 1999: SELECT 1 FROM ar_vat_tax_all_b vat

1995: -- Added following AND condition for Sync process
1996: AND taxes.tax = nvl(p_tax,taxes.tax)
1997: -- Bug 5209434
1998: /*AND EXISTS (
1999: SELECT 1 FROM ar_vat_tax_all_b vat
2000: WHERE vat.tax_type = 'LOCATION'
2001: AND vat.set_of_books_id = sys.set_of_books_id
2002: AND vat.org_id = sys.org_id
2003: AND vat.enabled_flag = 'Y'

Line 2857: AR_VAT_TAX_ALL_B codes,

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
2859: WHERE
2860: rates.RECORD_TYPE_CODE = 'MIGRATED'
2861: AND codes.vat_tax_id = rates.tax_rate_id

Line 2906: FROM AR_VAT_TAX_ALL_B gvat,

2902: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2903: rules.TAX_RULE_ID TAX_RULE_ID ,
2904: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
2905: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID
2906: FROM AR_VAT_TAX_ALL_B gvat,
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,

Line 2908: AR_VAT_TAX_ALL_B vat,

2904: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
2905: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID
2906: FROM AR_VAT_TAX_ALL_B gvat,
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,

Line 3046: AR_VAT_TAX_ALL_B VAT ,

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

Line 3092: FROM AR_VAT_TAX_ALL_B gvat,

3088: rules.TAX_RULE_ID TAX_RULE_ID ,
3089: gc.TAX_CONDITION_ID CONDITION_SET_ID ,
3090: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
3091: NULL RATE_RESULT
3092: FROM AR_VAT_TAX_ALL_B gvat,
3093: AR_TAX_GROUP_CODES_ALL gc,
3094: AR_VAT_TAX_ALL_B vat,
3095: AR_TAX_CONDITIONS_ALL cond,
3096: AR_TAX_CONDITIONS_ALL excp,

Line 3094: AR_VAT_TAX_ALL_B vat,

3090: gc.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
3091: NULL RATE_RESULT
3092: FROM AR_VAT_TAX_ALL_B gvat,
3093: AR_TAX_GROUP_CODES_ALL gc,
3094: AR_VAT_TAX_ALL_B vat,
3095: AR_TAX_CONDITIONS_ALL cond,
3096: AR_TAX_CONDITIONS_ALL excp,
3097: ZX_TAXES_B TAXES,
3098: ZX_RULES_B rules,

Line 3239: FROM AR_VAT_TAX_ALL_B gvat,

3235: rules.TAX_RULE_ID TAX_RULE_ID ,
3236: taxgrp.TAX_CONDITION_ID CONDITION_SET_ID ,
3237: taxgrp.TAX_EXCEPTION_ID EXCEPTION_SET_ID
3238:
3239: FROM AR_VAT_TAX_ALL_B gvat,
3240: AR_TAX_GROUP_CODES_ALL taxgrp,
3241: ZX_TAXES_B TAXES,
3242: ZX_RULES_B rules,
3243: ZX_CONDITION_GROUPS_B cg

Line 3295: FROM AR_VAT_TAX_ALL_B gvat,

3291: rules.TAX_RULE_ID TAX_RULE_ID ,
3292: taxgrp.tax_condition_id CONDITION_SET_ID ,
3293: taxgrp.tax_exception_id EXCEPTION_SET_ID
3294:
3295: FROM AR_VAT_TAX_ALL_B gvat,
3296: AR_TAX_GROUP_CODES_ALL taxgrp,
3297: ZX_TAXES_B TAXES,
3298: ZX_RULES_B rules,
3299: ZX_CONDITION_GROUPS_B cg,

Line 3319: FROM ar_vat_tax_all_b vat

3315: AND gvat.org_id = sys.org_id
3316: AND sys.org_id = ptp.party_id
3317: AND ptp.party_type_code = 'OU'
3318: /* AND EXISTS (SELECT 1
3319: FROM ar_vat_tax_all_b vat
3320: WHERE vat.tax_type = 'LOCATION'
3321: AND vat.set_of_books_id = sys.set_of_books_id
3322: AND vat.org_id = sys.org_id
3323: AND vat.enabled_flag = 'Y'

Line 3455: FROM AR_VAT_TAX_ALL_B gvat,

3451: taxgrp.TAX_EXCEPTION_ID EXCEPTION_SET_ID ,
3452: rates.tax_status_code STATUS_RESULT ,
3453: rates.tax_rate_code RATE_RESULT
3454:
3455: FROM AR_VAT_TAX_ALL_B gvat,
3456: AR_TAX_GROUP_CODES_ALL taxgrp,
3457: AR_VAT_TAX_ALL_B vat,
3458: -- ZX_TAXES_B TAXES,
3459: ZX_RULES_B rules,

Line 3457: AR_VAT_TAX_ALL_B vat,

3453: rates.tax_rate_code RATE_RESULT
3454:
3455: FROM AR_VAT_TAX_ALL_B gvat,
3456: AR_TAX_GROUP_CODES_ALL taxgrp,
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

Line 3511: FROM AR_VAT_TAX_ALL_B gvat,

3507: taxgrp.tax_exception_id EXCEPTION_SET_ID ,
3508: rates.tax_status_code STATUS_RESULT ,
3509: rates.tax_rate_code RATE_RESULT
3510:
3511: FROM AR_VAT_TAX_ALL_B gvat,
3512: AR_TAX_GROUP_CODES_ALL taxgrp,
3513: AR_VAT_TAX_ALL_B vat,
3514: ZX_TAXES_B TAXES,
3515: ZX_RULES_B rules,

Line 3513: AR_VAT_TAX_ALL_B vat,

3509: rates.tax_rate_code RATE_RESULT
3510:
3511: FROM AR_VAT_TAX_ALL_B gvat,
3512: AR_TAX_GROUP_CODES_ALL taxgrp,
3513: AR_VAT_TAX_ALL_B vat,
3514: ZX_TAXES_B TAXES,
3515: ZX_RULES_B rules,
3516: ZX_CONDITION_GROUPS_B cg,
3517: ar_system_parameters_all sys,