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 ZX_PARTY_TAX_PROFILE

Line 1307: zx_party_tax_profile ptp

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'
1311: and codes.tax_id = ar_codes.vat_tax_id

Line 1406: zx_party_tax_profile ptp

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
1409: AND results.tax_class = 'INPUT'
1410: AND results.tax_class = offset.tax_class -- Condition added for Bug#7115321

Line 1724: zx_party_tax_profile ptp

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'
1728: and codes.tax_id = ar_codes.vat_tax_id

Line 1824: zx_party_tax_profile ptp

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
1827: AND results.tax_class = 'INPUT'
1828: AND results.tax_class = offset.tax_class -- Condition added for Bug#7115321

Line 2153: zx_party_tax_profile ptp

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'
2157: AND codes.offset_tax_code_id IS NULL

Line 2253: zx_party_tax_profile ptp

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
2256: AND results.tax_class = 'INPUT'
2257: AND results.tax_class = offset.tax_class -- Condition added for Bug#7115321

Line 2577: zx_party_tax_profile ptp

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'
2581: AND codes.offset_tax_code_id IS NULL

Line 2678: zx_party_tax_profile ptp

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
2681: AND results.tax_class = 'INPUT'
2682: AND results.tax_class = offset.tax_class -- Condition added for Bug#7115321

Line 3103: zx_party_tax_profile ptp

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
3107: AND offset.tax_id = ar_codes.vat_tax_id

Line 3416: zx_party_tax_profile ptp

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
3420: AND offset.tax_id = ar_codes.vat_tax_id

Line 3736: zx_party_tax_profile ptp

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'
3740: AND codes.offset_tax_code_id = offset.tax_id

Line 4049: zx_party_tax_profile ptp

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'
4053: AND codes.offset_tax_code_id = offset.tax_id

Line 4457: zx_party_tax_profile ptp

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'
4461: AND offset.tax_id = ar_codes.vat_tax_id

Line 4768: zx_party_tax_profile ptp

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'
4772: AND offset.tax_id = ar_codes.vat_tax_id

Line 5086: zx_party_tax_profile ptp

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'
5090: AND offset.tax_type = 'OFFSET'

Line 5399: zx_party_tax_profile ptp

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'
5403: AND offset.tax_type = 'OFFSET'

Line 6464: zx_party_tax_profile ptp

6460: min(EFFECTIVE_FROM) EFFECTIVE_FROM
6461: FROM
6462: ZX_RATES_B rates,
6463: ap_tax_codes_all codes,
6464: zx_party_tax_profile ptp
6465: WHERE
6466: rates.record_type_code = 'MIGRATED' AND
6467: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) AND
6468: codes.global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES' AND

Line 6597: zx_party_tax_profile ptp

6593: min(EFFECTIVE_FROM) EFFECTIVE_FROM
6594: FROM
6595: ZX_RATES_B rates,
6596: ap_tax_codes_all codes,
6597: zx_party_tax_profile ptp
6598: WHERE
6599: rates.record_type_code = 'MIGRATED' AND
6600: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) AND
6601: codes.global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES' AND

Line 7131: zx_party_tax_profile ptp

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
7135: AND CODES.ORG_ID = PTP.PARTY_ID

Line 7523: zx_party_tax_profile ptp

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
7527: AND CODES.ORG_ID = PTP.PARTY_ID

Line 7925: zx_party_tax_profile ptp

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
7929: AND PTP.PARTY_TYPE_CODE = 'OU'

Line 8350: zx_party_tax_profile ptp

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
8354: AND CODES.ORG_ID = L_ORG_ID

Line 9833: zx_party_tax_profile ptp

9829: FROM
9830: ap_tax_codes_all codes,
9831: zx_rates_b rates,
9832: ap_tax_recvry_rules_all Rules,
9833: zx_party_tax_profile ptp
9834: WHERE
9835: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
9836: AND CODES.TAX_RECOVERY_RULE_ID = RULES.RULE_ID
9837: AND CODES.ORG_ID = PTP.PARTY_ID

Line 9946: zx_party_tax_profile ptp

9942: FROM
9943: ap_tax_codes_all codes,
9944: zx_rates_b rates,
9945: ap_tax_recvry_rules_all Rules,
9946: zx_party_tax_profile ptp
9947: WHERE
9948: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
9949: AND CODES.TAX_RECOVERY_RULE_ID = RULES.RULE_ID
9950: AND CODES.ORG_ID = L_ORG_ID

Line 10127: zx_party_tax_profile ptp

10123: ap_tax_recvry_rates_all AP_RATES,
10124: ZX_RATES_B ZX_RATES,
10125: ZX_RULES_B ZX_RULES,
10126: ZX_CONDITION_GROUPS_B GROUPS,
10127: zx_party_tax_profile ptp
10128: WHERE
10129: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
10130: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID
10131: AND AP_RULES.RULE_ID = AP_RATES.RULE_ID

Line 10283: zx_party_tax_profile ptp

10279: ap_tax_recvry_rates_all AP_RATES,
10280: ZX_RATES_B ZX_RATES,
10281: ZX_RULES_B ZX_RULES,
10282: ZX_CONDITION_GROUPS_B GROUPS,
10283: zx_party_tax_profile ptp
10284: WHERE
10285: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
10286: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID
10287: AND AP_RULES.RULE_ID = AP_RATES.RULE_ID

Line 11079: zx_party_tax_profile ptp

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
11083: and results.tax_class = 'INPUT'

Line 11179: zx_party_tax_profile ptp

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)
11182: AND results.tax_code_id = codes.tax_id
11183: AND results.tax_class = 'INPUT'

Line 11501: zx_party_tax_profile ptp

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
11505: and results.tax_class = 'INPUT'

Line 11602: zx_party_tax_profile ptp

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)
11605: AND results.tax_code_id = codes.tax_id
11606: AND results.tax_class = 'INPUT'

Line 11936: zx_party_tax_profile ptp

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
11940: AND results.tax_class = 'INPUT'

Line 12036: zx_party_tax_profile ptp

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)
12039: AND results.tax_code_id = codes.tax_id
12040: AND results.tax_class = 'INPUT'

Line 12360: zx_party_tax_profile ptp

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
12364: AND results.tax_class = 'INPUT'

Line 12461: zx_party_tax_profile ptp

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)
12464: AND results.tax_code_id = codes.tax_id
12465: AND results.tax_class = 'INPUT'

Line 12802: zx_party_tax_profile ptp

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'
12806: and results.tax_class = 'INPUT'

Line 12901: zx_party_tax_profile ptp

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
12904: AND codes.enabled_flag = 'N'
12905: AND results.tax_class = 'INPUT'

Line 13225: zx_party_tax_profile ptp

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'
13229: and results.tax_class = 'INPUT'

Line 13325: zx_party_tax_profile ptp

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
13328: AND codes.enabled_flag = 'N'
13329: AND results.tax_class = 'INPUT'

Line 13662: zx_party_tax_profile ptp

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'
13666: AND results.tax_class = 'INPUT'

Line 13762: zx_party_tax_profile ptp

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
13765: AND codes.enabled_flag = 'N'
13766: AND results.tax_class = 'INPUT'

Line 14086: zx_party_tax_profile ptp

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'
14090: AND results.tax_class = 'INPUT'

Line 14187: zx_party_tax_profile ptp

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
14190: AND codes.enabled_flag = 'N'
14191: AND results.tax_class = 'INPUT'