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 AR_SYSTEM_PARAMETERS_ALL

Line 700: ar_system_parameters_all asp

696: fnd_global.user_id last_updated_by,
697: sysdate last_updated_date,
698: fnd_global.conc_login_id last_update_login
699: FROM ar_vat_tax_all_b codes,
700: ar_system_parameters_all asp
701: WHERE codes.tax_type not in ('TAX_GROUP', 'LOCATION')
702: AND asp.org_id = codes.org_id
703: -- Eliminate Tax Vendor Tax Codes
704: -- Bug 4880975 : Vendor tax codes other than tax type location

Line 822: ar_system_parameters_all asp

818: fnd_global.user_id last_updated_by,
819: sysdate last_updated_date,
820: fnd_global.conc_login_id last_update_login
821: FROM ar_vat_tax_all_b codes,
822: ar_system_parameters_all asp
823: WHERE codes.tax_type not in ('TAX_GROUP', 'LOCATION')
824: AND asp.org_id = codes.org_id
825: AND asp.org_id = l_org_id
826: -- Eliminate Tax Vendor Tax Codes

Line 982: ar_system_parameters_all asp,

978: fnd_global.user_id last_updated_by,
979: sysdate last_updated_date,
980: fnd_global.conc_login_id last_update_login
981: FROM ar_vat_tax_all_b codes,
982: ar_system_parameters_all asp,
983: zx_tax_priorities_t zxpt
984:
985: WHERE
986: asp.org_id = codes.org_id

Line 1101: ar_system_parameters_all asp,

1097: fnd_global.user_id last_updated_by,
1098: sysdate last_updated_date,
1099: fnd_global.conc_login_id last_update_login
1100: FROM ar_vat_tax_all_b codes,
1101: ar_system_parameters_all asp,
1102: zx_tax_priorities_t zxpt
1103:
1104: WHERE
1105: asp.org_id = codes.org_id

Line 1342: ar_system_parameters_all asp,

1338: ar_codes.end_date effective_to,
1339: 'Y' intercompany_flag
1340: FROM ar_vat_tax_all_b ar_codes,
1341: ap_tax_codes_all ap_codes,
1342: ar_system_parameters_all asp,
1343: mtl_intercompany_parameters intcomp
1344: WHERE ar_codes.tax_type <> 'TAX_GROUP'
1345: AND decode(l_multi_org_flag,'N',l_org_id,asp.org_id) = decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)
1346: AND decode(l_multi_org_flag,'N',l_org_id,ap_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,intcomp.sell_organization_id)

Line 1410: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE

1406: k PLS_INTEGER;
1407: l_temp_id_flex_num NUMBER; --fnd_id_flex_segments.id_flex_num%TYPE
1408: l_temp_seg_num NUMBER(15); --fnd_id_flex_segments.segment_num%TYPE
1409: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1410: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE

Line 1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE

1407: l_temp_id_flex_num NUMBER; --fnd_id_flex_segments.id_flex_num%TYPE
1408: l_temp_seg_num NUMBER(15); --fnd_id_flex_segments.segment_num%TYPE
1409: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1410: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE
1415: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE

Line 1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE

1408: l_temp_seg_num NUMBER(15); --fnd_id_flex_segments.segment_num%TYPE
1409: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1410: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

Line 1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE

1409: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1410: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

Line 1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE

1410: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

Line 1415: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE

1411: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

Line 1416: l_temp_allow_rounding_override VARCHAR2(30); --ar_system_parameters_all.tax_rounding_allow_override%TYPE

1412: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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:

Line 1417: l_temp_org_id NUMBER(15); --ar_system_parameters_all.org_id%TYPE

1413: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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:

Line 1439: ar_system_parameters_all asp,

1435: asp.tax_rounding_allow_override allow_rounding_override
1436: FROM fnd_id_flex_structures str,
1437: fnd_id_flex_segments segment,
1438: fnd_segment_attribute_values qual,
1439: ar_system_parameters_all asp,
1440: ar_vat_tax_all_b avt,
1441: gl_sets_of_books gsob
1442: WHERE str.id_flex_code = 'RLOC'
1443: AND str.application_id = 222

Line 2545: FROM ar_system_parameters_all asp

2541: 'US-SALES-TAX-TAXWARE'
2542: WHEN asp.tax_database_view_set = '_V' THEN
2543: 'US-SALES-TAX-VERTEX'
2544: END l_tax_regime_code
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

Line 2620: ar_system_parameters_all params,

2616: lkups.meaning meaning,
2617: params.global_attribute_category global_attribute_category
2618: from zx_rates_b rates,
2619: ar_vat_tax_all_b codes,
2620: ar_system_parameters_all params,
2621: fnd_lookups lkups
2622: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2623: AND codes.org_id = params.org_id
2624: and params.global_attribute13 = lkups.lookup_code

Line 2700: ar_system_parameters_all params,

2696: lkups.meaning meaning,
2697: params.global_attribute_category global_attribute_category
2698: from zx_rates_b rates,
2699: ar_vat_tax_all_b codes,
2700: ar_system_parameters_all params,
2701: fnd_lookups lkups
2702: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2703: AND codes.org_id = params.org_id
2704: AND codes.org_id = l_org_id