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 AP_TAX_CODES_ALL

Line 209: ap_tax_codes_all codes,

205: SET PRIMARY_REC_TYPE_RULE_FLAG = 'Y',
206: PRIMARY_REC_RATE_DET_RULE_FLAG = 'Y'
207: WHERE EXISTS (SELECT 1
208: FROM ZX_RATES_B zx_rates,
209: ap_tax_codes_all codes,
210: ap_tax_recvry_rules_all rules
211: WHERE codes.tax_recovery_rule_id = rules.rule_id
212: AND codes.tax_id = nvl(zx_rates.source_id, zx_rates.tax_rate_id)
213: AND zx_rates.record_type_code = 'MIGRATED'

Line 248: | AP_TAX_CODES_ALL.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE|

244: | DESCRIPTION |
245: | This routine processes AP Tax_setup related fnd_lookups and creates |
246: | appropriate ZX lookups in FND_LOOKUPS. |
247: | For Instance |
248: | AP_TAX_CODES_ALL.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE|
249: | |
250: | SCOPE - PUBLIC |
251: | |
252: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 275: FROM ap_tax_codes_all;

271: /* For VAT_TRANSACTION_TYPE Lookup */
272:
273: /*SELECT count(vat_transaction_type)
274: INTO l_cnt
275: FROM ap_tax_codes_all;
276:
277: IF l_cnt <> 0 THEN*/
278: BEGIN
279: INSERT INTO FND_LOOKUP_VALUES

Line 372: FROM ap_tax_codes_all;

368: /* For TAX_TYPE lookup */
369: /*l_cnt := 0;
370: SELECT count(tax_type)
371: INTO l_cnt
372: FROM ap_tax_codes_all;
373:
374: IF l_cnt <> 0 THEN*/
375:
376: INSERT INTO FND_LOOKUP_VALUES

Line 657: AP_TAX_CODES_ALL

653: SELECT
654: DISTINCT
655: NAME
656: FROM
657: AP_TAX_CODES_ALL
658: )
659:
660: LOOP
661:

Line 741: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE

737: SELECT
738: codes.name LOOKUP_CODE,
739: codes.name MEANING,
740: codes.description DESCRIPTION,
741: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
742: FROM
743: AP_TAX_CODES_ALL codes
744:
745: WHERE

Line 743: AP_TAX_CODES_ALL codes

739: codes.name MEANING,
740: codes.description DESCRIPTION,
741: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
742: FROM
743: AP_TAX_CODES_ALL codes
744:
745: WHERE
746:
747: codes.tax_type <> 'AWT'

Line 782: AP_TAX_CODES_ALL

778: SELECT
779: DISTINCT
780: NAME
781: FROM
782: AP_TAX_CODES_ALL
783: WHERE
784: WEB_ENABLED_FLAG = 'Y'
785: )
786:

Line 868: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE

864: SELECT
865: codes.name LOOKUP_CODE,
866: codes.name MEANING,
867: codes.description DESCRIPTION,
868: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
869: FROM
870: AP_TAX_CODES_ALL codes
871: WHERE
872: codes.tax_type <> 'AWT'

Line 870: AP_TAX_CODES_ALL codes

866: codes.name MEANING,
867: codes.description DESCRIPTION,
868: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
869: FROM
870: AP_TAX_CODES_ALL codes
871: WHERE
872: codes.tax_type <> 'AWT'
873: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
874: AND codes.name = cursor_rec.name

Line 943: AP_TAX_CODES_ALL codes

939: fnd_global.conc_login_id , --program_login_id
940: codes.set_of_books_id , --ledger_id
941: codes.enabled_flag
942: FROM
943: AP_TAX_CODES_ALL codes
944: WHERE
945: codes.TAX_TYPE <> 'AWT'
946: AND codes.TAX_ID = nvl(p_tax_id,codes.TAX_ID)
947: AND NOT EXISTS

Line 1303: ap_tax_codes_all codes,

1299: NULL) NON_REC_ACCOUNT_CCID,
1300: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1301: FROM
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

Line 1401: ap_tax_codes_all codes,

1397: NULL) NON_REC_ACCOUNT_CCID ,
1398: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1399: FROM
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,

Line 1720: ap_tax_codes_all codes,

1716: NULL) NON_REC_ACCOUNT_CCID,
1717: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1718: FROM
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

Line 1819: ap_tax_codes_all codes,

1815: NULL) NON_REC_ACCOUNT_CCID ,
1816: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1817: FROM
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,

Line 2150: ap_tax_codes_all codes,

2146: NULL) NON_REC_ACCOUNT_CCID,
2147: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 2249: ap_tax_codes_all codes,

2245: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
2246:
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

Line 2574: ap_tax_codes_all codes,

2570: NULL) NON_REC_ACCOUNT_CCID,
2571: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 2674: ap_tax_codes_all codes,

2670: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
2671:
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

Line 2738: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

2734: userenv('LANG'),
2735: avtb.description
2736: FROM FND_LANGUAGES L,
2737: ZX_RATES_B RATES,
2738: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
2739: WHERE
2740: L.INSTALLED_FLAG in ('I', 'B')
2741: AND avtb.tax_id = RATES.tax_rate_id
2742: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 3099: ap_tax_codes_all codes,

3095: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
3096:
3097: FROM
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

Line 3101: ap_tax_codes_all offset,

3097: FROM
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

Line 3412: ap_tax_codes_all codes,

3408: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
3409:
3410: FROM
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

Line 3414: ap_tax_codes_all offset,

3410: FROM
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

Line 3733: ap_tax_codes_all codes,

3729: NULL) NON_REC_ACCOUNT_CCID ,--Review1 changes
3730: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 3734: ap_tax_codes_all offset,

3730: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 4046: ap_tax_codes_all codes,

4042: NULL) NON_REC_ACCOUNT_CCID ,--Review1 changes
4043: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 4047: ap_tax_codes_all offset,

4043: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 4100: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

4096: userenv('LANG'),
4097: avtb.description
4098: FROM FND_LANGUAGES L,
4099: ZX_RATES_B RATES,
4100: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
4101: WHERE
4102: L.INSTALLED_FLAG in ('I', 'B')
4103: AND avtb.tax_id = RATES.tax_rate_id
4104: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 4454: ap_tax_codes_all offset,

4450: NULL) NON_REC_ACCOUNT_CCID ,
4451: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
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

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

4462: AND offset.tax_type = 'OFFSET'
4463: AND offset.org_id = fsp.org_id
4464: AND offset.org_id = ptp.party_id
4465: AND ptp.party_type_code ='OU'
4466: AND not exists (select 1 from ap_tax_codes_all where
4467: offset_tax_code_id = offset.tax_id)
4468: --Added following conditions for Sync process
4469: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
4470: --Rerunnability check

Line 4765: ap_tax_codes_all offset,

4761: NULL) NON_REC_ACCOUNT_CCID ,
4762: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
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

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

4774: AND offset.org_id = l_org_id
4775: AND offset.org_id = fsp.org_id
4776: AND offset.org_id = ptp.party_id
4777: AND ptp.party_type_code ='OU'
4778: AND not exists (select 1 from ap_tax_codes_all where
4779: offset_tax_code_id = offset.tax_id)
4780: --Added following conditions for Sync process
4781: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
4782: --Rerunnability check

Line 5084: ap_tax_codes_all offset,

5080: NULL) NON_REC_ACCOUNT_CCID,
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

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

5090: AND offset.tax_type = 'OFFSET'
5091: AND offset.org_id = fsp.org_id
5092: AND offset.org_id = ptp.party_id
5093: AND ptp.party_type_code ='OU'
5094: AND not exists (select 1 from ap_tax_codes_all where
5095: offset_tax_code_id = offset.tax_id)
5096: --Added following conditions for Sync process
5097: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
5098: --BugFix 3605729 added nvl(source_id, in the following condition.

Line 5397: ap_tax_codes_all offset,

5393: NULL) NON_REC_ACCOUNT_CCID,
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

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

5404: AND offset.org_id = l_org_id
5405: AND offset.org_id = fsp.org_id
5406: AND offset.org_id = ptp.party_id
5407: AND ptp.party_type_code ='OU'
5408: AND not exists (select 1 from ap_tax_codes_all where
5409: offset_tax_code_id = offset.tax_id)
5410: --Added following conditions for Sync process
5411: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
5412: --BugFix 3605729 added nvl(source_id, in the following condition.

Line 5449: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

5445: userenv('LANG'),
5446: avtb.description
5447: FROM FND_LANGUAGES L,
5448: ZX_RATES_B RATES,
5449: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
5450: WHERE
5451: L.INSTALLED_FLAG in ('I', 'B')
5452: AND avtb.tax_id = RATES.tax_rate_id
5453: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 5669: ap_tax_codes_all codes,

5665: NULL RECOVERY_RULE_CODE ,
5666: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
5667: 'MIGRATED' RECORD_TYPE_CODE
5668: FROM
5669: ap_tax_codes_all codes,
5670: zx_rates_b rates
5671: WHERE
5672: --BugFix 3480468
5673: rates.default_rec_rate_code is not null

Line 5753: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

5749: userenv('LANG'),
5750: avtb.description
5751: FROM FND_LANGUAGES L,
5752: ZX_RATES_B RATES,
5753: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
5754: WHERE
5755: L.INSTALLED_FLAG in ('I', 'B')
5756: AND avtb.tax_id = RATES.tax_rate_id
5757: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 5910: (select min(start_date) from ap_tax_codes_all

5906: SELECT
5907: DISTINCT
5908: 'STANDARD-'||rates.recovery_rate TAX_RATE_CODE, --Bug 4644762 --Bug4882676
5909: zx_rates.CONTENT_OWNER_ID ,
5910: (select min(start_date) from ap_tax_codes_all
5911: where tax_recovery_rule_id = codes.tax_recovery_rule_id
5912: group by tax_recovery_rule_id) EFFECTIVE_FROM,
5913: NULL EFFECTIVE_TO,
5914: zx_rates.TAX_REGIME_CODE ,

Line 5940: ap_tax_codes_all codes,

5936: NULL RECOVERY_RULE_CODE ,
5937: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
5938: 'MIGRATED' RECORD_TYPE_CODE
5939: FROM
5940: ap_tax_codes_all codes,
5941: zx_rates_b zx_rates,
5942: ap_tax_recvry_rules_all rules,
5943: ap_tax_recvry_rates_all rates
5944: WHERE

Line 6356: FROM ap_tax_codes_all

6352: NumRec := 0;
6353: Begin
6354:
6355: SELECT count(distinct global_attribute1) into NumRec
6356: FROM ap_tax_codes_all
6357: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6358: and global_attribute1 is not null;
6359: EXCEPTION
6360: WHEN OTHERS THEN

Line 6463: ap_tax_codes_all codes,

6459: TAX,
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

Line 6487: FROM ap_tax_codes_all

6483:
6484: MINUS
6485:
6486: SELECT distinct global_attribute1
6487: FROM ap_tax_codes_all
6488: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6489: and global_attribute1 is not null
6490: ) lookups
6491: WHERE NOT EXISTS

Line 6596: ap_tax_codes_all codes,

6592: TAX,
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

Line 6620: FROM ap_tax_codes_all

6616:
6617: MINUS
6618:
6619: SELECT distinct global_attribute1
6620: FROM ap_tax_codes_all
6621: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6622: and global_attribute1 is not null
6623: ) lookups
6624: WHERE NOT EXISTS

Line 6669: ap_tax_codes_all codes,

6665: FROM
6666: FND_LANGUAGES L,
6667: ZX_STATUS_B Status,
6668: JA_LOOKUPS lookups,
6669: ap_tax_codes_all codes,
6670: ZX_RATES_B rates
6671: WHERE
6672: L.INSTALLED_FLAG in ('I', 'B')
6673: AND Status.RECORD_TYPE_CODE = 'MIGRATED'

Line 6919: from zx_rates_b rates, ap_tax_codes_all codes

6915: (select codes.tax_type tax_type_code,
6916: rates.tax_regime_code tax_regime_code,
6917: rates.tax tax,
6918: rates.content_owner_id content_owner_id
6919: from zx_rates_b rates, ap_tax_codes_all codes
6920: where codes.tax_id = rates.source_id --ID Clash
6921: AND rates.tax_class = 'INPUT'
6922: AND rates.record_type_code = 'MIGRATED'
6923: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7068: from zx_rates_b rates, ap_tax_codes_all codes

7064: (select codes.tax_type tax_type_code,
7065: rates.tax_regime_code tax_regime_code,
7066: rates.tax tax,
7067: rates.content_owner_id content_owner_id
7068: from zx_rates_b rates, ap_tax_codes_all codes
7069: where codes.tax_id = rates.source_id --ID Clash
7070: AND rates.tax_class = 'INPUT'
7071: AND rates.record_type_code = 'MIGRATED'
7072: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7127: AP_TAX_CODES_ALL CODES,

7123: -- DECODE(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
7124: NULL DEFAULT_EXCHANGE_RATE_TYPE
7125: FROM
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

Line 7310: from zx_rates_b rates, ap_tax_codes_all codes

7306: (select codes.tax_type tax_type_code,
7307: rates.tax_regime_code tax_regime_code,
7308: rates.tax tax,
7309: rates.content_owner_id content_owner_id
7310: from zx_rates_b rates, ap_tax_codes_all codes
7311: where codes.tax_id = rates.source_id --ID Clash
7312: AND rates.tax_class = 'INPUT'
7313: AND rates.record_type_code = 'MIGRATED'
7314: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7460: from zx_rates_b rates, ap_tax_codes_all codes

7456: (select codes.tax_type tax_type_code,
7457: rates.tax_regime_code tax_regime_code,
7458: rates.tax tax,
7459: rates.content_owner_id content_owner_id
7460: from zx_rates_b rates, ap_tax_codes_all codes
7461: where codes.tax_id = rates.source_id --ID Clash
7462: AND rates.tax_class = 'INPUT'
7463: AND rates.record_type_code = 'MIGRATED'
7464: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7519: AP_TAX_CODES_ALL CODES,

7515: -- DECODE(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
7516: NULL DEFAULT_EXCHANGE_RATE_TYPE
7517: FROM
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

Line 7717: from zx_rates_b rates, ap_tax_codes_all codes

7713: (select codes.tax_type tax_type_code,
7714: rates.tax_regime_code tax_regime_code,
7715: rates.tax tax,
7716: rates.content_owner_id content_owner_id
7717: from zx_rates_b rates, ap_tax_codes_all codes
7718: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
7719: group by rates.tax_regime_code, rates.tax, rates.content_owner_id,codes.tax_type
7720: )
7721: where tax_regime_code = l_tax_regime_code

Line 7865: from zx_rates_b rates, ap_tax_codes_all codes

7861: codes.tax_type tax_type_code,
7862: rates.tax_regime_code tax_regime_code,
7863: rates.tax tax,
7864: rates.content_owner_id content_owner_id
7865: from zx_rates_b rates, ap_tax_codes_all codes
7866: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
7867: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type
7868: )
7869: where tax_regime_code = l_tax_regime_code

Line 7921: AP_TAX_CODES_ALL CODES,

7917: -- decode(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
7918: NULL DEFAULT_EXCHANGE_RATE_TYPE
7919: FROM
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

Line 7997: ap_tax_codes_all,

7993: MINUS
7994: SELECT
7995: lookup_code,lookup_type
7996: FROM
7997: ap_tax_codes_all,
7998: fnd_lookups
7999: WHERE
8000: (lookup_type = 'JGZZ_TAX_ORIGIN'
8001: AND global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'

Line 8142: from zx_rates_b rates, ap_tax_codes_all codes

8138: (select codes.tax_type tax_type_code,
8139: rates.tax_regime_code tax_regime_code,
8140: rates.tax tax,
8141: rates.content_owner_id content_owner_id
8142: from zx_rates_b rates, ap_tax_codes_all codes
8143: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
8144: group by rates.tax_regime_code, rates.tax, rates.content_owner_id,codes.tax_type
8145: )
8146: where tax_regime_code = l_tax_regime_code

Line 8290: from zx_rates_b rates, ap_tax_codes_all codes

8286: codes.tax_type tax_type_code,
8287: rates.tax_regime_code tax_regime_code,
8288: rates.tax tax,
8289: rates.content_owner_id content_owner_id
8290: from zx_rates_b rates, ap_tax_codes_all codes
8291: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
8292: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type
8293: )
8294: where tax_regime_code = l_tax_regime_code

Line 8346: AP_TAX_CODES_ALL CODES,

8342: -- decode(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
8343: NULL DEFAULT_EXCHANGE_RATE_TYPE
8344: FROM
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

Line 8423: ap_tax_codes_all,

8419: MINUS
8420: SELECT
8421: lookup_code,lookup_type
8422: FROM
8423: ap_tax_codes_all,
8424: fnd_lookups
8425: WHERE
8426: (lookup_type = 'JGZZ_TAX_ORIGIN'
8427: AND global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'

Line 8496: ap_tax_codes_all ap_code

8492: FROM
8493: zx_taxes_b taxes,
8494: zx_rates_b rates,
8495: fnd_lookup_values flv,
8496: ap_tax_codes_all ap_code
8497: WHERE
8498: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8499: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8500: AND taxes.TAX = rates.TAX

Line 8546: ap_tax_codes_all ap_code

8542: FROM
8543: zx_taxes_b taxes,
8544: zx_rates_b rates,
8545: fnd_lookup_values flv,
8546: ap_tax_codes_all ap_code
8547: WHERE
8548: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8549: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8550: AND taxes.TAX = rates.TAX

Line 8593: ap_tax_codes_all ap_code

8589: FROM
8590: zx_taxes_b taxes,
8591: zx_rates_b rates,
8592: fnd_lookup_values flv,
8593: ap_tax_codes_all ap_code
8594: WHERE
8595: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8596: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8597: AND taxes.TAX = rates.TAX

Line 8640: ap_tax_codes_all ap_code

8636: FROM
8637: zx_taxes_b taxes,
8638: zx_rates_b rates,
8639: fnd_lookup_values flv,
8640: ap_tax_codes_all ap_code
8641: WHERE
8642: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8643: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8644: AND taxes.TAX = rates.TAX

Line 9830: ap_tax_codes_all codes,

9826: from ap_tax_recvry_rates_all
9827: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9828: ptp.party_tax_profile_id CONTENT_OWNER_ID
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

Line 9943: ap_tax_codes_all codes,

9939: from ap_tax_recvry_rates_all
9940: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9941: ptp.party_tax_profile_id CONTENT_OWNER_ID
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

Line 10009: FROM ap_tax_codes_all codes,

10005: FROM (SELECT DISTINCT b.tax_rule_code
10006: ,b.tax_rule_id
10007: ,rules.description
10008: ,l.LANGUAGE_CODE
10009: FROM ap_tax_codes_all codes,
10010: ap_tax_recvry_rules_all Rules,
10011: zx_rates_b rates,
10012: zx_rules_b b,
10013: fnd_languages L

Line 10121: AP_TAX_CODES_ALL CODES,

10117: THEN 'N'
10118: ELSE 'Y'
10119: END ENABLED_FLAG --ENABLED_FLAG
10120: FROM
10121: AP_TAX_CODES_ALL CODES,
10122: ap_tax_recvry_rules_all AP_RULES,
10123: ap_tax_recvry_rates_all AP_RATES,
10124: ZX_RATES_B ZX_RATES,
10125: ZX_RULES_B ZX_RULES,

Line 10277: AP_TAX_CODES_ALL CODES,

10273: THEN 'N'
10274: ELSE 'Y'
10275: END ENABLED_FLAG --ENABLED_FLAG
10276: FROM
10277: AP_TAX_CODES_ALL CODES,
10278: ap_tax_recvry_rules_all AP_RULES,
10279: ap_tax_recvry_rates_all AP_RATES,
10280: ZX_RATES_B ZX_RATES,
10281: ZX_RULES_B ZX_RULES,

Line 10672: TYPE tax_id_table is table of ap_tax_codes_all.tax_id%TYPE index by BINARY_INTEGER;

10668: |==========================================================================*/
10669:
10670: PROCEDURE migrate_disabled_tax_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
10671:
10672: TYPE tax_id_table is table of ap_tax_codes_all.tax_id%TYPE index by BINARY_INTEGER;
10673: tax_id_tab tax_id_table ;
10674: l_min_start_date date;
10675: l_max_end_date date;
10676:

Line 10702: from ap_tax_codes_all a

10698: select aptax2.tax_id tax_id
10699: from
10700: (
10701: select DISTINCT org_id,set_of_books_id,name
10702: from ap_tax_codes_all a
10703: where a.enabled_flag = 'N'
10704: and exists
10705: (
10706: select 1 from ap_tax_codes_all b

Line 10706: select 1 from ap_tax_codes_all b

10702: from ap_tax_codes_all a
10703: where a.enabled_flag = 'N'
10704: and exists
10705: (
10706: select 1 from ap_tax_codes_all b
10707: where a.org_id = b.org_id
10708: and a.set_of_books_id = b.set_of_books_id
10709: and a.name = b.name
10710: and

Line 10725: (select c.org_id,c.set_of_books_id,c.name ,count(c.org_id) from ap_tax_codes_all c

10721: )
10722: and b.enabled_flag = 'N'
10723: )
10724: and exists
10725: (select c.org_id,c.set_of_books_id,c.name ,count(c.org_id) from ap_tax_codes_all c
10726: where a.org_id = c.org_id
10727: and a.set_of_books_id = c.set_of_books_id
10728: and a.name = c.name
10729: group by c.org_id,c.set_of_books_id,c.name

Line 10733: ap_tax_codes_all aptax2

10729: group by c.org_id,c.set_of_books_id,c.name
10730: having count(c.org_id) > 1)
10731: )
10732: aptax1,
10733: ap_tax_codes_all aptax2
10734: where
10735: aptax1.org_id = aptax2.org_id
10736: and aptax1.set_of_books_id = aptax2.set_of_books_id
10737: and aptax1. name = aptax2. name

Line 11075: ap_tax_codes_all codes,

11071: NULL) NON_REC_ACCOUNT_CCID,
11072: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11073: FROM
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

Line 11174: ap_tax_codes_all codes,

11170: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11171:
11172: FROM
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,

Line 11497: ap_tax_codes_all codes,

11493: NULL) NON_REC_ACCOUNT_CCID,
11494: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11495: FROM
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

Line 11597: ap_tax_codes_all codes,

11593: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11594:
11595: FROM
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,

Line 11933: ap_tax_codes_all codes,

11929: NULL) NON_REC_ACCOUNT_CCID,
11930: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 12032: ap_tax_codes_all codes,

12028: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12029:
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

Line 12357: ap_tax_codes_all codes,

12353: NULL) NON_REC_ACCOUNT_CCID,
12354: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 12457: ap_tax_codes_all codes,

12453: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12454:
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

Line 12798: ap_tax_codes_all codes,

12794: NULL) NON_REC_ACCOUNT_CCID,
12795: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12796: FROM
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

Line 12896: ap_tax_codes_all codes,

12892: NULL) NON_REC_ACCOUNT_CCID,
12893: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12894: FROM
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,

Line 13221: ap_tax_codes_all codes,

13217: NULL) NON_REC_ACCOUNT_CCID,
13218: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13219: FROM
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

Line 13320: ap_tax_codes_all codes,

13316: NULL) NON_REC_ACCOUNT_CCID,
13317: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13318: FROM
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,

Line 13659: ap_tax_codes_all codes,

13655: NULL) NON_REC_ACCOUNT_CCID,
13656: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 13758: ap_tax_codes_all codes,

13754: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13755:
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

Line 14083: ap_tax_codes_all codes,

14079: NULL) NON_REC_ACCOUNT_CCID,
14080: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
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

Line 14183: ap_tax_codes_all codes,

14179: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
14180:
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

Line 14246: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

14242: userenv('LANG'),
14243: avtb.description
14244: FROM FND_LANGUAGES L,
14245: ZX_RATES_B RATES,
14246: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
14247: WHERE
14248: L.INSTALLED_FLAG in ('I', 'B')
14249: AND avtb.tax_id = RATES.tax_rate_id
14250: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 14370: from ap_tax_codes_all,

14366: BEGIN
14367:
14368: SELECT 'Y' INTO ID_CLASH FROM DUAL
14369: WHERE EXISTS (select 1
14370: from ap_tax_codes_all,
14371: ar_vat_tax_all_b
14372: where tax_id = vat_tax_id);
14373: EXCEPTION
14374: WHEN no_data_found THEN