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 942: ar_system_parameters_all asp,

938: fnd_global.user_id last_updated_by,
939: sysdate last_updated_date,
940: fnd_global.conc_login_id last_update_login
941: FROM ar_vat_tax_all_b codes,
942: ar_system_parameters_all asp,
943: zx_tax_priorities_t zxpt
944:
945: WHERE
946: asp.org_id = codes.org_id

Line 1024: ar_system_parameters_all asp,

1020: fnd_global.user_id last_updated_by,
1021: sysdate last_updated_date,
1022: fnd_global.conc_login_id last_update_login
1023: FROM ar_vat_tax_all_b codes,
1024: ar_system_parameters_all asp,
1025: zx_tax_priorities_t zxpt
1026:
1027: WHERE
1028: asp.org_id = codes.org_id

Line 1265: ar_system_parameters_all asp,

1261: ar_codes.end_date effective_to,
1262: 'Y' intercompany_flag
1263: FROM ar_vat_tax_all_b ar_codes,
1264: ap_tax_codes_all ap_codes,
1265: ar_system_parameters_all asp,
1266: mtl_intercompany_parameters intcomp
1267: WHERE ar_codes.tax_type <> 'TAX_GROUP'
1268: 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)
1269: 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 1333: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE

1329: k PLS_INTEGER;
1330: l_temp_id_flex_num NUMBER; --fnd_id_flex_segments.id_flex_num%TYPE
1331: l_temp_seg_num NUMBER(15); --fnd_id_flex_segments.segment_num%TYPE
1332: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1333: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1334: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1335: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1336: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE

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

1330: l_temp_id_flex_num NUMBER; --fnd_id_flex_segments.id_flex_num%TYPE
1331: l_temp_seg_num NUMBER(15); --fnd_id_flex_segments.segment_num%TYPE
1332: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1333: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1334: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1335: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1336: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE
1338: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE

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

1331: l_temp_seg_num NUMBER(15); --fnd_id_flex_segments.segment_num%TYPE
1332: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1333: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1334: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1335: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1336: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

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

1332: l_temp_seg_att_type VARCHAR2(30); --fnd_segment_attribute_values.segment_attribute_type%TYPE
1333: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1334: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1335: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1336: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

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

1333: l_temp_tax_currency_code VARCHAR2(15); --ar_system_parameters_all.tax_currency_code%TYPE
1334: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1335: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1336: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

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

1334: l_temp_tax_precision NUMBER(1); --ar_system_parameters_all.tax_precision%TYPE
1335: l_temp_tax_mau NUMBER; --ar_system_parameters_all.tax_minimum_accountable_unit%TYPE
1336: l_temp_country_code VARCHAR2(60); --ar_system_parameters_all.default_country%TYPE
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%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

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

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

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

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

Line 1362: ar_system_parameters_all asp,

1358: asp.tax_rounding_allow_override allow_rounding_override
1359: FROM fnd_id_flex_structures str,
1360: fnd_id_flex_segments segment,
1361: fnd_segment_attribute_values qual,
1362: ar_system_parameters_all asp,
1363: ar_vat_tax_all_b avt,
1364: gl_sets_of_books gsob
1365: WHERE str.id_flex_code = 'RLOC'
1366: AND str.application_id = 222

Line 2468: FROM ar_system_parameters_all asp

2464: 'US-SALES-TAX-TAXWARE'
2465: WHEN asp.tax_database_view_set = '_V' THEN
2466: 'US-SALES-TAX-VERTEX'
2467: END l_tax_regime_code
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

Line 2543: ar_system_parameters_all params,

2539: lkups.meaning meaning,
2540: params.global_attribute_category global_attribute_category
2541: from zx_rates_b rates,
2542: ar_vat_tax_all_b codes,
2543: ar_system_parameters_all params,
2544: fnd_lookups lkups
2545: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2546: AND codes.org_id = params.org_id
2547: and params.global_attribute13 = lkups.lookup_code

Line 2623: ar_system_parameters_all params,

2619: lkups.meaning meaning,
2620: params.global_attribute_category global_attribute_category
2621: from zx_rates_b rates,
2622: ar_vat_tax_all_b codes,
2623: ar_system_parameters_all params,
2624: fnd_lookups lkups
2625: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2626: AND codes.org_id = params.org_id
2627: AND codes.org_id = l_org_id