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.

[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_RULES_B

Line 1441: | This routine inserts data into ZX_RULES_B/_TL by following the same |

1437: | PROCEDURE |
1438: | create_rules |
1439: | |
1440: | DESCRIPTION |
1441: | This routine inserts data into ZX_RULES_B/_TL by following the same |
1442: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
1443: | |
1444: | SCOPE - PUBLIC |
1445: | |

Line 1483: INTO ZX_RULES_B_TMP

1479: and rates.record_type_code = 'MIGRATED'
1480: )
1481: )
1482: THEN
1483: INTO ZX_RULES_B_TMP
1484: (
1485: TAX_RULE_ID ,
1486: TAX_RULE_CODE ,
1487: TAX ,

Line 1513: zx_rules_b_s.nextval,--TAX_RULE_ID

1509: OBJECT_VERSION_NUMBER
1510: )
1511: VALUES
1512: (
1513: zx_rules_b_s.nextval,--TAX_RULE_ID
1514: L_TAX ,--TAX_RULE_CODE
1515: L_TAX ,--TAX
1516: L_TAX_REGIME_CODE ,--TAX_REGIME_CODE
1517: 'DET_DIRECT_RATE' ,--SERVICE_TYPE_CODE

Line 1552: from ZX_RULES_B_TMP rule

1548: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1549: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1550: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1551: AND NOT EXISTS ( select 1
1552: from ZX_RULES_B_TMP rule
1553: where
1554: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1555: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1556: and rule.TAX = taxes.TAX

Line 1566: INSERT ALL INTO ZX_RULES_B_TMP

1562: ) ;
1563: */
1564: --Bug : 5061471
1565: -- Create Direct Rate Rule for distinct tax_regime, tax and content_owner_id combination for both AP and AR
1566: INSERT ALL INTO ZX_RULES_B_TMP
1567: (
1568: TAX_RULE_ID ,
1569: TAX_RULE_CODE ,
1570: TAX ,

Line 1596: zx_rules_b_s.nextval,--TAX_RULE_ID

1592: OBJECT_VERSION_NUMBER
1593: )
1594: VALUES
1595: (
1596: zx_rules_b_s.nextval,--TAX_RULE_ID
1597: L_TAX ,--TAX_RULE_CODE
1598: L_TAX ,--TAX
1599: L_TAX_REGIME_CODE ,--TAX_REGIME_CODE
1600: 'DET_DIRECT_RATE' ,--SERVICE_TYPE_CODE

Line 1648: from ZX_RULES_B_TMP rule

1644: AND taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1645: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1646: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1647: AND NOT EXISTS ( select 1
1648: from ZX_RULES_B_TMP rule
1649: where
1650: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1651: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1652: and rule.TAX = taxes.TAX

Line 1686: from ZX_RULES_B_TMP rule

1682: and rates.tax_regime_code = taxes.TAX_REGIME_CODE
1683: AND rates.content_owner_id = taxes.content_owner_id
1684: and rates.record_type_code = 'MIGRATED' )
1685: AND NOT EXISTS ( select 1
1686: from ZX_RULES_B_TMP rule
1687: where
1688: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1689: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1690: and rule.TAX = taxes.TAX

Line 1703: INTO ZX_RULES_B_TMP

1699: --Create Applicability Rules For Location Based Taxes , Refer Bug 4910386
1700: --Refer Bug 4935978 for further modificatiions
1701:
1702: INSERT ALL
1703: INTO ZX_RULES_B_TMP
1704: (
1705: TAX_RULE_ID ,
1706: TAX_RULE_CODE ,
1707: TAX ,

Line 1733: zx_rules_b_s.nextval,--TAX_RULE_ID

1729: OBJECT_VERSION_NUMBER
1730: )
1731: VALUES
1732: (
1733: zx_rules_b_s.nextval,--TAX_RULE_ID
1734: TAX ,--TAX_RULE_CODE
1735: TAX ,--TAX
1736: TAX_REGIME_CODE ,--REGIME
1737: 'DET_DIRECT_RATE' , -- SERVICE_TYPE_CODE --Bug 5385949

Line 1794: from zx_rules_b

1790: AND vat.org_id = sys.org_id
1791: AND vat.enabled_flag = 'Y'
1792: )
1793: AND not exists (select 1
1794: from zx_rules_b
1795: where tax_rule_code = taxes.tax
1796: and effective_from = taxes.effective_from
1797: and content_owner_id = ptp.party_tax_profile_id
1798: and service_type_code = 'DET_DIRECT_RATE' --Bug 5385949

Line 1847: from zx_rules_b

1843: AND vat.vat_tax_id = taxgrp.tax_code_id
1844: )
1845: */
1846: AND not exists (select 1
1847: from zx_rules_b
1848: where tax_rule_code = taxes.tax
1849: and effective_from = taxes.effective_from
1850: and content_owner_id = ptp.party_tax_profile_id
1851: and service_type_code = 'DET_DIRECT_RATE' --Bug 5385949

Line 1866: INSERT ALL INTO ZX_RULES_B_TMP

1862: -- Create Rate Determination Rule for location based taxes for OKL migration
1863: -- even though there can be VAT taxes with leasing flag as 'Y', but for these taxes
1864: -- no multiple rate will be defined, hence no need to create the rate det rules.
1865:
1866: INSERT ALL INTO ZX_RULES_B_TMP
1867: (
1868: TAX_RULE_ID ,
1869: TAX_RULE_CODE ,
1870: TAX ,

Line 1896: zx_rules_b_s.nextval,--TAX_RULE_ID

1892: OBJECT_VERSION_NUMBER
1893: )
1894: VALUES
1895: (
1896: zx_rules_b_s.nextval,--TAX_RULE_ID
1897: L_TAX ,--TAX_RULE_CODE
1898: L_TAX ,--TAX
1899: L_TAX_REGIME_CODE ,--TAX_REGIME_CODE
1900: l_service_type_code ,--SERVICE_TYPE_CODE

Line 1956: from ZX_RULES_B_TMP rule

1952: taxgrp.trx_business_category_code ||
1953: taxgrp.party_fisc_classification IS NOT NULL
1954: )
1955: AND NOT EXISTS ( select 1
1956: from ZX_RULES_B_TMP rule
1957: where
1958: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1959: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1960: and rule.TAX = taxes.TAX

Line 2014: from zx_rules_b

2010: taxgrp.trx_business_category_code ||
2011: taxgrp.party_fisc_classification IS NOT NULL
2012: )
2013: AND not exists (select 1
2014: from zx_rules_b
2015: where tax_rule_code = taxes.tax
2016: and effective_from = taxes.effective_from
2017: and content_owner_id = ptp.party_tax_profile_id
2018: and service_type_code = srvtype.service_type_code

Line 2055: ZX_RULES_B B

2051: fnd_global.user_id ,
2052: fnd_global.conc_login_id
2053: FROM
2054: FND_LANGUAGES L,
2055: ZX_RULES_B B
2056: WHERE
2057: L.INSTALLED_FLAG in ('I', 'B')
2058: AND RECORD_TYPE_CODE = 'MIGRATED'
2059: AND not exists

Line 2073: from zx_rules_b rule

2069: update zx_taxes_b_tmp tax
2070: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2071: where exists
2072: ( select 1
2073: from zx_rules_b rule
2074: where rule.content_owner_id = tax.content_owner_id
2075: and rule.tax_regime_code = tax.tax_regime_code
2076: and rule.tax = tax.tax
2077: and rule.record_type_code = 'MIGRATED'

Line 2092: from zx_rules_b rule

2088: and tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
2089: and tax.content_owner_id = -99
2090: and exists
2091: ( select 1
2092: from zx_rules_b rule
2093: where rule.tax_regime_code = tax.tax_regime_code
2094: and rule.tax = tax.tax
2095: and rule.record_type_code = 'MIGRATED'
2096: and rule.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE'

Line 2109: from zx_rules_b rule

2105: update zx_taxes_b_tmp tax
2106: set tax.TAX_RATE_RULE_FLAG = 'Y'
2107: where exists
2108: ( select 1
2109: from zx_rules_b rule
2110: where rule.content_owner_id = tax.content_owner_id
2111: and rule.tax_regime_code = tax.tax_regime_code
2112: and rule.tax = tax.tax
2113: and rule.record_type_code = 'MIGRATED'

Line 2127: from zx_rules_b rule

2123: update zx_taxes_b_tmp tax
2124: set tax.APPLICABILITY_RULE_FLAG = 'Y'
2125: where exists
2126: ( select 1
2127: from zx_rules_b rule
2128: where rule.content_owner_id = tax.content_owner_id
2129: and rule.tax_regime_code = tax.tax_regime_code
2130: and rule.tax = tax.tax
2131: and rule.record_type_code = 'MIGRATED'

Line 2367: FROM ZX_TAXES_B tax, zx_rules_b rule

2363: ,tax.TAX_EXMPT_CR_METHOD_CODE
2364: ,tax.TAX_EXMPT_SOURCE_TAX
2365: ,tax.APPLICABLE_BY_DEFAULT_FLAG
2366: ,tax.LEGAL_REPORTING_STATUS_DEF_VAL
2367: FROM ZX_TAXES_B tax, zx_rules_b rule
2368: WHERE tax.tax_type_code ='LOCATION'
2369: AND tax.RECORD_TYPE_CODE = 'MIGRATED'
2370: AND tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
2371: AND tax.content_owner_id = -99

Line 2523: ZX_RULES_B rules,

2519: rules.TAX_RULE_ID TAX_RULE_ID
2520: FROM
2521: ZX_RATES_B rates,
2522: FND_LOOKUPS fnd,
2523: ZX_RULES_B rules,
2524: ZX_CONDITION_GROUPS_B cond_groups,
2525: AP_TAX_CODES_ALL codes
2526: WHERE
2527: rates.record_type_code = 'MIGRATED'

Line 2566: ZX_RULES_B rules,

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,
2567: ZX_CONDITION_GROUPS_B cond_groups
2568: WHERE
2569: GROUP_CODES.TAX_ID = GROUPS.TAX_GROUP_ID
2570: AND GROUPS.TAX_GROUP_TYPE = 'AP'

Line 2688: ZX_RULES_B rules,

2684: NULL CONDITION_SET_ID ,
2685: NULL EXCEPTION_SET_ID
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

Line 2744: ZX_RULES_B rules,

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,
2745: ZX_CONDITION_GROUPS_B cond_groups
2746: WHERE
2747: gvat.vat_tax_id = gc.tax_group_id
2748: AND gc.tax_group_type = 'AR'

Line 2872: ZX_RULES_B RULES,

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'
2876: AND taxes.tax_type_code = 'LOCATION'

Line 2922: ZX_RULES_B rules,

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,
2923: ZX_CONDITION_GROUPS_B cond_groups,
2924: ZX_PARTY_TAX_PROFILE PTP,
2925: ar_system_parameters_all sys
2926: WHERE

Line 3059: ZX_RULES_B rules,

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
3062: AND taxgrp.tax_group_type = 'AR'
3063: AND gvat.tax_type = 'TAX_GROUP'

Line 3115: ZX_RULES_B rules,

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

Line 3276: ZX_RULES_B rules,

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

Line 3332: ZX_RULES_B rules,

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,
3335: zx_party_tax_profile ptp,
3336: ZX_RATES_B oklrates,