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 1291: zx_party_tax_profile ptp

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

Line 1391: zx_party_tax_profile ptp

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

Line 1712: zx_party_tax_profile ptp

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

Line 1813: zx_party_tax_profile ptp

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

Line 2142: zx_party_tax_profile ptp

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

Line 2243: zx_party_tax_profile ptp

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

Line 2567: zx_party_tax_profile ptp

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

Line 2669: zx_party_tax_profile ptp

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

Line 3087: zx_party_tax_profile ptp

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

Line 3398: zx_party_tax_profile ptp

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

Line 3716: zx_party_tax_profile ptp

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

Line 4027: zx_party_tax_profile ptp

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

Line 4433: zx_party_tax_profile ptp

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

Line 4742: zx_party_tax_profile ptp

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

Line 5058: zx_party_tax_profile ptp

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

Line 5369: zx_party_tax_profile ptp

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

Line 6433: zx_party_tax_profile ptp

6429: min(EFFECTIVE_FROM) EFFECTIVE_FROM
6430: FROM
6431: ZX_RATES_B rates,
6432: ap_tax_codes_all codes,
6433: zx_party_tax_profile ptp
6434: WHERE
6435: rates.record_type_code = 'MIGRATED' AND
6436: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) AND
6437: codes.global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES' AND

Line 6566: zx_party_tax_profile ptp

6562: min(EFFECTIVE_FROM) EFFECTIVE_FROM
6563: FROM
6564: ZX_RATES_B rates,
6565: ap_tax_codes_all codes,
6566: zx_party_tax_profile ptp
6567: WHERE
6568: rates.record_type_code = 'MIGRATED' AND
6569: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) AND
6570: codes.global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES' AND

Line 7105: zx_party_tax_profile ptp

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

Line 7501: zx_party_tax_profile ptp

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

Line 7903: zx_party_tax_profile ptp

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

Line 8328: zx_party_tax_profile ptp

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

Line 9537: zx_party_tax_profile ptp

9533: FROM
9534: ap_tax_codes_all codes,
9535: zx_rates_b rates,
9536: ap_tax_recvry_rules_all Rules,
9537: zx_party_tax_profile ptp
9538: WHERE
9539: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
9540: AND CODES.TAX_RECOVERY_RULE_ID = RULES.RULE_ID
9541: AND CODES.ORG_ID = PTP.PARTY_ID

Line 9653: zx_party_tax_profile ptp

9649: FROM
9650: ap_tax_codes_all codes,
9651: zx_rates_b rates,
9652: ap_tax_recvry_rules_all Rules,
9653: zx_party_tax_profile ptp
9654: WHERE
9655: CODES.TAX_ID = NVL(RATES.SOURCE_ID, RATES.TAX_RATE_ID)
9656: AND CODES.TAX_RECOVERY_RULE_ID = RULES.RULE_ID
9657: AND CODES.ORG_ID = L_ORG_ID

Line 9830: zx_party_tax_profile ptp

9826: ap_tax_recvry_rates_all AP_RATES,
9827: ZX_RATES_B ZX_RATES,
9828: ZX_RULES_B ZX_RULES,
9829: ZX_CONDITION_GROUPS_B GROUPS,
9830: zx_party_tax_profile ptp
9831: WHERE
9832: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
9833: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID
9834: AND AP_RULES.RULE_ID = AP_RATES.RULE_ID

Line 9969: zx_party_tax_profile ptp

9965: ap_tax_recvry_rates_all AP_RATES,
9966: ZX_RATES_B ZX_RATES,
9967: ZX_RULES_B ZX_RULES,
9968: ZX_CONDITION_GROUPS_B GROUPS,
9969: zx_party_tax_profile ptp
9970: WHERE
9971: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
9972: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID
9973: AND AP_RULES.RULE_ID = AP_RATES.RULE_ID

Line 10746: zx_party_tax_profile ptp

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

Line 10847: zx_party_tax_profile ptp

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

Line 11169: zx_party_tax_profile ptp

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

Line 11271: zx_party_tax_profile ptp

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

Line 11605: zx_party_tax_profile ptp

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

Line 11706: zx_party_tax_profile ptp

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

Line 12030: zx_party_tax_profile ptp

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

Line 12132: zx_party_tax_profile ptp

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

Line 12473: zx_party_tax_profile ptp

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

Line 12573: zx_party_tax_profile ptp

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

Line 12897: zx_party_tax_profile ptp

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

Line 12998: zx_party_tax_profile ptp

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

Line 13335: zx_party_tax_profile ptp

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

Line 13436: zx_party_tax_profile ptp

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

Line 13760: zx_party_tax_profile ptp

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

Line 13862: zx_party_tax_profile ptp

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