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 AP_TAX_CODES_ALL

Line 113: FROM ap_tax_codes_all codes,

109: sysdate creation_date,
110: fnd_global.user_id last_updated_by,
111: sysdate last_updated_date,
112: fnd_global.conc_login_id last_update_login
113: FROM ap_tax_codes_all codes,
114: financials_system_params_all fsp
115: WHERE codes.tax_type NOT IN ('AWT','TAX_GROUP','OFFSET')
116: AND codes.org_id = fsp.org_id
117: -- Sync process

Line 219: FROM ap_tax_codes_all codes,

215: sysdate creation_date,
216: fnd_global.user_id last_updated_by,
217: sysdate last_updated_date,
218: fnd_global.conc_login_id last_update_login
219: FROM ap_tax_codes_all codes,
220: financials_system_params_all fsp
221: WHERE codes.tax_type NOT IN ('AWT','TAX_GROUP','OFFSET')
222: AND codes.org_id = fsp.org_id
223: AND codes.org_id = l_org_id

Line 324: FROM ap_tax_codes_all codes,

320: sysdate creation_date,
321: fnd_global.user_id last_updated_by,
322: sysdate last_updated_date,
323: fnd_global.conc_login_id last_update_login
324: FROM ap_tax_codes_all codes,
325: ap_tax_codes_all offset,
326: financials_system_params_all fsp
327: WHERE offset.tax_type = 'OFFSET'
328: AND offset.tax_id = codes.offset_tax_code_id

Line 325: ap_tax_codes_all offset,

321: fnd_global.user_id last_updated_by,
322: sysdate last_updated_date,
323: fnd_global.conc_login_id last_update_login
324: FROM ap_tax_codes_all codes,
325: ap_tax_codes_all offset,
326: financials_system_params_all fsp
327: WHERE offset.tax_type = 'OFFSET'
328: AND offset.tax_id = codes.offset_tax_code_id
329: AND codes.offset_tax_code_id IS NOT NULL

Line 428: FROM ap_tax_codes_all codes,

424: sysdate creation_date,
425: fnd_global.user_id last_updated_by,
426: sysdate last_updated_date,
427: fnd_global.conc_login_id last_update_login
428: FROM ap_tax_codes_all codes,
429: ap_tax_codes_all offset,
430: financials_system_params_all fsp
431: WHERE offset.tax_type = 'OFFSET'
432: AND offset.tax_id = codes.offset_tax_code_id

Line 429: ap_tax_codes_all offset,

425: fnd_global.user_id last_updated_by,
426: sysdate last_updated_date,
427: fnd_global.conc_login_id last_update_login
428: FROM ap_tax_codes_all codes,
429: ap_tax_codes_all offset,
430: financials_system_params_all fsp
431: WHERE offset.tax_type = 'OFFSET'
432: AND offset.tax_id = codes.offset_tax_code_id
433: AND codes.offset_tax_code_id IS NOT NULL

Line 507: ap_tax_codes_all offset,

503: fnd_global.user_id last_updated_by,
504: sysdate last_updated_date,
505: fnd_global.conc_login_id last_update_login
506: FROM
507: ap_tax_codes_all offset,
508: financials_system_params_all fsp
509: WHERE offset.tax_type = 'OFFSET'
510: AND offset.org_id = fsp.org_id
511: AND not exists (select 1 from ap_tax_codes_all where

Line 511: AND not exists (select 1 from ap_tax_codes_all where

507: ap_tax_codes_all offset,
508: financials_system_params_all fsp
509: WHERE offset.tax_type = 'OFFSET'
510: AND offset.org_id = fsp.org_id
511: AND not exists (select 1 from ap_tax_codes_all where
512: offset_tax_code_id = offset.tax_id)
513: -- Rerunability
514: AND NOT EXISTS (SELECT 1
515: FROM zx_update_criteria_results zucr

Line 577: ap_tax_codes_all offset,

573: fnd_global.user_id last_updated_by,
574: sysdate last_updated_date,
575: fnd_global.conc_login_id last_update_login
576: FROM
577: ap_tax_codes_all offset,
578: financials_system_params_all fsp
579: WHERE offset.tax_type = 'OFFSET'
580: AND offset.org_id = fsp.org_id
581: AND offset.org_id = l_org_id

Line 582: AND not exists (select 1 from ap_tax_codes_all where

578: financials_system_params_all fsp
579: WHERE offset.tax_type = 'OFFSET'
580: AND offset.org_id = fsp.org_id
581: AND offset.org_id = l_org_id
582: AND not exists (select 1 from ap_tax_codes_all where
583: offset_tax_code_id = offset.tax_id)
584: -- Rerunability
585: AND NOT EXISTS (SELECT 1
586: FROM zx_update_criteria_results zucr

Line 1219: FROM ap_tax_codes_all ap_codes,

1215: fnd_global.conc_login_id last_update_login,
1216: ap_codes.start_date effective_from,
1217: ap_codes.inactive_date effective_to,
1218: 'Y' intercompany_flag
1219: FROM ap_tax_codes_all ap_codes,
1220: ar_vat_tax_all_b ar_codes,
1221: financials_system_params_all fsp,
1222: mtl_intercompany_parameters intcomp
1223: WHERE ap_codes.tax_type NOT IN ('AWT','TAX_GROUP')

Line 1341: ap_tax_codes_all ap_codes,

1337: ar_codes.start_date effective_from,
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)

Line 2762: FROM ap_tax_codes_all;

2758: -- ****** Determine min(start_date) ******
2759: BEGIN
2760: SELECT min(start_date)
2761: INTO l_ap_min_start_date
2762: FROM ap_tax_codes_all;
2763: EXCEPTION
2764: WHEN NO_DATA_FOUND THEN
2765: l_ap_min_start_date := sysdate;
2766: END;

Line 2780: FROM ap_tax_codes_all

2776:
2777: BEGIN
2778: SELECT count(*)
2779: INTO l_ap_count
2780: FROM ap_tax_codes_all
2781: WHERE tax_type <> 'AWT';
2782: --Bug 9415223
2783: END;
2784: