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

Line 409: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE; --VARCHAR2(80)

405: l_temp_appl_col_name VARCHAR2(30);
406:
407: l_min_start_date DATE;
408: l_tax_regime_name zx_regimes_tl.tax_regime_name%TYPE; --VARCHAR2(30)
409: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE; --VARCHAR2(80)
410: l_count PLS_INTEGER; --Bug 4204464
411: l_tax_acct_cr_method VARCHAR2(30);
412: l_tax_acct_source_tax VARCHAR2(30);
413: l_tax_exmpt_cr_mthd VARCHAR2(30);

Line 521: ** Records in denorm_tbl is used to insert records in zx_regimes_b and zx_taxes_b.

517: ** 101 US CITY COUNTY STATE 200 USD
518: ** 200 US CITY COUNTY STATE 300 USD
519: **
520: **
521: ** Records in denorm_tbl is used to insert records in zx_regimes_b and zx_taxes_b.
522: ** The program creates one regime record for each location structure.
523: ** The program creates as many tax records s as the number of segments in a location structure.
524: **
525: ** If same structure is shared among different OUs

Line 1097: FROM ZX_REGIMES_B

1093: *
1094:
1095: INSERT ALL
1096: WHEN (NOT EXISTS (SELECT 1
1097: FROM ZX_REGIMES_B
1098: WHERE TAX_REGIME_CODE = l_tax_regime_code
1099: )
1100: ) THEN
1101: INTO ZX_REGIMES_B

Line 1101: INTO ZX_REGIMES_B

1097: FROM ZX_REGIMES_B
1098: WHERE TAX_REGIME_CODE = l_tax_regime_code
1099: )
1100: ) THEN
1101: INTO ZX_REGIMES_B
1102: (
1103: TAX_REGIME_CODE ,
1104: PARENT_REGIME_CODE ,
1105: HAS_SUB_REGIME_FLAG ,

Line 1242: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1238: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1239: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1240: NULL ,--REGIME_PRECEDENCE
1241: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
1242: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1243: NULL ,--GEOGRAPHY_ID
1244: NULL ,--THRSHLD_CHK_TMPLT_CODE
1245: NULL ,--PERIOD_SET_NAME
1246: NULL ,--REP_TAX_AUTHORITY_ID

Line 1261: FROM ZX_REGIMES_B

1257: 1
1258: )
1259:
1260: WHEN (NOT EXISTS (SELECT 1
1261: FROM ZX_REGIMES_B
1262: WHERE TAX_REGIME_CODE = l_tax_regime_code
1263: )
1264: ) THEN
1265: INTO ZX_REGIMES_TL

Line 1287: ZX_REGIMES_B_S.NEXTVAL

1283: fnd_global.user_id ,
1284: SYSDATE ,
1285: fnd_global.user_id ,
1286: fnd_global.conc_login_id ,
1287: ZX_REGIMES_B_S.NEXTVAL
1288: )
1289: SELECT 1 FROM DUAL;
1290:
1291: *

Line 1292: * End of commenting out zx_regimes_b/_tl population logic

1288: )
1289: SELECT 1 FROM DUAL;
1290:
1291: *
1292: * End of commenting out zx_regimes_b/_tl population logic
1293: */
1294:
1295: -- ***** Inserting Taxes for location segnemt qualifiers *****
1296:

Line 2100: zx_regimes_b zrb

2096: ar_vat_tax_all_b avt,
2097: zx_party_tax_profile ptp,
2098: ar_system_parameters_all asp,
2099: gl_sets_of_books gsob,
2100: zx_regimes_b zrb
2101: WHERE avt.org_id = ptp.party_id
2102: AND ptp.party_type_code = 'OU'
2103: AND avt.org_id = asp.org_id
2104: AND asp.set_of_books_id = gsob.set_of_books_id

Line 2514: zx_regimes_b zrb

2510: ar_vat_tax_all_b avt,
2511: zx_party_tax_profile ptp,
2512: ar_system_parameters_all asp,
2513: gl_sets_of_books gsob,
2514: zx_regimes_b zrb
2515: WHERE avt.org_id = ptp.party_id
2516: AND avt.org_id = l_org_id
2517: AND ptp.party_type_code = 'OU'
2518: AND avt.org_id = asp.org_id

Line 3537: FROM zx_regimes_b zrb,

3533: IF L_MULTI_ORG_FLAG = 'Y'
3534: THEN
3535: SELECT zrb.tax_regime_code
3536: BULK COLLECT INTO tax_regime_code_rec
3537: FROM zx_regimes_b zrb,
3538: ar_system_parameters_all asp
3539: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3540: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3541: AND asp.tax_database_view_set = '_A';

Line 3545: FROM zx_regimes_b zrb,

3541: AND asp.tax_database_view_set = '_A';
3542: ELSE
3543: SELECT zrb.tax_regime_code
3544: BULK COLLECT INTO tax_regime_code_rec
3545: FROM zx_regimes_b zrb,
3546: ar_system_parameters_all asp
3547: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3548: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3549: AND asp.tax_database_view_set = '_A'

Line 3700: FROM zx_regimes_b zrb,

3696: IF L_MULTI_ORG_FLAG = 'Y'
3697: THEN
3698: SELECT zrb.tax_regime_code
3699: BULK COLLECT INTO tax_regime_code_rec
3700: FROM zx_regimes_b zrb,
3701: ar_system_parameters_all asp
3702: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3703: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3704: AND asp.tax_database_view_set = '_V';

Line 3709: FROM zx_regimes_b zrb,

3705: ELSE
3706:
3707: SELECT zrb.tax_regime_code
3708: BULK COLLECT INTO tax_regime_code_rec
3709: FROM zx_regimes_b zrb,
3710: ar_system_parameters_all asp
3711: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3712: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3713: AND asp.tax_database_view_set = '_V'

Line 4424: zx_regimes_b zrb,

4420: FROM
4421: ar_vat_tax_all_b avt,
4422: zx_party_tax_profile ptp,
4423: ar_system_parameters_all asp,
4424: zx_regimes_b zrb,
4425: zx_taxes_b ztb
4426: WHERE ptp.party_type_code = 'OU'
4427: AND ptp.party_id = avt.org_id
4428: AND avt.org_id = asp.org_id

Line 4756: zx_regimes_b zrb,

4752: FROM
4753: ar_vat_tax_all_b avt,
4754: zx_party_tax_profile ptp,
4755: ar_system_parameters_all asp,
4756: zx_regimes_b zrb,
4757: zx_taxes_b ztb
4758: WHERE ptp.party_type_code = 'OU'
4759: AND ptp.party_id = l_org_id
4760: AND ptp.party_id = avt.org_id

Line 6063: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;

6059: AS
6060: -- ****** VARIABLES ******
6061: l_location_str_id ar_system_parameters_all.location_structure_id%TYPE;
6062: l_org_id ar_vat_tax_all_b.org_id%TYPE;
6063: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
6064: l_tax zx_taxes_b.tax%TYPE;
6065:
6066: BEGIN
6067: IF p_tax_id IS NOT NULL AND p_tax_type = 'LOCATION' THEN

Line 6104: FROM zx_regimes_b regime

6100: IF l_location_str_id IS NOT NULL THEN
6101: BEGIN
6102: SELECT tax_regime_code
6103: INTO l_tax_regime_code
6104: FROM zx_regimes_b regime
6105: WHERE tax_regime_code like '%-SALES-TAX-%'
6106: AND l_location_str_id = TO_NUMBER(
6107: NVL(LTRIM(
6108: TRANSLATE(regime.tax_regime_code,

Line 8144: select distinct tax_regime_code from zx_regimes_b

8140: update zx_taxes_b_tmp
8141: set legal_reporting_status_def_val = '000000000000000'
8142: WHERE record_type_code = 'MIGRATED'
8143: AND tax_regime_code in (
8144: select distinct tax_regime_code from zx_regimes_b
8145: where country_code in (
8146: 'BE',
8147: 'CH',
8148: 'CZ',

Line 8188: | This routine creates records in zx_regimes_b/tl grouping by child

8184: |
8185: | OUT
8186: |
8187: | DESCRIPTION
8188: | This routine creates records in zx_regimes_b/tl grouping by child
8189: | records.
8190: |
8191: |
8192: | SCOPE - PRIVATE

Line 8214: ZX_REGIMES_B

8210: PROCEDURE create_zx_regimes (p_tax_id NUMBER) AS
8211: BEGIN
8212:
8213: INSERT INTO
8214: ZX_REGIMES_B
8215: (
8216: TAX_REGIME_CODE ,
8217: PARENT_REGIME_CODE ,
8218: HAS_SUB_REGIME_FLAG ,

Line 8353: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

8349: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
8350: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG /** Set it to Y. Need P2P Change. **/
8351: NULL ,--REGIME_PRECEDENCE /** Can be updated for compounding migration **/
8352: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
8353: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
8354: NULL ,--GEOGRAPHY_ID
8355: NULL ,--THRSHLD_CHK_TMPLT_CODE
8356: NULL ,--PERIOD_SET_NAME
8357: NULL ,--REP_TAX_AUTHORITY_ID

Line 8384: AND not exists (select 1 from zx_regimes_b

8380: AND rates.tax_rate_id = decode(rates.tax_class, 'OUTPUT', nvl(p_tax_id, rates.tax_rate_id),
8381: rates.tax_rate_id)
8382:
8383: --Rerunability
8384: AND not exists (select 1 from zx_regimes_b
8385: where tax_regime_code = rates.tax_regime_code
8386: )
8387: GROUP BY
8388: RATES.TAX_REGIME_CODE

Line 8422: ZX_REGIMES_B B,

8418: fnd_global.conc_login_id ,
8419: B.TAX_REGIME_ID
8420: FROM
8421: FND_LANGUAGES L,
8422: ZX_REGIMES_B B,
8423: (select rates.tax_regime_code tax_regime_code,
8424: lkups.meaning meaning,
8425: codes.global_attribute_category global_attribute_category
8426: from zx_rates_b rates,

Line 9314: ZX_REGIMES_B B -- cartesian join

9310: L.LANGUAGE_CODE,
9311: userenv('LANG')
9312: FROM
9313: FND_LANGUAGES L,
9314: ZX_REGIMES_B B -- cartesian join
9315: WHERE
9316: L.INSTALLED_FLAG in ('I', 'B')
9317: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9318: AND not exists