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_RULES_B

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

1593: | PROCEDURE |
1594: | create_rules |
1595: | |
1596: | DESCRIPTION |
1597: | This routine inserts data into ZX_RULES_B/_TL by following the same |
1598: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
1599: | |
1600: | SCOPE - PUBLIC |
1601: | |

Line 1639: INTO ZX_RULES_B_TMP

1635: and rates.record_type_code = 'MIGRATED'
1636: )
1637: )
1638: THEN
1639: INTO ZX_RULES_B_TMP
1640: (
1641: TAX_RULE_ID ,
1642: TAX_RULE_CODE ,
1643: TAX ,

Line 1669: zx_rules_b_s.nextval,--TAX_RULE_ID

1665: OBJECT_VERSION_NUMBER
1666: )
1667: VALUES
1668: (
1669: zx_rules_b_s.nextval,--TAX_RULE_ID
1670: L_TAX ,--TAX_RULE_CODE
1671: L_TAX ,--TAX
1672: L_TAX_REGIME_CODE ,--TAX_REGIME_CODE
1673: 'DET_DIRECT_RATE' ,--SERVICE_TYPE_CODE

Line 1708: from ZX_RULES_B_TMP rule

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
1707: AND NOT EXISTS ( select 1
1708: from ZX_RULES_B_TMP rule
1709: where
1710: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1711: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1712: and rule.TAX = taxes.TAX

Line 1722: INSERT ALL INTO ZX_RULES_B_TMP

1718: ) ;
1719: */
1720: --Bug : 5061471
1721: -- Create Direct Rate Rule for distinct tax_regime, tax and content_owner_id combination for both AP and AR
1722: INSERT ALL INTO ZX_RULES_B_TMP
1723: (
1724: TAX_RULE_ID ,
1725: TAX_RULE_CODE ,
1726: TAX ,

Line 1752: zx_rules_b_s.nextval,--TAX_RULE_ID

1748: OBJECT_VERSION_NUMBER
1749: )
1750: VALUES
1751: (
1752: zx_rules_b_s.nextval,--TAX_RULE_ID
1753: L_TAX ,--TAX_RULE_CODE
1754: L_TAX ,--TAX
1755: L_TAX_REGIME_CODE ,--TAX_REGIME_CODE
1756: 'DET_DIRECT_RATE' ,--SERVICE_TYPE_CODE

Line 1804: from ZX_RULES_B_TMP rule

1800: AND taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1801: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1802: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1803: AND NOT EXISTS ( select 1
1804: from ZX_RULES_B_TMP rule
1805: where
1806: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1807: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1808: and rule.TAX = taxes.TAX

Line 1845: from ZX_RULES_B_TMP rule

1841: and rates.tax_regime_code = taxes.TAX_REGIME_CODE
1842: AND rates.content_owner_id = taxes.content_owner_id
1843: and rates.record_type_code = 'MIGRATED' )
1844: AND NOT EXISTS ( select 1
1845: from ZX_RULES_B_TMP rule
1846: where
1847: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1848: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1849: and rule.TAX = taxes.TAX

Line 1864: INTO ZX_RULES_B_TMP

1860: --Create Applicability Rules For Location Based Taxes , Refer Bug 4910386
1861: --Refer Bug 4935978 for further modificatiions
1862:
1863: INSERT ALL
1864: INTO ZX_RULES_B_TMP
1865: (
1866: TAX_RULE_ID ,
1867: TAX_RULE_CODE ,
1868: TAX ,

Line 1894: zx_rules_b_s.nextval,--TAX_RULE_ID

1890: OBJECT_VERSION_NUMBER
1891: )
1892: VALUES
1893: (
1894: zx_rules_b_s.nextval,--TAX_RULE_ID
1895: TAX ,--TAX_RULE_CODE
1896: TAX ,--TAX
1897: TAX_REGIME_CODE ,--REGIME
1898: 'DET_DIRECT_RATE' , -- SERVICE_TYPE_CODE --Bug 5385949

Line 1955: from zx_rules_b

1951: AND vat.org_id = sys.org_id
1952: AND vat.enabled_flag = 'Y'
1953: )
1954: AND not exists (select 1
1955: from zx_rules_b
1956: where tax_rule_code = taxes.tax
1957: and effective_from = taxes.effective_from
1958: and content_owner_id = ptp.party_tax_profile_id
1959: and service_type_code = 'DET_DIRECT_RATE' --Bug 5385949

Line 2008: from zx_rules_b

2004: AND vat.vat_tax_id = taxgrp.tax_code_id
2005: )
2006: */
2007: AND not exists (select 1
2008: from zx_rules_b
2009: where tax_rule_code = taxes.tax
2010: and effective_from = taxgrp.START_DATE
2011: and content_owner_id = ptp.party_tax_profile_id
2012: and service_type_code = 'DET_DIRECT_RATE' --Bug 5385949

Line 2032: INSERT ALL INTO ZX_RULES_B_TMP

2028: -- Create Rate Determination Rule for location based taxes for OKL migration
2029: -- even though there can be VAT taxes with leasing flag as 'Y', but for these taxes
2030: -- no multiple rate will be defined, hence no need to create the rate det rules.
2031:
2032: INSERT ALL INTO ZX_RULES_B_TMP
2033: (
2034: TAX_RULE_ID ,
2035: TAX_RULE_CODE ,
2036: TAX ,

Line 2062: zx_rules_b_s.nextval,--TAX_RULE_ID

2058: OBJECT_VERSION_NUMBER
2059: )
2060: VALUES
2061: (
2062: zx_rules_b_s.nextval,--TAX_RULE_ID
2063: L_TAX ,--TAX_RULE_CODE
2064: L_TAX ,--TAX
2065: L_TAX_REGIME_CODE ,--TAX_REGIME_CODE
2066: l_service_type_code ,--SERVICE_TYPE_CODE

Line 2122: from ZX_RULES_B_TMP rule

2118: taxgrp.trx_business_category_code ||
2119: taxgrp.party_fisc_classification IS NOT NULL
2120: )
2121: AND NOT EXISTS ( select 1
2122: from ZX_RULES_B_TMP rule
2123: where
2124: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
2125: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
2126: and rule.TAX = taxes.TAX

Line 2180: from zx_rules_b

2176: taxgrp.trx_business_category_code ||
2177: taxgrp.party_fisc_classification IS NOT NULL
2178: )
2179: AND not exists (select 1
2180: from zx_rules_b
2181: where tax_rule_code = taxes.tax
2182: and effective_from = taxes.effective_from
2183: and content_owner_id = ptp.party_tax_profile_id
2184: and service_type_code = srvtype.service_type_code

Line 2221: ZX_RULES_B B

2217: fnd_global.user_id ,
2218: fnd_global.conc_login_id
2219: FROM
2220: FND_LANGUAGES L,
2221: ZX_RULES_B B
2222: WHERE
2223: L.INSTALLED_FLAG in ('I', 'B')
2224: AND RECORD_TYPE_CODE = 'MIGRATED'
2225: AND not exists

Line 2239: from zx_rules_b rule

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
2240: where rule.content_owner_id = tax.content_owner_id
2241: and rule.tax_regime_code = tax.tax_regime_code
2242: and rule.tax = tax.tax
2243: and rule.record_type_code = 'MIGRATED'

Line 2258: from zx_rules_b rule

2254: and tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
2255: and tax.content_owner_id = -99
2256: and exists
2257: ( select 1
2258: from zx_rules_b rule
2259: where rule.tax_regime_code = tax.tax_regime_code
2260: and rule.tax = tax.tax
2261: and rule.record_type_code = 'MIGRATED'
2262: and rule.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE'

Line 2275: from zx_rules_b rule

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
2276: where rule.content_owner_id = tax.content_owner_id
2277: and rule.tax_regime_code = tax.tax_regime_code
2278: and rule.tax = tax.tax
2279: and rule.record_type_code = 'MIGRATED'

Line 2293: from zx_rules_b rule

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
2294: where rule.content_owner_id = tax.content_owner_id
2295: and rule.tax_regime_code = tax.tax_regime_code
2296: and rule.tax = tax.tax
2297: and rule.record_type_code = 'MIGRATED'

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 2689: ZX_RULES_B rules,

2685: rules.TAX_RULE_ID TAX_RULE_ID
2686: FROM
2687: ZX_RATES_B rates,
2688: FND_LOOKUPS fnd,
2689: ZX_RULES_B rules,
2690: ZX_CONDITION_GROUPS_B cond_groups,
2691: AP_TAX_CODES_ALL codes
2692: WHERE
2693: rates.record_type_code = 'MIGRATED'

Line 2733: ZX_RULES_B rules,

2729: AR_TAX_GROUP_CODES_ALL GROUPS,
2730: AP_TAX_CODES_ALL GROUP_CODES,
2731: AP_TAX_CODES_ALL CODES,
2732: ZX_RATES_B rates,
2733: ZX_RULES_B rules,
2734: ZX_CONDITION_GROUPS_B cond_groups
2735: WHERE
2736: GROUP_CODES.TAX_ID = GROUPS.TAX_GROUP_ID
2737: AND GROUPS.TAX_GROUP_TYPE = 'AP'

Line 2855: ZX_RULES_B rules,

2851: NULL CONDITION_SET_ID ,
2852: NULL EXCEPTION_SET_ID
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

Line 2912: ZX_RULES_B rules,

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,
2913: ZX_CONDITION_GROUPS_B cond_groups
2914: WHERE
2915: gvat.vat_tax_id = gc.tax_group_id
2916: AND gc.tax_group_type = 'AR'

Line 3047: ZX_RULES_B RULES,

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

Line 3098: ZX_RULES_B rules,

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
3102: WHERE

Line 3242: ZX_RULES_B rules,

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'
3246: AND gvat.tax_type = 'TAX_GROUP'

Line 3298: ZX_RULES_B rules,

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
3302:

Line 3459: ZX_RULES_B rules,

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
3463: AND taxgrp.tax_group_type = 'AR'

Line 3515: ZX_RULES_B rules,

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,
3519: ZX_RATES_B oklrates,