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 dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1290: financials_system_params_all fsp,

1286: zx_update_criteria_results results,
1287: ap_tax_codes_all codes,
1288: ar_vat_tax_all_b ar_codes,
1289: ap_tax_recvry_rules_all rec_rules,
1290: financials_system_params_all fsp,
1291: zx_party_tax_profile ptp
1292: WHERE
1293: results.tax_code_id = codes.tax_id
1294: and results.tax_class = 'INPUT'

Line 1389: financials_system_params_all fsp,

1385: zx_update_criteria_results results,
1386: ap_tax_codes_all codes,
1387: ar_vat_tax_all_b ar_codes,
1388: zx_update_criteria_results offset,
1389: financials_system_params_all fsp,
1390: ap_tax_recvry_rules_all rec_rules,
1391: zx_party_tax_profile ptp
1392: WHERE
1393: results.tax_code_id = codes.tax_id

Line 1711: financials_system_params_all fsp,

1707: zx_update_criteria_results results,
1708: ap_tax_codes_all codes,
1709: ar_vat_tax_all_b ar_codes,
1710: ap_tax_recvry_rules_all rec_rules,
1711: financials_system_params_all fsp,
1712: zx_party_tax_profile ptp
1713: WHERE
1714: results.tax_code_id = codes.tax_id
1715: and results.tax_class = 'INPUT'

Line 1811: financials_system_params_all fsp,

1807: zx_update_criteria_results results,
1808: ap_tax_codes_all codes,
1809: ar_vat_tax_all_b ar_codes,
1810: zx_update_criteria_results offset,
1811: financials_system_params_all fsp,
1812: ap_tax_recvry_rules_all rec_rules,
1813: zx_party_tax_profile ptp
1814: WHERE
1815: results.tax_code_id = codes.tax_id

Line 2141: financials_system_params_all fsp,

2137: FROM
2138: zx_update_criteria_results results,
2139: ap_tax_codes_all codes,
2140: ap_tax_recvry_rules_all rec_rules,
2141: financials_system_params_all fsp,
2142: zx_party_tax_profile ptp
2143: WHERE
2144: results.tax_code_id = codes.tax_id
2145: AND results.tax_class = 'INPUT'

Line 2241: financials_system_params_all fsp,

2237: FROM
2238: zx_update_criteria_results results,
2239: ap_tax_codes_all codes,
2240: zx_update_criteria_results offset,
2241: financials_system_params_all fsp,
2242: ap_tax_recvry_rules_all rec_rules,
2243: zx_party_tax_profile ptp
2244: WHERE
2245: results.tax_code_id = codes.tax_id

Line 2566: financials_system_params_all fsp,

2562: FROM
2563: zx_update_criteria_results results,
2564: ap_tax_codes_all codes,
2565: ap_tax_recvry_rules_all rec_rules,
2566: financials_system_params_all fsp,
2567: zx_party_tax_profile ptp
2568: WHERE
2569: results.tax_code_id = codes.tax_id
2570: AND results.tax_class = 'INPUT'

Line 2667: financials_system_params_all fsp,

2663: FROM
2664: zx_update_criteria_results results,
2665: ap_tax_codes_all codes,
2666: zx_update_criteria_results offset,
2667: financials_system_params_all fsp,
2668: ap_tax_recvry_rules_all rec_rules,
2669: zx_party_tax_profile ptp
2670: WHERE
2671: results.tax_code_id = codes.tax_id

Line 3086: financials_system_params_all fsp,

3082: zx_update_criteria_results results,
3083: ap_tax_codes_all codes,
3084: ar_vat_tax_all_b ar_codes,
3085: ap_tax_codes_all offset,
3086: financials_system_params_all fsp,
3087: zx_party_tax_profile ptp
3088: WHERE
3089: results.tax_code_id = codes.offset_tax_code_id
3090: AND codes.offset_tax_code_id = offset.tax_id

Line 3397: financials_system_params_all fsp,

3393: zx_update_criteria_results results,
3394: ap_tax_codes_all codes,
3395: ar_vat_tax_all_b ar_codes,
3396: ap_tax_codes_all offset,
3397: financials_system_params_all fsp,
3398: zx_party_tax_profile ptp
3399: WHERE
3400: results.tax_code_id = codes.offset_tax_code_id
3401: AND codes.offset_tax_code_id = offset.tax_id

Line 3715: financials_system_params_all fsp,

3711: FROM
3712: zx_update_criteria_results results,
3713: ap_tax_codes_all codes,
3714: ap_tax_codes_all offset,
3715: financials_system_params_all fsp,
3716: zx_party_tax_profile ptp
3717: WHERE
3718: results.tax_code_id = codes.offset_tax_code_id
3719: AND results.tax_class = 'INPUT'

Line 4026: financials_system_params_all fsp,

4022: FROM
4023: zx_update_criteria_results results,
4024: ap_tax_codes_all codes,
4025: ap_tax_codes_all offset,
4026: financials_system_params_all fsp,
4027: zx_party_tax_profile ptp
4028: WHERE
4029: results.tax_code_id = codes.offset_tax_code_id
4030: AND results.tax_class = 'INPUT'

Line 4432: financials_system_params_all fsp,

4428: FROM
4429: zx_update_criteria_results results,
4430: ap_tax_codes_all offset,
4431: ar_vat_tax_all_b ar_codes,
4432: financials_system_params_all fsp,
4433: zx_party_tax_profile ptp
4434: WHERE
4435: results.tax_code_id = offset.tax_id
4436: AND results.tax_class = 'INPUT'

Line 4741: financials_system_params_all fsp,

4737: FROM
4738: zx_update_criteria_results results,
4739: ap_tax_codes_all offset,
4740: ar_vat_tax_all_b ar_codes,
4741: financials_system_params_all fsp,
4742: zx_party_tax_profile ptp
4743: WHERE
4744: results.tax_code_id = offset.tax_id
4745: AND results.tax_class = 'INPUT'

Line 5057: financials_system_params_all fsp,

5053: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
5054: FROM
5055: zx_update_criteria_results results,
5056: ap_tax_codes_all offset,
5057: financials_system_params_all fsp,
5058: zx_party_tax_profile ptp
5059: WHERE
5060: results.tax_code_id = offset.tax_id
5061: AND results.tax_class = 'INPUT'

Line 5368: financials_system_params_all fsp,

5364: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
5365: FROM
5366: zx_update_criteria_results results,
5367: ap_tax_codes_all offset,
5368: financials_system_params_all fsp,
5369: zx_party_tax_profile ptp
5370: WHERE
5371: results.tax_code_id = offset.tax_id
5372: AND results.tax_class = 'INPUT'

Line 7104: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

7100: ZX_RATES_B RATES,
7101: AP_TAX_CODES_ALL CODES,
7102: GL_SETS_OF_BOOKS SOB,
7103: AP_SYSTEM_PARAMETERS_ALL ASP,
7104: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
7105: zx_party_tax_profile ptp
7106: WHERE
7107: CODES.TAX_ID = RATES.SOURCE_ID --No need for the nvl check
7108: AND RATES.TAX_CLASS = 'INPUT' --Creating only INPUT Taxes

Line 7500: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

7496: ZX_RATES_B RATES,
7497: AP_TAX_CODES_ALL CODES,
7498: GL_SETS_OF_BOOKS SOB,
7499: AP_SYSTEM_PARAMETERS_ALL ASP,
7500: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
7501: zx_party_tax_profile ptp
7502: WHERE
7503: CODES.TAX_ID = RATES.SOURCE_ID --No need for the nvl check
7504: AND RATES.TAX_CLASS = 'INPUT' --Creating only INPUT Taxes

Line 7902: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

7898: ZX_RATES_B RATES,
7899: AP_TAX_CODES_ALL CODES,
7900: GL_SETS_OF_BOOKS SOB,
7901: AP_SYSTEM_PARAMETERS_ALL ASP,
7902: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
7903: zx_party_tax_profile ptp
7904: WHERE
7905: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
7906: AND CODES.ORG_ID = PTP.PARTY_ID

Line 8327: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

8323: ZX_RATES_B RATES,
8324: AP_TAX_CODES_ALL CODES,
8325: GL_SETS_OF_BOOKS SOB,
8326: AP_SYSTEM_PARAMETERS_ALL ASP,
8327: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
8328: zx_party_tax_profile ptp
8329: WHERE
8330: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
8331: AND CODES.ORG_ID = PTP.PARTY_ID

Line 9196: financials_system_params_all FSP,

9192: FROM
9193: ap_tax_recvry_rules_all RULES,
9194: --ap_system_parameters_all ASP,
9195: gl_sets_of_books SOB,
9196: financials_system_params_all FSP,
9197: ap_tax_recvry_rates_all RATES
9198: WHERE
9199: rules.org_id = fsp.org_id
9200: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 9327: financials_system_params_all FSP,

9323: FROM
9324: ap_tax_recvry_rules_all RULES,
9325: --ap_system_parameters_all ASP,
9326: gl_sets_of_books SOB,
9327: financials_system_params_all FSP,
9328: ap_tax_recvry_rates_all RATES
9329: WHERE
9330: rules.org_id = fsp.org_id
9331: AND rules.org_id = l_org_id

Line 10745: financials_system_params_all fsp,

10741: zx_update_criteria_results results,
10742: ap_tax_codes_all codes,
10743: ar_vat_tax_all_b ar_codes,
10744: ap_tax_recvry_rules_all rec_rules,
10745: financials_system_params_all fsp,
10746: zx_party_tax_profile ptp
10747: WHERE
10748: results.tax_code_id = tax_id_tab(i)
10749: and results.tax_code_id = codes.tax_id

Line 10845: financials_system_params_all fsp,

10841: zx_update_criteria_results results,
10842: ap_tax_codes_all codes,
10843: ar_vat_tax_all_b ar_codes,
10844: zx_update_criteria_results offset,
10845: financials_system_params_all fsp,
10846: ap_tax_recvry_rules_all rec_rules,
10847: zx_party_tax_profile ptp
10848: WHERE
10849: results.tax_code_id = tax_id_tab(i)

Line 11168: financials_system_params_all fsp,

11164: zx_update_criteria_results results,
11165: ap_tax_codes_all codes,
11166: ar_vat_tax_all_b ar_codes,
11167: ap_tax_recvry_rules_all rec_rules,
11168: financials_system_params_all fsp,
11169: zx_party_tax_profile ptp
11170: WHERE
11171: results.tax_code_id = tax_id_tab(i)
11172: and results.tax_code_id = codes.tax_id

Line 11269: financials_system_params_all fsp,

11265: zx_update_criteria_results results,
11266: ap_tax_codes_all codes,
11267: ar_vat_tax_all_b ar_codes,
11268: zx_update_criteria_results offset,
11269: financials_system_params_all fsp,
11270: ap_tax_recvry_rules_all rec_rules,
11271: zx_party_tax_profile ptp
11272: WHERE
11273: results.tax_code_id = tax_id_tab(i)

Line 11604: financials_system_params_all fsp,

11600: FROM
11601: zx_update_criteria_results results,
11602: ap_tax_codes_all codes,
11603: ap_tax_recvry_rules_all rec_rules,
11604: financials_system_params_all fsp,
11605: zx_party_tax_profile ptp
11606: WHERE
11607: results.tax_code_id = tax_id_tab(i)
11608: AND results.tax_code_id = codes.tax_id

Line 11704: financials_system_params_all fsp,

11700: FROM
11701: zx_update_criteria_results results,
11702: ap_tax_codes_all codes,
11703: zx_update_criteria_results offset,
11704: financials_system_params_all fsp,
11705: ap_tax_recvry_rules_all rec_rules,
11706: zx_party_tax_profile ptp
11707: WHERE
11708: results.tax_code_id = tax_id_tab(i)

Line 12029: financials_system_params_all fsp,

12025: FROM
12026: zx_update_criteria_results results,
12027: ap_tax_codes_all codes,
12028: ap_tax_recvry_rules_all rec_rules,
12029: financials_system_params_all fsp,
12030: zx_party_tax_profile ptp
12031: WHERE
12032: results.tax_code_id = tax_id_tab(i)
12033: AND results.tax_code_id = codes.tax_id

Line 12130: financials_system_params_all fsp,

12126: FROM
12127: zx_update_criteria_results results,
12128: ap_tax_codes_all codes,
12129: zx_update_criteria_results offset,
12130: financials_system_params_all fsp,
12131: ap_tax_recvry_rules_all rec_rules,
12132: zx_party_tax_profile ptp
12133: WHERE
12134: results.tax_code_id = tax_id_tab(i)

Line 12472: financials_system_params_all fsp,

12468: zx_update_criteria_results results,
12469: ap_tax_codes_all codes,
12470: ar_vat_tax_all_b ar_codes,
12471: ap_tax_recvry_rules_all rec_rules,
12472: financials_system_params_all fsp,
12473: zx_party_tax_profile ptp
12474: WHERE
12475: results.tax_code_id = codes.tax_id
12476: AND codes.enabled_flag = 'N'

Line 12571: financials_system_params_all fsp,

12567: zx_update_criteria_results results,
12568: ap_tax_codes_all codes,
12569: ar_vat_tax_all_b ar_codes,
12570: zx_update_criteria_results offset,
12571: financials_system_params_all fsp,
12572: ap_tax_recvry_rules_all rec_rules,
12573: zx_party_tax_profile ptp
12574: WHERE
12575: results.tax_code_id = codes.tax_id

Line 12896: financials_system_params_all fsp,

12892: zx_update_criteria_results results,
12893: ap_tax_codes_all codes,
12894: ar_vat_tax_all_b ar_codes,
12895: ap_tax_recvry_rules_all rec_rules,
12896: financials_system_params_all fsp,
12897: zx_party_tax_profile ptp
12898: WHERE
12899: results.tax_code_id = codes.tax_id
12900: AND codes.enabled_flag = 'N'

Line 12996: financials_system_params_all fsp,

12992: zx_update_criteria_results results,
12993: ap_tax_codes_all codes,
12994: ar_vat_tax_all_b ar_codes,
12995: zx_update_criteria_results offset,
12996: financials_system_params_all fsp,
12997: ap_tax_recvry_rules_all rec_rules,
12998: zx_party_tax_profile ptp
12999: WHERE
13000: results.tax_code_id = codes.tax_id

Line 13334: financials_system_params_all fsp,

13330: FROM
13331: zx_update_criteria_results results,
13332: ap_tax_codes_all codes,
13333: ap_tax_recvry_rules_all rec_rules,
13334: financials_system_params_all fsp,
13335: zx_party_tax_profile ptp
13336: WHERE
13337: results.tax_code_id = codes.tax_id
13338: AND codes.enabled_flag = 'N'

Line 13434: financials_system_params_all fsp,

13430: FROM
13431: zx_update_criteria_results results,
13432: ap_tax_codes_all codes,
13433: zx_update_criteria_results offset,
13434: financials_system_params_all fsp,
13435: ap_tax_recvry_rules_all rec_rules,
13436: zx_party_tax_profile ptp
13437: WHERE
13438: results.tax_code_id = codes.tax_id

Line 13759: financials_system_params_all fsp,

13755: FROM
13756: zx_update_criteria_results results,
13757: ap_tax_codes_all codes,
13758: ap_tax_recvry_rules_all rec_rules,
13759: financials_system_params_all fsp,
13760: zx_party_tax_profile ptp
13761: WHERE
13762: results.tax_code_id = codes.tax_id
13763: AND codes.enabled_flag = 'N'

Line 13860: financials_system_params_all fsp,

13856: FROM
13857: zx_update_criteria_results results,
13858: ap_tax_codes_all codes,
13859: zx_update_criteria_results offset,
13860: financials_system_params_all fsp,
13861: ap_tax_recvry_rules_all rec_rules,
13862: zx_party_tax_profile ptp
13863: WHERE
13864: results.tax_code_id = codes.tax_id