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 224: | AP_TAX_CODES_ALL.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE|

220: | DESCRIPTION |
221: | This routine processes AP Tax_setup related fnd_lookups and creates |
222: | appropriate ZX lookups in FND_LOOKUPS. |
223: | For Instance |
224: | AP_TAX_CODES_ALL.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE|
225: | |
226: | SCOPE - PUBLIC |
227: | |
228: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 251: FROM ap_tax_codes_all;

247: /* For VAT_TRANSACTION_TYPE Lookup */
248:
249: /*SELECT count(vat_transaction_type)
250: INTO l_cnt
251: FROM ap_tax_codes_all;
252:
253: IF l_cnt <> 0 THEN*/
254: BEGIN
255: INSERT INTO FND_LOOKUP_VALUES

Line 348: FROM ap_tax_codes_all;

344: /* For TAX_TYPE lookup */
345: /*l_cnt := 0;
346: SELECT count(tax_type)
347: INTO l_cnt
348: FROM ap_tax_codes_all;
349:
350: IF l_cnt <> 0 THEN*/
351:
352: INSERT INTO FND_LOOKUP_VALUES

Line 633: AP_TAX_CODES_ALL

629: SELECT
630: DISTINCT
631: NAME
632: FROM
633: AP_TAX_CODES_ALL
634: )
635:
636: LOOP
637:

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

713: SELECT
714: codes.name LOOKUP_CODE,
715: codes.name MEANING,
716: codes.description DESCRIPTION,
717: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
718: FROM
719: AP_TAX_CODES_ALL codes
720:
721: WHERE

Line 719: AP_TAX_CODES_ALL codes

715: codes.name MEANING,
716: codes.description DESCRIPTION,
717: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
718: FROM
719: AP_TAX_CODES_ALL codes
720:
721: WHERE
722:
723: codes.tax_type <> 'AWT'

Line 758: AP_TAX_CODES_ALL

754: SELECT
755: DISTINCT
756: NAME
757: FROM
758: AP_TAX_CODES_ALL
759: WHERE
760: WEB_ENABLED_FLAG = 'Y'
761: )
762:

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

840: SELECT
841: codes.name LOOKUP_CODE,
842: codes.name MEANING,
843: codes.description DESCRIPTION,
844: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
845: FROM
846: AP_TAX_CODES_ALL codes
847:
848: WHERE

Line 846: AP_TAX_CODES_ALL codes

842: codes.name MEANING,
843: codes.description DESCRIPTION,
844: (select min(codes.start_date) from ap_tax_codes_all where codes.name = cursor_rec.name) START_DATE_ACTIVE
845: FROM
846: AP_TAX_CODES_ALL codes
847:
848: WHERE
849:
850: codes.tax_type <> 'AWT'

Line 924: AP_TAX_CODES_ALL codes

920: fnd_global.conc_login_id , --program_login_id
921: codes.set_of_books_id , --ledger_id
922: codes.enabled_flag
923: FROM
924: AP_TAX_CODES_ALL codes
925: WHERE
926: codes.TAX_TYPE <> 'AWT'
927: AND codes.TAX_ID = nvl(p_tax_id,codes.TAX_ID)
928: AND NOT EXISTS

Line 1287: ap_tax_codes_all codes,

1283: NULL) NON_REC_ACCOUNT_CCID,
1284: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1285: FROM
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

Line 1386: ap_tax_codes_all codes,

1382: NULL) NON_REC_ACCOUNT_CCID ,
1383: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1384: FROM
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,

Line 1708: ap_tax_codes_all codes,

1704: NULL) NON_REC_ACCOUNT_CCID,
1705: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1706: FROM
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

Line 1808: ap_tax_codes_all codes,

1804: NULL) NON_REC_ACCOUNT_CCID ,
1805: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1806: FROM
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,

Line 2139: ap_tax_codes_all codes,

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

Line 2239: ap_tax_codes_all codes,

2235: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
2236:
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

Line 2564: ap_tax_codes_all codes,

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

Line 2665: ap_tax_codes_all codes,

2661: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
2662:
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

Line 3083: ap_tax_codes_all codes,

3079: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
3080:
3081: FROM
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

Line 3085: ap_tax_codes_all offset,

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

Line 3394: ap_tax_codes_all codes,

3390: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
3391:
3392: FROM
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

Line 3396: ap_tax_codes_all offset,

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

Line 3713: ap_tax_codes_all codes,

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

Line 3714: ap_tax_codes_all offset,

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

Line 4024: ap_tax_codes_all codes,

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

Line 4025: ap_tax_codes_all offset,

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

Line 4430: ap_tax_codes_all offset,

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

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

4438: AND offset.tax_type = 'OFFSET'
4439: AND offset.org_id = fsp.org_id
4440: AND offset.org_id = ptp.party_id
4441: AND ptp.party_type_code ='OU'
4442: AND not exists (select 1 from ap_tax_codes_all where
4443: offset_tax_code_id = offset.tax_id)
4444: --Added following conditions for Sync process
4445: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
4446: --Rerunnability check

Line 4739: ap_tax_codes_all offset,

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

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

4748: AND offset.org_id = l_org_id
4749: AND offset.org_id = fsp.org_id
4750: AND offset.org_id = ptp.party_id
4751: AND ptp.party_type_code ='OU'
4752: AND not exists (select 1 from ap_tax_codes_all where
4753: offset_tax_code_id = offset.tax_id)
4754: --Added following conditions for Sync process
4755: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
4756: --Rerunnability check

Line 5056: ap_tax_codes_all offset,

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

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

5062: AND offset.tax_type = 'OFFSET'
5063: AND offset.org_id = fsp.org_id
5064: AND offset.org_id = ptp.party_id
5065: AND ptp.party_type_code ='OU'
5066: AND not exists (select 1 from ap_tax_codes_all where
5067: offset_tax_code_id = offset.tax_id)
5068: --Added following conditions for Sync process
5069: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
5070: --BugFix 3605729 added nvl(source_id, in the following condition.

Line 5367: ap_tax_codes_all offset,

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

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

5374: AND offset.org_id = l_org_id
5375: AND offset.org_id = fsp.org_id
5376: AND offset.org_id = ptp.party_id
5377: AND ptp.party_type_code ='OU'
5378: AND not exists (select 1 from ap_tax_codes_all where
5379: offset_tax_code_id = offset.tax_id)
5380: --Added following conditions for Sync process
5381: AND offset.tax_id = nvl(p_tax_id,offset.tax_id)
5382: --BugFix 3605729 added nvl(source_id, in the following condition.

Line 5639: ap_tax_codes_all codes,

5635: NULL RECOVERY_RULE_CODE ,
5636: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
5637: 'MIGRATED' RECORD_TYPE_CODE
5638: FROM
5639: ap_tax_codes_all codes,
5640: zx_rates_b rates
5641: WHERE
5642: --BugFix 3480468
5643: rates.default_rec_rate_code is not null

Line 5879: (select min(start_date) from ap_tax_codes_all

5875: SELECT
5876: DISTINCT
5877: 'STANDARD-'||rates.recovery_rate TAX_RATE_CODE, --Bug 4644762 --Bug4882676
5878: zx_rates.CONTENT_OWNER_ID ,
5879: (select min(start_date) from ap_tax_codes_all
5880: where tax_recovery_rule_id = codes.tax_recovery_rule_id
5881: group by tax_recovery_rule_id) EFFECTIVE_FROM,
5882: NULL EFFECTIVE_TO,
5883: zx_rates.TAX_REGIME_CODE ,

Line 5909: ap_tax_codes_all codes,

5905: NULL RECOVERY_RULE_CODE ,
5906: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
5907: 'MIGRATED' RECORD_TYPE_CODE
5908: FROM
5909: ap_tax_codes_all codes,
5910: zx_rates_b zx_rates,
5911: ap_tax_recvry_rules_all rules,
5912: ap_tax_recvry_rates_all rates
5913: WHERE

Line 6325: FROM ap_tax_codes_all

6321: NumRec := 0;
6322: Begin
6323:
6324: SELECT count(distinct global_attribute1) into NumRec
6325: FROM ap_tax_codes_all
6326: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6327: and global_attribute1 is not null;
6328: EXCEPTION
6329: WHEN OTHERS THEN

Line 6432: ap_tax_codes_all codes,

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

Line 6456: FROM ap_tax_codes_all

6452:
6453: MINUS
6454:
6455: SELECT distinct global_attribute1
6456: FROM ap_tax_codes_all
6457: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6458: and global_attribute1 is not null
6459: ) lookups
6460: WHERE NOT EXISTS

Line 6565: ap_tax_codes_all codes,

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

Line 6589: FROM ap_tax_codes_all

6585:
6586: MINUS
6587:
6588: SELECT distinct global_attribute1
6589: FROM ap_tax_codes_all
6590: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6591: and global_attribute1 is not null
6592: ) lookups
6593: WHERE NOT EXISTS

Line 6638: ap_tax_codes_all codes,

6634: FROM
6635: FND_LANGUAGES L,
6636: ZX_STATUS_B Status,
6637: JA_LOOKUPS lookups,
6638: ap_tax_codes_all codes,
6639: ZX_RATES_B rates
6640: WHERE
6641: L.INSTALLED_FLAG in ('I', 'B')
6642: AND Status.RECORD_TYPE_CODE = 'MIGRATED'

Line 6890: from zx_rates_b rates, ap_tax_codes_all codes

6886: codes.tax_type tax_type_code,
6887: rates.tax_regime_code tax_regime_code,
6888: rates.tax tax,
6889: rates.content_owner_id content_owner_id
6890: from zx_rates_b rates, ap_tax_codes_all codes
6891: where codes.tax_id = rates.source_id --ID Clash
6892: AND rates.tax_class = 'INPUT'
6893: AND rates.record_type_code = 'MIGRATED'
6894: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7042: from zx_rates_b rates, ap_tax_codes_all codes

7038: codes.tax_type tax_type_code,
7039: rates.tax_regime_code tax_regime_code,
7040: rates.tax tax,
7041: rates.content_owner_id content_owner_id
7042: from zx_rates_b rates, ap_tax_codes_all codes
7043: where codes.tax_id = rates.source_id --ID Clash
7044: AND rates.tax_class = 'INPUT'
7045: AND rates.record_type_code = 'MIGRATED'
7046: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7101: AP_TAX_CODES_ALL CODES,

7097: -- DECODE(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
7098: NULL DEFAULT_EXCHANGE_RATE_TYPE
7099: FROM
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

Line 7286: from zx_rates_b rates, ap_tax_codes_all codes

7282: codes.tax_type tax_type_code,
7283: rates.tax_regime_code tax_regime_code,
7284: rates.tax tax,
7285: rates.content_owner_id content_owner_id
7286: from zx_rates_b rates, ap_tax_codes_all codes
7287: where codes.tax_id = rates.source_id --ID Clash
7288: AND rates.tax_class = 'INPUT'
7289: AND rates.record_type_code = 'MIGRATED'
7290: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7438: from zx_rates_b rates, ap_tax_codes_all codes

7434: codes.tax_type tax_type_code,
7435: rates.tax_regime_code tax_regime_code,
7436: rates.tax tax,
7437: rates.content_owner_id content_owner_id
7438: from zx_rates_b rates, ap_tax_codes_all codes
7439: where codes.tax_id = rates.source_id --ID Clash
7440: AND rates.tax_class = 'INPUT'
7441: AND rates.record_type_code = 'MIGRATED'
7442: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type

Line 7497: AP_TAX_CODES_ALL CODES,

7493: -- DECODE(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
7494: NULL DEFAULT_EXCHANGE_RATE_TYPE
7495: FROM
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

Line 7695: from zx_rates_b rates, ap_tax_codes_all codes

7691: (select codes.tax_type tax_type_code,
7692: rates.tax_regime_code tax_regime_code,
7693: rates.tax tax,
7694: rates.content_owner_id content_owner_id
7695: from zx_rates_b rates, ap_tax_codes_all codes
7696: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
7697: group by rates.tax_regime_code, rates.tax, rates.content_owner_id,codes.tax_type
7698: )
7699: where tax_regime_code = l_tax_regime_code

Line 7843: from zx_rates_b rates, ap_tax_codes_all codes

7839: codes.tax_type tax_type_code,
7840: rates.tax_regime_code tax_regime_code,
7841: rates.tax tax,
7842: rates.content_owner_id content_owner_id
7843: from zx_rates_b rates, ap_tax_codes_all codes
7844: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
7845: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type
7846: )
7847: where tax_regime_code = l_tax_regime_code

Line 7899: AP_TAX_CODES_ALL CODES,

7895: -- decode(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
7896: NULL DEFAULT_EXCHANGE_RATE_TYPE
7897: FROM
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

Line 7975: ap_tax_codes_all,

7971: MINUS
7972: SELECT
7973: lookup_code,lookup_type
7974: FROM
7975: ap_tax_codes_all,
7976: fnd_lookups
7977: WHERE
7978: (lookup_type = 'JGZZ_TAX_ORIGIN'
7979: AND global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'

Line 8120: from zx_rates_b rates, ap_tax_codes_all codes

8116: (select codes.tax_type tax_type_code,
8117: rates.tax_regime_code tax_regime_code,
8118: rates.tax tax,
8119: rates.content_owner_id content_owner_id
8120: from zx_rates_b rates, ap_tax_codes_all codes
8121: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
8122: group by rates.tax_regime_code, rates.tax, rates.content_owner_id,codes.tax_type
8123: )
8124: where tax_regime_code = l_tax_regime_code

Line 8268: from zx_rates_b rates, ap_tax_codes_all codes

8264: codes.tax_type tax_type_code,
8265: rates.tax_regime_code tax_regime_code,
8266: rates.tax tax,
8267: rates.content_owner_id content_owner_id
8268: from zx_rates_b rates, ap_tax_codes_all codes
8269: where codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) --ID Clash
8270: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, codes.tax_type
8271: )
8272: where tax_regime_code = l_tax_regime_code

Line 8324: AP_TAX_CODES_ALL CODES,

8320: -- decode(ASP.DEFAULT_EXCHANGE_RATE_TYPE,'User','Corporate',ASP.DEFAULT_EXCHANGE_RATE_TYPE) DEFAULT_EXCHANGE_RATE_TYPE
8321: NULL DEFAULT_EXCHANGE_RATE_TYPE
8322: FROM
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

Line 8401: ap_tax_codes_all,

8397: MINUS
8398: SELECT
8399: lookup_code,lookup_type
8400: FROM
8401: ap_tax_codes_all,
8402: fnd_lookups
8403: WHERE
8404: (lookup_type = 'JGZZ_TAX_ORIGIN'
8405: AND global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'

Line 8474: ap_tax_codes_all ap_code

8470: FROM
8471: zx_taxes_b taxes,
8472: zx_rates_b rates,
8473: fnd_lookup_values flv,
8474: ap_tax_codes_all ap_code
8475: WHERE
8476: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8477: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8478: AND taxes.TAX = rates.TAX

Line 8524: ap_tax_codes_all ap_code

8520: FROM
8521: zx_taxes_b taxes,
8522: zx_rates_b rates,
8523: fnd_lookup_values flv,
8524: ap_tax_codes_all ap_code
8525: WHERE
8526: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8527: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8528: AND taxes.TAX = rates.TAX

Line 8571: ap_tax_codes_all ap_code

8567: FROM
8568: zx_taxes_b taxes,
8569: zx_rates_b rates,
8570: fnd_lookup_values flv,
8571: ap_tax_codes_all ap_code
8572: WHERE
8573: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8574: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8575: AND taxes.TAX = rates.TAX

Line 8618: ap_tax_codes_all ap_code

8614: FROM
8615: zx_taxes_b taxes,
8616: zx_rates_b rates,
8617: fnd_lookup_values flv,
8618: ap_tax_codes_all ap_code
8619: WHERE
8620: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8621: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE
8622: AND taxes.TAX = rates.TAX

Line 9534: ap_tax_codes_all codes,

9530: from ap_tax_recvry_rates_all
9531: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9532: ptp.party_tax_profile_id CONTENT_OWNER_ID
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

Line 9650: ap_tax_codes_all codes,

9646: from ap_tax_recvry_rates_all
9647: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9648: ptp.party_tax_profile_id CONTENT_OWNER_ID
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

Line 9824: AP_TAX_CODES_ALL CODES,

9820: THEN 'N'
9821: ELSE 'Y'
9822: END ENABLED_FLAG --ENABLED_FLAG
9823: FROM
9824: AP_TAX_CODES_ALL CODES,
9825: ap_tax_recvry_rules_all AP_RULES,
9826: ap_tax_recvry_rates_all AP_RATES,
9827: ZX_RATES_B ZX_RATES,
9828: ZX_RULES_B ZX_RULES,

Line 9963: AP_TAX_CODES_ALL CODES,

9959: THEN 'N'
9960: ELSE 'Y'
9961: END ENABLED_FLAG --ENABLED_FLAG
9962: FROM
9963: AP_TAX_CODES_ALL CODES,
9964: ap_tax_recvry_rules_all AP_RULES,
9965: ap_tax_recvry_rates_all AP_RATES,
9966: ZX_RATES_B ZX_RATES,
9967: ZX_RULES_B ZX_RULES,

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

10335: |==========================================================================*/
10336:
10337: PROCEDURE migrate_disabled_tax_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
10338:
10339: TYPE tax_id_table is table of ap_tax_codes_all.tax_id%TYPE index by BINARY_INTEGER;
10340: tax_id_tab tax_id_table ;
10341: l_min_start_date date;
10342: l_max_end_date date;
10343:

Line 10369: from ap_tax_codes_all a

10365: select aptax2.tax_id tax_id
10366: from
10367: (
10368: select DISTINCT org_id,set_of_books_id,name
10369: from ap_tax_codes_all a
10370: where a.enabled_flag = 'N'
10371: and exists
10372: (
10373: select 1 from ap_tax_codes_all b

Line 10373: select 1 from ap_tax_codes_all b

10369: from ap_tax_codes_all a
10370: where a.enabled_flag = 'N'
10371: and exists
10372: (
10373: select 1 from ap_tax_codes_all b
10374: where a.org_id = b.org_id
10375: and a.set_of_books_id = b.set_of_books_id
10376: and a.name = b.name
10377: and

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

10388: )
10389: and b.enabled_flag = 'N'
10390: )
10391: and exists
10392: (select c.org_id,c.set_of_books_id,c.name ,count(c.org_id) from ap_tax_codes_all c
10393: where a.org_id = c.org_id
10394: and a.set_of_books_id = c.set_of_books_id
10395: and a.name = c.name
10396: group by c.org_id,c.set_of_books_id,c.name

Line 10400: ap_tax_codes_all aptax2

10396: group by c.org_id,c.set_of_books_id,c.name
10397: having count(c.org_id) > 1)
10398: )
10399: aptax1,
10400: ap_tax_codes_all aptax2
10401: where
10402: aptax1.org_id = aptax2.org_id
10403: and aptax1.set_of_books_id = aptax2.set_of_books_id
10404: and aptax1. name = aptax2. name

Line 10742: ap_tax_codes_all codes,

10738: NULL) NON_REC_ACCOUNT_CCID,
10739: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
10740: FROM
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

Line 10842: ap_tax_codes_all codes,

10838: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
10839:
10840: FROM
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,

Line 11165: ap_tax_codes_all codes,

11161: NULL) NON_REC_ACCOUNT_CCID,
11162: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11163: FROM
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

Line 11266: ap_tax_codes_all codes,

11262: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11263:
11264: FROM
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,

Line 11602: ap_tax_codes_all codes,

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

Line 11702: ap_tax_codes_all codes,

11698: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11699:
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

Line 12027: ap_tax_codes_all codes,

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

Line 12128: ap_tax_codes_all codes,

12124: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12125:
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

Line 12469: ap_tax_codes_all codes,

12465: NULL) NON_REC_ACCOUNT_CCID,
12466: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12467: FROM
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

Line 12568: ap_tax_codes_all codes,

12564: NULL) NON_REC_ACCOUNT_CCID,
12565: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12566: FROM
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,

Line 12893: ap_tax_codes_all codes,

12889: NULL) NON_REC_ACCOUNT_CCID,
12890: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12891: FROM
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

Line 12993: ap_tax_codes_all codes,

12989: NULL) NON_REC_ACCOUNT_CCID,
12990: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12991: FROM
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,

Line 13332: ap_tax_codes_all codes,

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

Line 13432: ap_tax_codes_all codes,

13428: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13429:
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

Line 13757: ap_tax_codes_all codes,

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

Line 13858: ap_tax_codes_all codes,

13854: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13855:
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

Line 14045: from ap_tax_codes_all,

14041: BEGIN
14042:
14043: SELECT 'Y' INTO ID_CLASH FROM DUAL
14044: WHERE EXISTS (select 1
14045: from ap_tax_codes_all,
14046: ar_vat_tax_all_b
14047: where tax_id = vat_tax_id);
14048: EXCEPTION
14049: WHEN no_data_found THEN