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 1306: financials_system_params_all fsp,

1302: zx_update_criteria_results results,
1303: ap_tax_codes_all codes,
1304: ar_vat_tax_all_b ar_codes,
1305: ap_tax_recvry_rules_all rec_rules,
1306: financials_system_params_all fsp,
1307: zx_party_tax_profile ptp
1308: WHERE
1309: results.tax_code_id = codes.tax_id
1310: and results.tax_class = 'INPUT'

Line 1404: financials_system_params_all fsp,

1400: zx_update_criteria_results results,
1401: ap_tax_codes_all codes,
1402: ar_vat_tax_all_b ar_codes,
1403: zx_update_criteria_results offset,
1404: financials_system_params_all fsp,
1405: ap_tax_recvry_rules_all rec_rules,
1406: zx_party_tax_profile ptp
1407: WHERE
1408: results.tax_code_id = codes.tax_id

Line 1723: financials_system_params_all fsp,

1719: zx_update_criteria_results results,
1720: ap_tax_codes_all codes,
1721: ar_vat_tax_all_b ar_codes,
1722: ap_tax_recvry_rules_all rec_rules,
1723: financials_system_params_all fsp,
1724: zx_party_tax_profile ptp
1725: WHERE
1726: results.tax_code_id = codes.tax_id
1727: and results.tax_class = 'INPUT'

Line 1822: financials_system_params_all fsp,

1818: zx_update_criteria_results results,
1819: ap_tax_codes_all codes,
1820: ar_vat_tax_all_b ar_codes,
1821: zx_update_criteria_results offset,
1822: financials_system_params_all fsp,
1823: ap_tax_recvry_rules_all rec_rules,
1824: zx_party_tax_profile ptp
1825: WHERE
1826: results.tax_code_id = codes.tax_id

Line 2152: financials_system_params_all fsp,

2148: FROM
2149: zx_update_criteria_results results,
2150: ap_tax_codes_all codes,
2151: ap_tax_recvry_rules_all rec_rules,
2152: financials_system_params_all fsp,
2153: zx_party_tax_profile ptp
2154: WHERE
2155: results.tax_code_id = codes.tax_id
2156: AND results.tax_class = 'INPUT'

Line 2251: financials_system_params_all fsp,

2247: FROM
2248: zx_update_criteria_results results,
2249: ap_tax_codes_all codes,
2250: zx_update_criteria_results offset,
2251: financials_system_params_all fsp,
2252: ap_tax_recvry_rules_all rec_rules,
2253: zx_party_tax_profile ptp
2254: WHERE
2255: results.tax_code_id = codes.tax_id

Line 2576: financials_system_params_all fsp,

2572: FROM
2573: zx_update_criteria_results results,
2574: ap_tax_codes_all codes,
2575: ap_tax_recvry_rules_all rec_rules,
2576: financials_system_params_all fsp,
2577: zx_party_tax_profile ptp
2578: WHERE
2579: results.tax_code_id = codes.tax_id
2580: AND results.tax_class = 'INPUT'

Line 2676: financials_system_params_all fsp,

2672: FROM
2673: zx_update_criteria_results results,
2674: ap_tax_codes_all codes,
2675: zx_update_criteria_results offset,
2676: financials_system_params_all fsp,
2677: ap_tax_recvry_rules_all rec_rules,
2678: zx_party_tax_profile ptp
2679: WHERE
2680: results.tax_code_id = codes.tax_id

Line 3102: financials_system_params_all fsp,

3098: zx_update_criteria_results results,
3099: ap_tax_codes_all codes,
3100: ar_vat_tax_all_b ar_codes,
3101: ap_tax_codes_all offset,
3102: financials_system_params_all fsp,
3103: zx_party_tax_profile ptp
3104: WHERE
3105: results.tax_code_id = codes.offset_tax_code_id
3106: AND codes.offset_tax_code_id = offset.tax_id

Line 3415: financials_system_params_all fsp,

3411: zx_update_criteria_results results,
3412: ap_tax_codes_all codes,
3413: ar_vat_tax_all_b ar_codes,
3414: ap_tax_codes_all offset,
3415: financials_system_params_all fsp,
3416: zx_party_tax_profile ptp
3417: WHERE
3418: results.tax_code_id = codes.offset_tax_code_id
3419: AND codes.offset_tax_code_id = offset.tax_id

Line 3735: financials_system_params_all fsp,

3731: FROM
3732: zx_update_criteria_results results,
3733: ap_tax_codes_all codes,
3734: ap_tax_codes_all offset,
3735: financials_system_params_all fsp,
3736: zx_party_tax_profile ptp
3737: WHERE
3738: results.tax_code_id = codes.offset_tax_code_id
3739: AND results.tax_class = 'INPUT'

Line 4048: financials_system_params_all fsp,

4044: FROM
4045: zx_update_criteria_results results,
4046: ap_tax_codes_all codes,
4047: ap_tax_codes_all offset,
4048: financials_system_params_all fsp,
4049: zx_party_tax_profile ptp
4050: WHERE
4051: results.tax_code_id = codes.offset_tax_code_id
4052: AND results.tax_class = 'INPUT'

Line 4456: financials_system_params_all fsp,

4452: FROM
4453: zx_update_criteria_results results,
4454: ap_tax_codes_all offset,
4455: ar_vat_tax_all_b ar_codes,
4456: financials_system_params_all fsp,
4457: zx_party_tax_profile ptp
4458: WHERE
4459: results.tax_code_id = offset.tax_id
4460: AND results.tax_class = 'INPUT'

Line 4767: financials_system_params_all fsp,

4763: FROM
4764: zx_update_criteria_results results,
4765: ap_tax_codes_all offset,
4766: ar_vat_tax_all_b ar_codes,
4767: financials_system_params_all fsp,
4768: zx_party_tax_profile ptp
4769: WHERE
4770: results.tax_code_id = offset.tax_id
4771: AND results.tax_class = 'INPUT'

Line 5085: financials_system_params_all fsp,

5081: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
5082: FROM
5083: zx_update_criteria_results results,
5084: ap_tax_codes_all offset,
5085: financials_system_params_all fsp,
5086: zx_party_tax_profile ptp
5087: WHERE
5088: results.tax_code_id = offset.tax_id
5089: AND results.tax_class = 'INPUT'

Line 5398: financials_system_params_all fsp,

5394: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
5395: FROM
5396: zx_update_criteria_results results,
5397: ap_tax_codes_all offset,
5398: financials_system_params_all fsp,
5399: zx_party_tax_profile ptp
5400: WHERE
5401: results.tax_code_id = offset.tax_id
5402: AND results.tax_class = 'INPUT'

Line 7130: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

7126: ZX_RATES_B RATES,
7127: AP_TAX_CODES_ALL CODES,
7128: GL_SETS_OF_BOOKS SOB,
7129: AP_SYSTEM_PARAMETERS_ALL ASP,
7130: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
7131: zx_party_tax_profile ptp
7132: WHERE
7133: CODES.TAX_ID = RATES.SOURCE_ID --No need for the nvl check
7134: AND RATES.TAX_CLASS = 'INPUT' --Creating only INPUT Taxes

Line 7522: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

7518: ZX_RATES_B RATES,
7519: AP_TAX_CODES_ALL CODES,
7520: GL_SETS_OF_BOOKS SOB,
7521: AP_SYSTEM_PARAMETERS_ALL ASP,
7522: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
7523: zx_party_tax_profile ptp
7524: WHERE
7525: CODES.TAX_ID = RATES.SOURCE_ID --No need for the nvl check
7526: AND RATES.TAX_CLASS = 'INPUT' --Creating only INPUT Taxes

Line 7924: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

7920: ZX_RATES_B RATES,
7921: AP_TAX_CODES_ALL CODES,
7922: GL_SETS_OF_BOOKS SOB,
7923: AP_SYSTEM_PARAMETERS_ALL ASP,
7924: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
7925: zx_party_tax_profile ptp
7926: WHERE
7927: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
7928: AND CODES.ORG_ID = PTP.PARTY_ID

Line 8349: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

8345: ZX_RATES_B RATES,
8346: AP_TAX_CODES_ALL CODES,
8347: GL_SETS_OF_BOOKS SOB,
8348: AP_SYSTEM_PARAMETERS_ALL ASP,
8349: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
8350: zx_party_tax_profile ptp
8351: WHERE
8352: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
8353: AND CODES.ORG_ID = PTP.PARTY_ID

Line 9218: financials_system_params_all FSP,

9214: FROM
9215: ap_tax_recvry_rules_all RULES,
9216: --ap_system_parameters_all ASP,
9217: gl_sets_of_books SOB,
9218: financials_system_params_all FSP,
9219: ap_tax_recvry_rates_all RATES
9220: WHERE
9221: rules.org_id = fsp.org_id
9222: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 9350: financials_system_params_all FSP,

9346: FROM
9347: ap_tax_recvry_rules_all RULES,
9348: --ap_system_parameters_all ASP,
9349: gl_sets_of_books SOB,
9350: financials_system_params_all FSP,
9351: ap_tax_recvry_rates_all RATES
9352: WHERE
9353: rules.org_id = fsp.org_id
9354: AND rules.org_id = l_org_id

Line 9488: financials_system_params_all FSP,

9484: FROM
9485: ap_tax_recvry_rules_all RULES,
9486: --ap_system_parameters_all ASP,
9487: gl_sets_of_books SOB,
9488: financials_system_params_all FSP,
9489: ap_tax_recvry_rates_all RATES
9490: WHERE
9491: rules.org_id = fsp.org_id
9492: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 9622: financials_system_params_all FSP,

9618: FROM
9619: ap_tax_recvry_rules_all RULES,
9620: --ap_system_parameters_all ASP,
9621: gl_sets_of_books SOB,
9622: financials_system_params_all FSP,
9623: ap_tax_recvry_rates_all RATES
9624: WHERE
9625: rules.org_id = fsp.org_id
9626: AND rules.org_id = l_org_id

Line 11078: financials_system_params_all fsp,

11074: zx_update_criteria_results results,
11075: ap_tax_codes_all codes,
11076: ar_vat_tax_all_b ar_codes,
11077: ap_tax_recvry_rules_all rec_rules,
11078: financials_system_params_all fsp,
11079: zx_party_tax_profile ptp
11080: WHERE
11081: results.tax_code_id = tax_id_tab(i)
11082: and results.tax_code_id = codes.tax_id

Line 11177: financials_system_params_all fsp,

11173: zx_update_criteria_results results,
11174: ap_tax_codes_all codes,
11175: ar_vat_tax_all_b ar_codes,
11176: zx_update_criteria_results offset,
11177: financials_system_params_all fsp,
11178: ap_tax_recvry_rules_all rec_rules,
11179: zx_party_tax_profile ptp
11180: WHERE
11181: results.tax_code_id = tax_id_tab(i)

Line 11500: financials_system_params_all fsp,

11496: zx_update_criteria_results results,
11497: ap_tax_codes_all codes,
11498: ar_vat_tax_all_b ar_codes,
11499: ap_tax_recvry_rules_all rec_rules,
11500: financials_system_params_all fsp,
11501: zx_party_tax_profile ptp
11502: WHERE
11503: results.tax_code_id = tax_id_tab(i)
11504: and results.tax_code_id = codes.tax_id

Line 11600: financials_system_params_all fsp,

11596: zx_update_criteria_results results,
11597: ap_tax_codes_all codes,
11598: ar_vat_tax_all_b ar_codes,
11599: zx_update_criteria_results offset,
11600: financials_system_params_all fsp,
11601: ap_tax_recvry_rules_all rec_rules,
11602: zx_party_tax_profile ptp
11603: WHERE
11604: results.tax_code_id = tax_id_tab(i)

Line 11935: financials_system_params_all fsp,

11931: FROM
11932: zx_update_criteria_results results,
11933: ap_tax_codes_all codes,
11934: ap_tax_recvry_rules_all rec_rules,
11935: financials_system_params_all fsp,
11936: zx_party_tax_profile ptp
11937: WHERE
11938: results.tax_code_id = tax_id_tab(i)
11939: AND results.tax_code_id = codes.tax_id

Line 12034: financials_system_params_all fsp,

12030: FROM
12031: zx_update_criteria_results results,
12032: ap_tax_codes_all codes,
12033: zx_update_criteria_results offset,
12034: financials_system_params_all fsp,
12035: ap_tax_recvry_rules_all rec_rules,
12036: zx_party_tax_profile ptp
12037: WHERE
12038: results.tax_code_id = tax_id_tab(i)

Line 12359: financials_system_params_all fsp,

12355: FROM
12356: zx_update_criteria_results results,
12357: ap_tax_codes_all codes,
12358: ap_tax_recvry_rules_all rec_rules,
12359: financials_system_params_all fsp,
12360: zx_party_tax_profile ptp
12361: WHERE
12362: results.tax_code_id = tax_id_tab(i)
12363: AND results.tax_code_id = codes.tax_id

Line 12459: financials_system_params_all fsp,

12455: FROM
12456: zx_update_criteria_results results,
12457: ap_tax_codes_all codes,
12458: zx_update_criteria_results offset,
12459: financials_system_params_all fsp,
12460: ap_tax_recvry_rules_all rec_rules,
12461: zx_party_tax_profile ptp
12462: WHERE
12463: results.tax_code_id = tax_id_tab(i)

Line 12801: financials_system_params_all fsp,

12797: zx_update_criteria_results results,
12798: ap_tax_codes_all codes,
12799: ar_vat_tax_all_b ar_codes,
12800: ap_tax_recvry_rules_all rec_rules,
12801: financials_system_params_all fsp,
12802: zx_party_tax_profile ptp
12803: WHERE
12804: results.tax_code_id = codes.tax_id
12805: AND codes.enabled_flag = 'N'

Line 12899: financials_system_params_all fsp,

12895: zx_update_criteria_results results,
12896: ap_tax_codes_all codes,
12897: ar_vat_tax_all_b ar_codes,
12898: zx_update_criteria_results offset,
12899: financials_system_params_all fsp,
12900: ap_tax_recvry_rules_all rec_rules,
12901: zx_party_tax_profile ptp
12902: WHERE
12903: results.tax_code_id = codes.tax_id

Line 13224: financials_system_params_all fsp,

13220: zx_update_criteria_results results,
13221: ap_tax_codes_all codes,
13222: ar_vat_tax_all_b ar_codes,
13223: ap_tax_recvry_rules_all rec_rules,
13224: financials_system_params_all fsp,
13225: zx_party_tax_profile ptp
13226: WHERE
13227: results.tax_code_id = codes.tax_id
13228: AND codes.enabled_flag = 'N'

Line 13323: financials_system_params_all fsp,

13319: zx_update_criteria_results results,
13320: ap_tax_codes_all codes,
13321: ar_vat_tax_all_b ar_codes,
13322: zx_update_criteria_results offset,
13323: financials_system_params_all fsp,
13324: ap_tax_recvry_rules_all rec_rules,
13325: zx_party_tax_profile ptp
13326: WHERE
13327: results.tax_code_id = codes.tax_id

Line 13661: financials_system_params_all fsp,

13657: FROM
13658: zx_update_criteria_results results,
13659: ap_tax_codes_all codes,
13660: ap_tax_recvry_rules_all rec_rules,
13661: financials_system_params_all fsp,
13662: zx_party_tax_profile ptp
13663: WHERE
13664: results.tax_code_id = codes.tax_id
13665: AND codes.enabled_flag = 'N'

Line 13760: financials_system_params_all fsp,

13756: FROM
13757: zx_update_criteria_results results,
13758: ap_tax_codes_all codes,
13759: zx_update_criteria_results offset,
13760: financials_system_params_all fsp,
13761: ap_tax_recvry_rules_all rec_rules,
13762: zx_party_tax_profile ptp
13763: WHERE
13764: results.tax_code_id = codes.tax_id

Line 14085: financials_system_params_all fsp,

14081: FROM
14082: zx_update_criteria_results results,
14083: ap_tax_codes_all codes,
14084: ap_tax_recvry_rules_all rec_rules,
14085: financials_system_params_all fsp,
14086: zx_party_tax_profile ptp
14087: WHERE
14088: results.tax_code_id = codes.tax_id
14089: AND codes.enabled_flag = 'N'

Line 14185: financials_system_params_all fsp,

14181: FROM
14182: zx_update_criteria_results results,
14183: ap_tax_codes_all codes,
14184: zx_update_criteria_results offset,
14185: financials_system_params_all fsp,
14186: ap_tax_recvry_rules_all rec_rules,
14187: zx_party_tax_profile ptp
14188: WHERE
14189: results.tax_code_id = codes.tax_id