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 1299: | 1. Populates data into zx_regimes_b table based on data in

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

1297: |
1298: | DESCRIPTION
1299: | 1. Populates data into zx_regimes_b table based on data in
1300: | zx_update_criteria_results table for normal tax codes.
1301: | 2. Populates data into zx_regimes_b for Brazilian IPI
1302: | 3. Populates data into zx_regimes_b for Brazilian ISS
1303: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1304: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1305: | 6. Populates data into zx_regimes_tl

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

1298: | DESCRIPTION
1299: | 1. Populates data into zx_regimes_b table based on data in
1300: | zx_update_criteria_results table for normal tax codes.
1301: | 2. Populates data into zx_regimes_b for Brazilian IPI
1302: | 3. Populates data into zx_regimes_b for Brazilian ISS
1303: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1304: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1305: | 6. Populates data into zx_regimes_tl
1306: |

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

1299: | 1. Populates data into zx_regimes_b table based on data in
1300: | zx_update_criteria_results table for normal tax codes.
1301: | 2. Populates data into zx_regimes_b for Brazilian IPI
1302: | 3. Populates data into zx_regimes_b for Brazilian ISS
1303: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1304: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1305: | 6. Populates data into zx_regimes_tl
1306: |
1307: |

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

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

1338: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE
1339: l_temp_allow_rounding_override VARCHAR2(30); --ar_system_parameters_all.tax_rounding_allow_override%TYPE
1340: l_temp_org_id NUMBER(15); --ar_system_parameters_all.org_id%TYPE
1341: l_tax_regime_name VARCHAR2(80); --zx_regimes_tl.tax_regime_name%TYPE
1342: l_tax_regime_code VARCHAR2(30); --zx_regimes_b.tax_regime_code%TYPE
1343:
1344:
1345: -- ****** CURSORS ******
1346: CURSOR loc_str_cur IS

Line 1389: | Populating zx_regimes_b from zx_update_criteria_results

1385:
1386: BEGIN
1387: /*--------------------------------------------------------------------------
1388: |
1389: | Populating zx_regimes_b from zx_update_criteria_results
1390: |
1391: +---------------------------------------------------------------------------*/
1392:
1393: INSERT INTO ZX_REGIMES_B

Line 1393: INSERT INTO ZX_REGIMES_B

1389: | Populating zx_regimes_b from zx_update_criteria_results
1390: |
1391: +---------------------------------------------------------------------------*/
1392:
1393: INSERT INTO ZX_REGIMES_B
1394: (
1395: TAX_REGIME_CODE ,
1396: PARENT_REGIME_CODE ,
1397: REGIME_PRECEDENCE ,

Line 1533: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1529: 'SHIP_FROM_PARTY' ,--DEF_REGISTR_PARTY_TYPE_CODE
1530: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1531: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1532: DECODE(L_REGIME_PRECEDENCE,NULL,'N','Y') ,--CROSS_REGIME_COMPOUNDING_FLAG
1533: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1534: NULL ,--GEOGRAPHY_ID
1535: NULL ,--THRSHLD_CHK_TMPLT_CODE
1536: NULL ,--PERIOD_SET_NAME
1537: NULL ,--REP_TAX_AUTHORITY_ID

Line 1557: FROM zx_regimes_b zrb

1553: zucr.country_code l_country_code,
1554: zucr.regime_precedence l_regime_precedence
1555: FROM zx_update_criteria_results zucr
1556: WHERE NOT EXISTS (SELECT 1
1557: FROM zx_regimes_b zrb
1558: WHERE zrb.tax_regime_code = zucr.tax_regime_code
1559: )
1560:
1561: );

Line 1574: ZX_REGIMES_B

1570: | two to avoid dynamic sql call to fetch sequence.
1571: |
1572: +-------------------------------------------------------------------------------------*/
1573: INSERT INTO
1574: ZX_REGIMES_B
1575: (
1576: TAX_REGIME_CODE ,
1577: PARENT_REGIME_CODE ,
1578: HAS_SUB_REGIME_FLAG ,

Line 1714: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1710: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1711: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1712: NULL ,--REGIME_PRECEDENCE
1713: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
1714: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1715: NULL ,--GEOGRAPHY_ID
1716: NULL ,--THRSHLD_CHK_TMPLT_CODE
1717: NULL ,--PERIOD_SET_NAME
1718: NULL ,--REP_TAX_AUTHORITY_ID

Line 1730: FROM zx_regimes_b

1726: fnd_global.prog_appl_id ,--Program Application ID
1727: fnd_global.conc_program_id ,--Program Id
1728: fnd_global.conc_login_id ,--Program Login ID
1729: 1
1730: FROM zx_regimes_b
1731: WHERE tax_regime_code = 'BR-ICMS'
1732: AND country_code = 'BR'
1733: AND NOT EXISTS (SELECT 1
1734: FROM zx_regimes_b

Line 1734: FROM zx_regimes_b

1730: FROM zx_regimes_b
1731: WHERE tax_regime_code = 'BR-ICMS'
1732: AND country_code = 'BR'
1733: AND NOT EXISTS (SELECT 1
1734: FROM zx_regimes_b
1735: WHERE tax_regime_code = 'BR-IPI');
1736:
1737: /*--------------------------------------------------------------------------
1738: |

Line 1746: ZX_REGIMES_B

1742: | two to avoid dynamic sql call to fetch sequence.
1743: |
1744: +---------------------------------------------------------------------------*/
1745: INSERT INTO
1746: ZX_REGIMES_B
1747: (
1748: TAX_REGIME_CODE ,
1749: PARENT_REGIME_CODE ,
1750: HAS_SUB_REGIME_FLAG ,

Line 1886: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1882: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1883: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1884: NULL ,--REGIME_PRECEDENCE
1885: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
1886: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1887: NULL ,--GEOGRAPHY_ID
1888: NULL ,--THRSHLD_CHK_TMPLT_CODE
1889: NULL ,--PERIOD_SET_NAME
1890: NULL ,--REP_TAX_AUTHORITY_ID

Line 1902: FROM zx_regimes_b

1898: fnd_global.prog_appl_id ,--Program Application ID
1899: fnd_global.conc_program_id ,--Program Id
1900: fnd_global.conc_login_id ,--Program Login ID
1901: 1
1902: FROM zx_regimes_b
1903: WHERE tax_regime_code = 'BR-IPI'
1904: AND country_code = 'BR'
1905: AND NOT EXISTS (SELECT 1
1906: FROM zx_regimes_b

Line 1906: FROM zx_regimes_b

1902: FROM zx_regimes_b
1903: WHERE tax_regime_code = 'BR-IPI'
1904: AND country_code = 'BR'
1905: AND NOT EXISTS (SELECT 1
1906: FROM zx_regimes_b
1907: WHERE tax_regime_code = 'BR-ISS');
1908:
1909: END IF;
1910:

Line 2069: -- Insert into zx_regimes_b/tl

2065:
2066:
2067:
2068:
2069: -- ****** Insert into zx_regimes_b/tl ******
2070: FOR k in 1..denorm_tbl.count LOOP
2071: if denorm_tbl(k).country_code is not null
2072: then
2073: l_tax_regime_name := denorm_tbl(k).country_code || '-SALES-TAX' ||

Line 2089: FROM ZX_REGIMES_B

2085: l_tax_regime_code := denorm_tbl(k).country_code || '-SALES-TAX-' || denorm_tbl(k).id_flex_num;
2086:
2087: INSERT ALL
2088: WHEN (NOT EXISTS (SELECT 1
2089: FROM ZX_REGIMES_B
2090: WHERE TAX_REGIME_CODE = l_tax_regime_code
2091: )
2092: ) THEN
2093: INTO ZX_REGIMES_B

Line 2093: INTO ZX_REGIMES_B

2089: FROM ZX_REGIMES_B
2090: WHERE TAX_REGIME_CODE = l_tax_regime_code
2091: )
2092: ) THEN
2093: INTO ZX_REGIMES_B
2094: (
2095: TAX_REGIME_CODE ,
2096: PARENT_REGIME_CODE ,
2097: HAS_SUB_REGIME_FLAG ,

Line 2234: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

2230: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
2231: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG /** Set it to Y. Need P2P Change. **/
2232: NULL ,--REGIME_PRECEDENCE /** Can be updated for compounding migration **/
2233: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
2234: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
2235: NULL ,--GEOGRAPHY_ID
2236: NULL ,--THRSHLD_CHK_TMPLT_CODE
2237: NULL ,--PERIOD_SET_NAME
2238: NULL ,--REP_TAX_AUTHORITY_ID

Line 2252: FROM ZX_REGIMES_B

2248: fnd_global.conc_login_id ,--Program Login ID
2249: 1
2250: )
2251: WHEN (NOT EXISTS (SELECT 1
2252: FROM ZX_REGIMES_B
2253: WHERE TAX_REGIME_CODE = l_tax_regime_code
2254: )
2255: ) THEN
2256: -- Need to insert _TL table for current language as l_tax_regime_name is

Line 2285: ZX_REGIMES_B_S.NEXTVAL

2281: fnd_global.user_id ,
2282: SYSDATE ,
2283: fnd_global.user_id ,
2284: fnd_global.conc_login_id ,
2285: ZX_REGIMES_B_S.NEXTVAL
2286: )
2287: SELECT 1 FROM DUAL;
2288: END IF;
2289: END LOOP;

Line 2303: INTO zx_regimes_b

2299: |
2300: +--------------------------------------------------------------------------*/
2301: /*
2302: INSERT ALL
2303: INTO zx_regimes_b
2304: (
2305: TAX_REGIME_CODE ,
2306: PARENT_REGIME_CODE ,
2307: HAS_SUB_REGIME_FLAG ,

Line 2444: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

2440: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
2441: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
2442: NULL ,--REGIME_PRECEDENCE
2443: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
2444: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
2445: NULL ,--GEOGRAPHY_ID
2446: NULL ,--THRSHLD_CHK_TMPLT_CODE
2447: NULL ,--PERIOD_SET_NAME
2448: NULL ,--REP_TAX_AUTHORITY_ID

Line 2472: FROM zx_regimes_b

2468: FROM ar_system_parameters_all asp
2469: WHERE asp.tax_database_view_set IN ('_A', '_V')
2470: AND asp.default_country = 'US'
2471: AND NOT EXISTS (SELECT 1
2472: FROM zx_regimes_b
2473: WHERE tax_regime_code IN ('US-SALES-TAX-TAXWARE', 'US-SALES-TAX-VERTEX')
2474: );
2475: */
2476:

Line 2537: ZX_REGIMES_B B,

2533: fnd_global.conc_login_id ,
2534: B.TAX_REGIME_ID
2535: FROM
2536: FND_LANGUAGES L,
2537: ZX_REGIMES_B B,
2538: (select rates.tax_regime_code tax_regime_code,
2539: lkups.meaning meaning,
2540: params.global_attribute_category global_attribute_category
2541: from zx_rates_b rates,

Line 2617: ZX_REGIMES_B B,

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