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_TAXES_B

Line 1702: ZX_TAXES_B taxes

1698: taxes.EFFECTIVE_FROM EFFECTIVE_FROM ,
1699: taxes.EFFECTIVE_TO EFFECTIVE_TO ,
1700: taxes.CONTENT_OWNER_ID
1701: FROM
1702: ZX_TAXES_B taxes
1703: WHERE
1704: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1705: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1706: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074

Line 1787: ZX_TAXES_B taxes ,

1783: taxgrp.END_DATE EFFECTIVE_TO ,
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'

Line 1828: ZX_TAXES_B taxes

1824: taxes.CONTENT_OWNER_ID ,
1825: 1 PRIORITY
1826:
1827: FROM
1828: ZX_TAXES_B taxes
1829: WHERE
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

Line 1930: ZX_TAXES_B taxes,

1926: -- nvl(vat.enabled_flag,'Y') ENABLED_FLAG
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

Line 1976: ZX_TAXES_B taxes,

1972: -- nvl(vat.enabled_flag,'Y') ENABLED_FLAG
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

Line 2096: ZX_TAXES_B taxes,

2092: taxes.EFFECTIVE_TO EFFECTIVE_TO ,
2093: taxes.CONTENT_OWNER_ID ,
2094: srvtype.service_type_code l_service_type_code
2095: FROM
2096: ZX_TAXES_B taxes,
2097: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2098: FROM DUAL
2099: UNION
2100: SELECT 'DET_TAX_RATE' service_type_code

Line 2142: ZX_TAXES_B taxes,

2138: taxes.EFFECTIVE_TO EFFECTIVE_TO ,
2139: taxes.CONTENT_OWNER_ID,
2140: srvtype.service_type_code l_service_type_code
2141: FROM
2142: ZX_TAXES_B taxes,
2143: zx_party_tax_profile ptp,
2144: ar_system_parameters_all sys,
2145: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2146: FROM DUAL

Line 2235: update zx_taxes_b_tmp tax

2231:
2232: --Bug : 5090631 : Added to update the DIRECT_RATE_RULE_FLAG to 'Y' for all tax,regime,contentOwners for which
2233: -- direct rate rules have been created.
2234:
2235: update zx_taxes_b_tmp tax
2236: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2237: where exists
2238: ( select 1
2239: from zx_rules_b rule

Line 2250: update zx_taxes_b_tmp tax

2246: and rule.tax_rule_code = tax.tax );
2247: -- and rule.priority = 1);
2248:
2249: -- bug fix: 5548613 update the DIRECT_RATE_RULE_FLAG to 'Y' for location based taxes which have the direct rate rule migrated
2250: update zx_taxes_b_tmp tax
2251: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2252: where tax.tax_type_code = 'LOCATION'
2253: and tax.RECORD_TYPE_CODE = 'MIGRATED'
2254: and tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i

Line 2271: update zx_taxes_b_tmp tax

2267:
2268: -- Added to update the TAX_RATE_RULE_FLAG to 'Y' for all tax,regime,contentOwners for which
2269: -- direct rate rules have been created.
2270:
2271: update zx_taxes_b_tmp tax
2272: set tax.TAX_RATE_RULE_FLAG = 'Y'
2273: where exists
2274: ( select 1
2275: from zx_rules_b rule

Line 2289: update zx_taxes_b_tmp tax

2285: --
2286: -- Added to update the APPLICABILITY_RULE to 'Y' for all tax,regime,contentOwners for which
2287: -- applicability rules have been created.
2288:
2289: update zx_taxes_b_tmp tax
2290: set tax.APPLICABILITY_RULE_FLAG = 'Y'
2291: where exists
2292: ( select 1
2293: from zx_rules_b rule

Line 2306: INSERT INTO ZX_TAXES_B (

2302:
2303: -- bug fix: 5548613: copy the location based taxes
2304: -- which has an applicability rule defined.
2305:
2306: INSERT INTO ZX_TAXES_B (
2307: TAX
2308: ,EFFECTIVE_FROM
2309: ,EFFECTIVE_TO
2310: ,TAX_REGIME_CODE

Line 2519: ,ZX_TAXES_B_S.NEXTVAL

2515: ,tax.ALLOW_DUP_REGN_NUM_FLAG
2516: ,tax.DEF_SECONDARY_REC_RATE_CODE
2517: ,tax.SPECIAL_INCLUSIVE_TAX_FLAG
2518: ,tax.PROGRAM_LOGIN_ID
2519: ,ZX_TAXES_B_S.NEXTVAL
2520: ,rule.CONTENT_OWNER_ID
2521: ,tax.REP_TAX_AUTHORITY_ID
2522: ,tax.COLL_TAX_AUTHORITY_ID
2523: ,tax.THRSHLD_CHK_TMPLT_CODE

Line 2533: FROM ZX_TAXES_B tax, zx_rules_b rule

2529: ,tax.TAX_EXMPT_CR_METHOD_CODE
2530: ,tax.TAX_EXMPT_SOURCE_TAX
2531: ,tax.APPLICABLE_BY_DEFAULT_FLAG
2532: ,tax.LEGAL_REPORTING_STATUS_DEF_VAL
2533: FROM ZX_TAXES_B tax, zx_rules_b rule
2534: WHERE tax.tax_type_code ='LOCATION'
2535: AND tax.RECORD_TYPE_CODE = 'MIGRATED'
2536: AND tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
2537: AND tax.content_owner_id = -99

Line 2547: FROM zx_taxes_b tax2

2543: AND rule.tax_rule_code = tax.tax
2544: AND rule.priority = 1
2545: AND NOT EXISTS (
2546: SELECT 1
2547: FROM zx_taxes_b tax2
2548: WHERE tax2.tax = tax.tax
2549: AND tax2.tax_regime_code = tax.tax_regime_code
2550: AND tax2.content_owner_id = tax.content_owner_id);
2551:

Line 3043: FROM ZX_TAXES_B TAXES,

3039: rules.tax_rule_id TAX_RULE_ID ,
3040: NULL CONDITION_SET_ID ,
3041: NULL EXCEPTION_SET_ID ,
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,

Line 3097: ZX_TAXES_B TAXES,

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,
3099: ZX_CONDITION_GROUPS_B cond_groups,
3100: ZX_PARTY_TAX_PROFILE PTP,
3101: ar_system_parameters_all sys

Line 3241: ZX_TAXES_B TAXES,

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
3244: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3245: AND taxgrp.tax_group_type = 'AR'

Line 3297: ZX_TAXES_B TAXES,

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,
3300: ar_system_parameters_all sys,
3301: zx_party_tax_profile ptp

Line 3458: -- ZX_TAXES_B TAXES,

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

Line 3514: ZX_TAXES_B TAXES,

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,
3518: zx_party_tax_profile ptp,