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 539: ** Records in denorm_tbl is used to insert records in zx_regimes_b and zx_taxes_b.

535: ** 101 US CITY COUNTY STATE 200 USD
536: ** 200 US CITY COUNTY STATE 300 USD
537: **
538: **
539: ** Records in denorm_tbl is used to insert records in zx_regimes_b and zx_taxes_b.
540: ** The program creates one regime record for each location structure.
541: ** The program creates as many tax records s as the number of segments in a location structure.
542: **
543: ** If same structure is shared among different OUs

Line 1183: FROM ZX_REGIMES_B

1179: *
1180:
1181: INSERT ALL
1182: WHEN (NOT EXISTS (SELECT 1
1183: FROM ZX_REGIMES_B
1184: WHERE TAX_REGIME_CODE = l_tax_regime_code
1185: )
1186: ) THEN
1187: INTO ZX_REGIMES_B

Line 1187: INTO ZX_REGIMES_B

1183: FROM ZX_REGIMES_B
1184: WHERE TAX_REGIME_CODE = l_tax_regime_code
1185: )
1186: ) THEN
1187: INTO ZX_REGIMES_B
1188: (
1189: TAX_REGIME_CODE ,
1190: PARENT_REGIME_CODE ,
1191: HAS_SUB_REGIME_FLAG ,

Line 1328: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

1324: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
1325: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG
1326: NULL ,--REGIME_PRECEDENCE
1327: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
1328: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
1329: NULL ,--GEOGRAPHY_ID
1330: NULL ,--THRSHLD_CHK_TMPLT_CODE
1331: NULL ,--PERIOD_SET_NAME
1332: NULL ,--REP_TAX_AUTHORITY_ID

Line 1347: FROM ZX_REGIMES_B

1343: 1
1344: )
1345:
1346: WHEN (NOT EXISTS (SELECT 1
1347: FROM ZX_REGIMES_B
1348: WHERE TAX_REGIME_CODE = l_tax_regime_code
1349: )
1350: ) THEN
1351: INTO ZX_REGIMES_TL

Line 1373: ZX_REGIMES_B_S.NEXTVAL

1369: fnd_global.user_id ,
1370: SYSDATE ,
1371: fnd_global.user_id ,
1372: fnd_global.conc_login_id ,
1373: ZX_REGIMES_B_S.NEXTVAL
1374: )
1375: SELECT 1 FROM DUAL;
1376:
1377: *

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

1374: )
1375: SELECT 1 FROM DUAL;
1376:
1377: *
1378: * End of commenting out zx_regimes_b/_tl population logic
1379: */
1380:
1381: -- ***** Inserting Taxes for location segnemt qualifiers *****
1382:

Line 2186: zx_regimes_b zrb

2182: ar_vat_tax_all_b avt,
2183: zx_party_tax_profile ptp,
2184: ar_system_parameters_all asp,
2185: gl_sets_of_books gsob,
2186: zx_regimes_b zrb
2187: WHERE avt.org_id = ptp.party_id
2188: AND ptp.party_type_code = 'OU'
2189: AND avt.org_id = asp.org_id
2190: AND asp.set_of_books_id = gsob.set_of_books_id

Line 2601: zx_regimes_b zrb

2597: ar_vat_tax_all_b avt,
2598: zx_party_tax_profile ptp,
2599: ar_system_parameters_all asp,
2600: gl_sets_of_books gsob,
2601: zx_regimes_b zrb
2602: WHERE avt.org_id = ptp.party_id
2603: AND avt.org_id = l_org_id
2604: AND ptp.party_type_code = 'OU'
2605: AND avt.org_id = asp.org_id

Line 3660: FROM zx_regimes_b zrb,

3656: IF L_MULTI_ORG_FLAG = 'Y'
3657: THEN
3658: SELECT zrb.tax_regime_code
3659: BULK COLLECT INTO tax_regime_code_rec
3660: FROM zx_regimes_b zrb,
3661: ar_system_parameters_all asp
3662: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3663: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3664: AND asp.tax_database_view_set = '_A';

Line 3668: FROM zx_regimes_b zrb,

3664: AND asp.tax_database_view_set = '_A';
3665: ELSE
3666: SELECT zrb.tax_regime_code
3667: BULK COLLECT INTO tax_regime_code_rec
3668: FROM zx_regimes_b zrb,
3669: ar_system_parameters_all asp
3670: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3671: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3672: AND asp.tax_database_view_set = '_A'

Line 3823: FROM zx_regimes_b zrb,

3819: IF L_MULTI_ORG_FLAG = 'Y'
3820: THEN
3821: SELECT zrb.tax_regime_code
3822: BULK COLLECT INTO tax_regime_code_rec
3823: FROM zx_regimes_b zrb,
3824: ar_system_parameters_all asp
3825: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3826: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3827: AND asp.tax_database_view_set = '_V';

Line 3832: FROM zx_regimes_b zrb,

3828: ELSE
3829:
3830: SELECT zrb.tax_regime_code
3831: BULK COLLECT INTO tax_regime_code_rec
3832: FROM zx_regimes_b zrb,
3833: ar_system_parameters_all asp
3834: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3835: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3836: AND asp.tax_database_view_set = '_V'

Line 4401: zx_regimes_b zrb,

4397: FROM
4398: ar_vat_tax_all_b avt,
4399: zx_party_tax_profile ptp,
4400: ar_system_parameters_all asp,
4401: zx_regimes_b zrb,
4402: zx_taxes_b ztb
4403: WHERE ptp.party_type_code = 'OU'
4404: AND ptp.party_id = avt.org_id
4405: AND avt.org_id = asp.org_id

Line 4733: zx_regimes_b zrb,

4729: FROM
4730: ar_vat_tax_all_b avt,
4731: zx_party_tax_profile ptp,
4732: ar_system_parameters_all asp,
4733: zx_regimes_b zrb,
4734: zx_taxes_b ztb
4735: WHERE ptp.party_type_code = 'OU'
4736: AND ptp.party_id = l_org_id
4737: AND ptp.party_id = avt.org_id

Line 6075: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;

6071: AS
6072: -- ****** VARIABLES ******
6073: l_location_str_id ar_system_parameters_all.location_structure_id%TYPE;
6074: l_org_id ar_vat_tax_all_b.org_id%TYPE;
6075: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
6076: l_tax zx_taxes_b.tax%TYPE;
6077:
6078: BEGIN
6079: IF p_tax_id IS NOT NULL AND p_tax_type = 'LOCATION' THEN

Line 6116: FROM zx_regimes_b regime

6112: IF l_location_str_id IS NOT NULL THEN
6113: BEGIN
6114: SELECT tax_regime_code
6115: INTO l_tax_regime_code
6116: FROM zx_regimes_b regime
6117: WHERE tax_regime_code like '%-SALES-TAX-%'
6118: AND l_location_str_id = TO_NUMBER(
6119: NVL(LTRIM(
6120: TRANSLATE(regime.tax_regime_code,

Line 8156: select distinct tax_regime_code from zx_regimes_b

8152: update zx_taxes_b_tmp
8153: set legal_reporting_status_def_val = '000000000000000'
8154: WHERE record_type_code = 'MIGRATED'
8155: AND tax_regime_code in (
8156: select distinct tax_regime_code from zx_regimes_b
8157: where country_code in (
8158: 'BE',
8159: 'CH',
8160: 'CZ',

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

8196: |
8197: | OUT
8198: |
8199: | DESCRIPTION
8200: | This routine creates records in zx_regimes_b/tl grouping by child
8201: | records.
8202: |
8203: |
8204: | SCOPE - PRIVATE

Line 8226: ZX_REGIMES_B

8222: PROCEDURE create_zx_regimes (p_tax_id NUMBER) AS
8223: BEGIN
8224:
8225: INSERT INTO
8226: ZX_REGIMES_B
8227: (
8228: TAX_REGIME_CODE ,
8229: PARENT_REGIME_CODE ,
8230: HAS_SUB_REGIME_FLAG ,

Line 8365: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID

8361: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
8362: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG /** Set it to Y. Need P2P Change. **/
8363: NULL ,--REGIME_PRECEDENCE /** Can be updated for compounding migration **/
8364: 'N' ,--CROSS_REGIME_COMPOUNDING_FLAG
8365: ZX_REGIMES_B_S.NEXTVAL ,--TAX_REGIME_ID
8366: NULL ,--GEOGRAPHY_ID
8367: NULL ,--THRSHLD_CHK_TMPLT_CODE
8368: NULL ,--PERIOD_SET_NAME
8369: NULL ,--REP_TAX_AUTHORITY_ID

Line 8396: AND not exists (select 1 from zx_regimes_b

8392: AND rates.tax_rate_id = decode(rates.tax_class, 'OUTPUT', nvl(p_tax_id, rates.tax_rate_id),
8393: rates.tax_rate_id)
8394:
8395: --Rerunability
8396: AND not exists (select 1 from zx_regimes_b
8397: where tax_regime_code = rates.tax_regime_code
8398: )
8399: GROUP BY
8400: RATES.TAX_REGIME_CODE

Line 8434: ZX_REGIMES_B B,

8430: fnd_global.conc_login_id ,
8431: B.TAX_REGIME_ID
8432: FROM
8433: FND_LANGUAGES L,
8434: ZX_REGIMES_B B,
8435: (select rates.tax_regime_code tax_regime_code,
8436: lkups.meaning meaning,
8437: codes.global_attribute_category global_attribute_category
8438: from zx_rates_b rates,

Line 9326: ZX_REGIMES_B B -- cartesian join

9322: L.LANGUAGE_CODE,
9323: userenv('LANG')
9324: FROM
9325: FND_LANGUAGES L,
9326: ZX_REGIMES_B B -- cartesian join
9327: WHERE
9328: L.INSTALLED_FLAG in ('I', 'B')
9329: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9330: AND not exists