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_DEF_COMMON dependencies on ZX_REGIMES_B

Line 1376: | 1. Populates data into zx_regimes_b table based on data in

Line 1378: | 2. Populates data into zx_regimes_b for Brazilian IPI

1374: |
1375: | DESCRIPTION
1376: | 1. Populates data into zx_regimes_b table based on data in
1377: | zx_update_criteria_results table for normal tax codes.
1378: | 2. Populates data into zx_regimes_b for Brazilian IPI
1379: | 3. Populates data into zx_regimes_b for Brazilian ISS
1380: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1381: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1382: | 6. Populates data into zx_regimes_tl

Line 1379: | 3. Populates data into zx_regimes_b for Brazilian ISS

1375: | DESCRIPTION
1376: | 1. Populates data into zx_regimes_b table based on data in
1377: | zx_update_criteria_results table for normal tax codes.
1378: | 2. Populates data into zx_regimes_b for Brazilian IPI
1379: | 3. Populates data into zx_regimes_b for Brazilian ISS
1380: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1381: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1382: | 6. Populates data into zx_regimes_tl
1383: |

Line 1380: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes

1376: | 1. Populates data into zx_regimes_b table based on data in
1377: | zx_update_criteria_results table for normal tax codes.
1378: | 2. Populates data into zx_regimes_b for Brazilian IPI
1379: | 3. Populates data into zx_regimes_b for Brazilian ISS
1380: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1381: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1382: | 6. Populates data into zx_regimes_tl
1383: |
1384: |

Line 1381: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes

Line 1419: l_tax_regime_code VARCHAR2(30); --zx_regimes_b.tax_regime_code%TYPE

1415: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE
1416: l_temp_allow_rounding_override VARCHAR2(30); --ar_system_parameters_all.tax_rounding_allow_override%TYPE
1417: l_temp_org_id NUMBER(15); --ar_system_parameters_all.org_id%TYPE
1418: l_tax_regime_name VARCHAR2(80); --zx_regimes_tl.tax_regime_name%TYPE
1419: l_tax_regime_code VARCHAR2(30); --zx_regimes_b.tax_regime_code%TYPE
1420:
1421:
1422: -- ****** CURSORS ******
1423: CURSOR loc_str_cur IS

Line 1466: | Populating zx_regimes_b from zx_update_criteria_results

1462:
1463: BEGIN
1464: /*--------------------------------------------------------------------------
1465: |
1466: | Populating zx_regimes_b from zx_update_criteria_results
1467: |
1468: +---------------------------------------------------------------------------*/
1469:
1470: INSERT INTO ZX_REGIMES_B

Line 1470: INSERT INTO ZX_REGIMES_B

1466: | Populating zx_regimes_b from zx_update_criteria_results
1467: |
1468: +---------------------------------------------------------------------------*/
1469:
1470: INSERT INTO ZX_REGIMES_B
1471: (
1472: TAX_REGIME_CODE ,
1473: PARENT_REGIME_CODE ,
1474: REGIME_PRECEDENCE ,

Line 1610: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1606: 'SHIP_FROM_PARTY' ,--DEF_REGISTR_PARTY_TYPE_CODE
1607: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1608: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1609: DECODE(L_REGIME_PRECEDENCE,NULL,'N','Y') ,--CROSS_REGIME_COMPOUNDING_FLAG
1610: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1611: NULL ,--GEOGRAPHY_ID
1612: NULL ,--THRSHLD_CHK_TMPLT_CODE
1613: NULL ,--PERIOD_SET_NAME
1614: NULL ,--REP_TAX_AUTHORITY_ID

Line 1634: FROM zx_regimes_b zrb

1630: zucr.country_code l_country_code,
1631: zucr.regime_precedence l_regime_precedence
1632: FROM zx_update_criteria_results zucr
1633: WHERE NOT EXISTS (SELECT 1
1634: FROM zx_regimes_b zrb
1635: WHERE zrb.tax_regime_code = zucr.tax_regime_code
1636: )
1637:
1638: );

Line 1651: ZX_REGIMES_B

1647: | two to avoid dynamic sql call to fetch sequence.
1648: |
1649: +-------------------------------------------------------------------------------------*/
1650: INSERT INTO
1651: ZX_REGIMES_B
1652: (
1653: TAX_REGIME_CODE ,
1654: PARENT_REGIME_CODE ,
1655: HAS_SUB_REGIME_FLAG ,

Line 1791: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1787: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1788: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1789: NULL ,--REGIME_PRECEDENCE
1790: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
1791: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1792: NULL ,--GEOGRAPHY_ID
1793: NULL ,--THRSHLD_CHK_TMPLT_CODE
1794: NULL ,--PERIOD_SET_NAME
1795: NULL ,--REP_TAX_AUTHORITY_ID

Line 1807: FROM zx_regimes_b

1803: fnd_global.prog_appl_id ,--Program Application ID
1804: fnd_global.conc_program_id ,--Program Id
1805: fnd_global.conc_login_id ,--Program Login ID
1806: 1
1807: FROM zx_regimes_b
1808: WHERE tax_regime_code = 'BR-ICMS'
1809: AND country_code = 'BR'
1810: AND NOT EXISTS (SELECT 1
1811: FROM zx_regimes_b

Line 1811: FROM zx_regimes_b

1807: FROM zx_regimes_b
1808: WHERE tax_regime_code = 'BR-ICMS'
1809: AND country_code = 'BR'
1810: AND NOT EXISTS (SELECT 1
1811: FROM zx_regimes_b
1812: WHERE tax_regime_code = 'BR-IPI');
1813:
1814: /*--------------------------------------------------------------------------
1815: |

Line 1823: ZX_REGIMES_B

1819: | two to avoid dynamic sql call to fetch sequence.
1820: |
1821: +---------------------------------------------------------------------------*/
1822: INSERT INTO
1823: ZX_REGIMES_B
1824: (
1825: TAX_REGIME_CODE ,
1826: PARENT_REGIME_CODE ,
1827: HAS_SUB_REGIME_FLAG ,

Line 1963: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1959: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1960: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1961: NULL ,--REGIME_PRECEDENCE
1962: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
1963: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1964: NULL ,--GEOGRAPHY_ID
1965: NULL ,--THRSHLD_CHK_TMPLT_CODE
1966: NULL ,--PERIOD_SET_NAME
1967: NULL ,--REP_TAX_AUTHORITY_ID

Line 1979: FROM zx_regimes_b

1975: fnd_global.prog_appl_id ,--Program Application ID
1976: fnd_global.conc_program_id ,--Program Id
1977: fnd_global.conc_login_id ,--Program Login ID
1978: 1
1979: FROM zx_regimes_b
1980: WHERE tax_regime_code = 'BR-IPI'
1981: AND country_code = 'BR'
1982: AND NOT EXISTS (SELECT 1
1983: FROM zx_regimes_b

Line 1983: FROM zx_regimes_b

1979: FROM zx_regimes_b
1980: WHERE tax_regime_code = 'BR-IPI'
1981: AND country_code = 'BR'
1982: AND NOT EXISTS (SELECT 1
1983: FROM zx_regimes_b
1984: WHERE tax_regime_code = 'BR-ISS');
1985:
1986: END IF;
1987:

Line 2146: -- Insert into zx_regimes_b/tl

2142:
2143:
2144:
2145:
2146: -- ****** Insert into zx_regimes_b/tl ******
2147: FOR k in 1..denorm_tbl.count LOOP
2148: if denorm_tbl(k).country_code is not null
2149: then
2150: l_tax_regime_name := denorm_tbl(k).country_code || '-SALES-TAX' ||

Line 2166: FROM ZX_REGIMES_B

2162: l_tax_regime_code := denorm_tbl(k).country_code || '-SALES-TAX-' || denorm_tbl(k).id_flex_num;
2163:
2164: INSERT ALL
2165: WHEN (NOT EXISTS (SELECT 1
2166: FROM ZX_REGIMES_B
2167: WHERE TAX_REGIME_CODE = l_tax_regime_code
2168: )
2169: ) THEN
2170: INTO ZX_REGIMES_B

Line 2170: INTO ZX_REGIMES_B

2166: FROM ZX_REGIMES_B
2167: WHERE TAX_REGIME_CODE = l_tax_regime_code
2168: )
2169: ) THEN
2170: INTO ZX_REGIMES_B
2171: (
2172: TAX_REGIME_CODE ,
2173: PARENT_REGIME_CODE ,
2174: HAS_SUB_REGIME_FLAG ,

Line 2311: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

2307: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
2308: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG /** Set it to Y. Need P2P Change. **/
2309: NULL ,--REGIME_PRECEDENCE /** Can be updated for compounding migration **/
2310: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
2311: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
2312: NULL ,--GEOGRAPHY_ID
2313: NULL ,--THRSHLD_CHK_TMPLT_CODE
2314: NULL ,--PERIOD_SET_NAME
2315: NULL ,--REP_TAX_AUTHORITY_ID

Line 2329: FROM ZX_REGIMES_B

2325: fnd_global.conc_login_id ,--Program Login ID
2326: 1
2327: )
2328: WHEN (NOT EXISTS (SELECT 1
2329: FROM ZX_REGIMES_B
2330: WHERE TAX_REGIME_CODE = l_tax_regime_code
2331: )
2332: ) THEN
2333: -- Need to insert _TL table for current language as l_tax_regime_name is

Line 2362: ZX_REGIMES_B_S.NEXTVAL

2358: fnd_global.user_id ,
2359: SYSDATE ,
2360: fnd_global.user_id ,
2361: fnd_global.conc_login_id ,
2362: ZX_REGIMES_B_S.NEXTVAL
2363: )
2364: SELECT 1 FROM DUAL;
2365: END IF;
2366: END LOOP;

Line 2380: INTO zx_regimes_b

2376: |
2377: +--------------------------------------------------------------------------*/
2378: /*
2379: INSERT ALL
2380: INTO zx_regimes_b
2381: (
2382: TAX_REGIME_CODE ,
2383: PARENT_REGIME_CODE ,
2384: HAS_SUB_REGIME_FLAG ,

Line 2521: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

2517: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
2518: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
2519: NULL ,--REGIME_PRECEDENCE
2520: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
2521: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
2522: NULL ,--GEOGRAPHY_ID
2523: NULL ,--THRSHLD_CHK_TMPLT_CODE
2524: NULL ,--PERIOD_SET_NAME
2525: NULL ,--REP_TAX_AUTHORITY_ID

Line 2549: FROM zx_regimes_b

2545: FROM ar_system_parameters_all asp
2546: WHERE asp.tax_database_view_set IN ('_A', '_V')
2547: AND asp.default_country = 'US'
2548: AND NOT EXISTS (SELECT 1
2549: FROM zx_regimes_b
2550: WHERE tax_regime_code IN ('US-SALES-TAX-TAXWARE', 'US-SALES-TAX-VERTEX')
2551: );
2552: */
2553:

Line 2614: ZX_REGIMES_B B,

2610: fnd_global.conc_login_id ,
2611: B.TAX_REGIME_ID
2612: FROM
2613: FND_LANGUAGES L,
2614: ZX_REGIMES_B B,
2615: (select rates.tax_regime_code tax_regime_code,
2616: lkups.meaning meaning,
2617: params.global_attribute_category global_attribute_category
2618: from zx_rates_b rates,

Line 2694: ZX_REGIMES_B B,

2690: fnd_global.conc_login_id ,
2691: B.TAX_REGIME_ID
2692: FROM
2693: FND_LANGUAGES L,
2694: ZX_REGIMES_B B,
2695: (select rates.tax_regime_code tax_regime_code,
2696: lkups.meaning meaning,
2697: params.global_attribute_category global_attribute_category
2698: from zx_rates_b rates,