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_REP_ENTITIES_PKG dependencies on ZX_RATES_B

Line 935: zx_rates_b zx_rates

931: min(zx_rates.effective_from) effective_from,
932: zx_rates.tax_regime_code l_tax_regime_code
933: FROM
934: AR_VAT_TAX_ALL_B vat_tax,
935: zx_rates_b zx_rates
936: WHERE
937: vat_tax.vat_tax_id = zx_rates.tax_rate_id
938: AND vat_tax.global_attribute_category = p_category
939: AND zx_rates.record_type_code = 'MIGRATED'

Line 1024: zx_rates_b zx_rates

1020: min(zx_rates.effective_from) effective_from,
1021: zx_rates.tax_regime_code l_tax_regime_code
1022: FROM
1023: ap_tax_codes_all codes,
1024: zx_rates_b zx_rates
1025: WHERE
1026: codes.tax_id = zx_rates.tax_rate_id
1027: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1028: AND codes.global_attribute_category = p_category

Line 1341: ZX_RATES_B rates,

1337: 1
1338: FROM
1339:
1340: AP_TAX_CODES_ALL codes,
1341: ZX_RATES_B rates,
1342: ZX_REPORTING_CODES_B report_codes
1343: WHERE
1344: codes.tax_id = rates.tax_rate_id
1345: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 1414: ZX_RATES_B rates,

1410: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1411: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1412: FROM
1413: AP_TAX_CODES_ALL codes,
1414: ZX_RATES_B rates,
1415: ZX_REPORTING_TYPES_B reporting_types,
1416: ZX_REPORTING_CODES_B report_codes
1417: WHERE
1418: codes.tax_id = rates.tax_rate_id

Line 1446: ZX_RATES_B rates,

1442: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1443: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1444: FROM
1445: AP_TAX_CODES_ALL codes,
1446: ZX_RATES_B rates,
1447: ZX_REPORTING_TYPES_B reporting_types,
1448: ZX_REPORTING_CODES_B report_codes
1449: WHERE
1450: codes.tax_id = rates.tax_rate_id

Line 1477: ZX_RATES_B rates,

1473: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1474: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1475: FROM
1476: AP_TAX_CODES_ALL codes,
1477: ZX_RATES_B rates,
1478: ZX_REPORTING_TYPES_B reporting_types,
1479: ZX_REPORTING_CODES_B report_codes
1480: WHERE
1481: codes.tax_id = rates.tax_rate_id

Line 1508: ZX_RATES_B rates,

1504: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1505: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1506: FROM
1507: AP_TAX_CODES_ALL codes,
1508: ZX_RATES_B rates,
1509: ZX_REPORTING_TYPES_B reporting_types,
1510: ZX_REPORTING_CODES_B report_codes
1511: WHERE
1512: codes.tax_id = rates.tax_rate_id

Line 1539: ZX_RATES_B rates,

1535: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1536: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1537: FROM
1538: AP_TAX_CODES_ALL codes,
1539: ZX_RATES_B rates,
1540: ZX_REPORTING_TYPES_B reporting_types,
1541: ZX_REPORTING_CODES_B report_codes
1542: WHERE
1543: codes.tax_id = rates.tax_rate_id

Line 1570: ZX_RATES_B rates,

1566: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1567: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1568: FROM
1569: AP_TAX_CODES_ALL codes,
1570: ZX_RATES_B rates,
1571: ZX_REPORTING_TYPES_B reporting_types,
1572: ZX_REPORTING_CODES_B report_codes
1573: WHERE
1574: codes.tax_id = rates.tax_rate_id

Line 1604: ZX_RATES_B rates,

1600: NULL REPORTING_CODE_DATE_VALUE,
1601: NULL REPORTING_CODE_NUM_VALUE
1602: FROM
1603: AP_TAX_CODES_ALL codes,
1604: ZX_RATES_B rates,
1605: ZX_REPORTING_TYPES_B reporting_types
1606: -- ZX_REPORTING_CODES_B report_codes
1607: WHERE
1608: codes.tax_id = rates.tax_rate_id

Line 1634: ZX_RATES_B rates,

1630: NULL REPORTING_CODE_DATE_VALUE,
1631: NULL REPORTING_CODE_NUM_VALUE
1632: FROM
1633: AP_TAX_CODES_ALL codes,
1634: ZX_RATES_B rates,
1635: ZX_REPORTING_TYPES_B reporting_types
1636: -- ZX_REPORTING_CODES_B report_codes
1637: WHERE
1638: codes.tax_id = rates.tax_rate_id

Line 1665: ZX_RATES_B rates,

1661: NULL REPORTING_CODE_DATE_VALUE,
1662: NULL REPORTING_CODE_NUM_VALUE
1663: FROM
1664: AP_TAX_CODES_ALL codes,
1665: ZX_RATES_B rates,
1666: ZX_REPORTING_TYPES_B reporting_types
1667: -- ZX_REPORTING_CODES_B report_codes
1668: WHERE
1669: codes.tax_id = rates.tax_rate_id

Line 1696: ZX_RATES_B rates,

1692: NULL REPORTING_CODE_DATE_VALUE,
1693: NULL REPORTING_CODE_NUM_VALUE
1694: FROM
1695: AP_TAX_CODES_ALL codes,
1696: ZX_RATES_B rates,
1697: ZX_REPORTING_TYPES_B reporting_types
1698: -- ZX_REPORTING_CODES_B report_codes
1699: WHERE
1700: codes.tax_id = rates.tax_rate_id

Line 1727: ZX_RATES_B rates,

1723: NULL REPORTING_CODE_DATE_VALUE,
1724: NULL REPORTING_CODE_NUM_VALUE
1725: FROM
1726: AP_TAX_CODES_ALL codes,
1727: ZX_RATES_B rates,
1728: ZX_REPORTING_TYPES_B reporting_types
1729: -- ZX_REPORTING_CODES_B report_codes
1730: WHERE
1731:

Line 1761: ZX_RATES_B rates,

1757: NULL REPORTING_CODE_NUM_VALUE
1758:
1759: FROM
1760: AP_TAX_CODES_ALL codes,
1761: ZX_RATES_B rates,
1762: ZX_REPORTING_TYPES_B reporting_types
1763: -- ZX_REPORTING_CODES_B report_codes
1764: WHERE
1765: codes.tax_id = rates.tax_rate_id

Line 1932: ZX_RATES_B rates

1928: FROM
1929: AP_TAX_CODES_ALL codes,
1930: ZX_REPORTING_TYPES_B reporting_types,
1931: ZX_REPORTING_CODES_B report_codes,
1932: ZX_RATES_B rates
1933:
1934:
1935: WHERE
1936: codes.tax_id = rates.tax_rate_id

Line 2020: ZX_RATES_B rates,

2016: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2017: FROM
2018:
2019: AR_VAT_TAX_ALL_B codes,
2020: ZX_RATES_B rates,
2021: ZX_REPORTING_TYPES_B report_types,
2022: ZX_REPORTING_CODES_B report_codes
2023:
2024: WHERE

Line 2058: ZX_RATES_B rates,

2054: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2055: FROM
2056:
2057: AR_VAT_TAX_ALL_B codes,
2058: ZX_RATES_B rates,
2059: ZX_REPORTING_TYPES_B report_types,
2060: ZX_REPORTING_CODES_B report_codes
2061:
2062: WHERE

Line 2093: ZX_RATES_B rates,

2089: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2090: FROM
2091:
2092: AR_VAT_TAX_ALL_B codes,
2093: ZX_RATES_B rates,
2094: ZX_REPORTING_TYPES_B report_types,
2095: ZX_REPORTING_CODES_B report_codes
2096:
2097: WHERE

Line 2128: ZX_RATES_B rates,

2124: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2125: FROM
2126:
2127: AR_VAT_TAX_ALL_B codes,
2128: ZX_RATES_B rates,
2129: ZX_REPORTING_TYPES_B report_types,
2130: ZX_REPORTING_CODES_B report_codes
2131:
2132: WHERE

Line 2163: ZX_RATES_B rates,

2159: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2160: FROM
2161:
2162: AR_VAT_TAX_ALL_B codes,
2163: ZX_RATES_B rates,
2164: ZX_REPORTING_TYPES_B report_types,
2165: ZX_REPORTING_CODES_B report_codes
2166:
2167: WHERE

Line 2198: ZX_RATES_B rates,

2194: NULL REPORTING_CODE_NUM_VALUE
2195:
2196: FROM
2197: AR_VAT_TAX_ALL_B codes,
2198: ZX_RATES_B rates,
2199: ZX_REPORTING_TYPES_B report_types
2200: WHERE
2201: codes.vat_tax_id = rates.tax_rate_id
2202: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)

Line 2232: ZX_RATES_B rates,

2228:
2229: FROM
2230:
2231: AR_VAT_TAX_ALL_B codes,
2232: ZX_RATES_B rates,
2233: ZX_REPORTING_TYPES_B report_types
2234: -- ZX_REPORTING_CODES_B report_codes
2235:
2236: WHERE

Line 2267: ZX_RATES_B rates,

2263: NULL REPORTING_CODE_NUM_VALUE
2264: FROM
2265:
2266: AR_VAT_TAX_ALL_B codes,
2267: ZX_RATES_B rates,
2268: ZX_REPORTING_TYPES_B report_types
2269: -- ZX_REPORTING_CODES_B report_codes
2270:
2271: WHERE

Line 2302: ZX_RATES_B rates,

2298: NULL REPORTING_CODE_NUM_VALUE
2299: FROM
2300:
2301: AR_VAT_TAX_ALL_B codes,
2302: ZX_RATES_B rates,
2303: ZX_REPORTING_TYPES_B report_types
2304: -- ZX_REPORTING_CODES_B report_codes
2305:
2306: WHERE

Line 2339: ZX_RATES_B rates,

2335:
2336: FROM
2337:
2338: AR_VAT_TAX_ALL_B codes,
2339: ZX_RATES_B rates,
2340: ZX_REPORTING_TYPES_B report_types
2341: -- ZX_REPORTING_CODES_B report_codes
2342:
2343: WHERE

Line 2374: ZX_RATES_B rates,

2370: NULL REPORTING_CODE_NUM_VALUE
2371: FROM
2372:
2373: AR_VAT_TAX_ALL_B codes,
2374: ZX_RATES_B rates,
2375: ZX_REPORTING_TYPES_B report_types
2376: -- ZX_REPORTING_CODES_B report_codes
2377:
2378: WHERE

Line 2410: ZX_RATES_B rates,

2406:
2407: FROM
2408:
2409: AR_VAT_TAX_ALL_B codes,
2410: ZX_RATES_B rates,
2411: ZX_REPORTING_TYPES_B report_types
2412: -- ZX_REPORTING_CODES_B report_codes
2413:
2414: WHERE

Line 2446: ZX_RATES_B rates,

2442:
2443: FROM
2444:
2445: AR_VAT_TAX_ALL_B codes,
2446: ZX_RATES_B rates,
2447: ZX_REPORTING_TYPES_B report_types,
2448: ZX_REPORTING_CODES_B report_codes
2449:
2450: WHERE

Line 2483: ZX_RATES_B rates,

2479:
2480: FROM
2481:
2482: AR_VAT_TAX_ALL_B codes,
2483: ZX_RATES_B rates,
2484: ZX_REPORTING_TYPES_B report_types,
2485: ZX_REPORTING_CODES_B report_codes
2486:
2487: WHERE

Line 2520: ZX_RATES_B rates,

2516:
2517: FROM
2518:
2519: AR_VAT_TAX_ALL_B codes,
2520: ZX_RATES_B rates,
2521: ZX_REPORTING_TYPES_B report_types,
2522: ZX_REPORTING_CODES_B report_codes
2523:
2524: WHERE

Line 2557: ZX_RATES_B rates,

2553:
2554: FROM
2555:
2556: AR_VAT_TAX_ALL_B codes,
2557: ZX_RATES_B rates,
2558: ZX_REPORTING_TYPES_B report_types,
2559: ZX_REPORTING_CODES_B report_codes
2560:
2561: WHERE

Line 2594: ZX_RATES_B rates,

2590:
2591: FROM
2592:
2593: AR_VAT_TAX_ALL_B codes,
2594: ZX_RATES_B rates,
2595: ZX_REPORTING_TYPES_B report_types,
2596: ZX_REPORTING_CODES_B report_codes
2597:
2598: WHERE

Line 2631: ZX_RATES_B rates,

2627: report_codes.REPORTING_CODE_DATE_VALUE,
2628: report_codes.REPORTING_CODE_NUM_VALUE
2629: FROM
2630: AR_VAT_TAX_ALL_TL codes,
2631: ZX_RATES_B rates,
2632: ZX_REPORTING_TYPES_B report_types,
2633: ZX_REPORTING_CODES_B report_codes
2634:
2635: WHERE

Line 2705: ZX_RATES_B rates

2701: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE
2702: FROM
2703: ZX_REPORTING_TYPES_B report_types,
2704: AR_VAT_TAX_ALL_B codes,
2705: ZX_RATES_B rates
2706:
2707: WHERE
2708: report_types.reporting_type_code= 'CL_BILLS_OF_EXCH_TAX'
2709: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369

Line 2732: ZX_RATES_B rates

2728: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE
2729: FROM
2730: ZX_REPORTING_TYPES_B report_types,
2731: AR_VAT_TAX_ALL_B codes,
2732: ZX_RATES_B rates
2733:
2734: WHERE
2735: report_types.reporting_type_code= 'AR_MUNICIPAL_JUR'
2736: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369

Line 2760: ZX_RATES_B rates

2756: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2757: FROM
2758: ZX_REPORTING_TYPES_B report_types,
2759: AR_VAT_TAX_ALL_B codes,
2760: ZX_RATES_B rates
2761:
2762: WHERE
2763: report_types.reporting_type_code= 'PRINT TAX LINE'
2764: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369

Line 2788: ZX_RATES_B rates

2784: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2785: FROM
2786: ZX_REPORTING_TYPES_B report_types,
2787: AR_VAT_TAX_ALL_B codes,
2788: ZX_RATES_B rates
2789:
2790: WHERE
2791: report_types.reporting_type_code= 'PRINT TAX LINE'
2792: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369

Line 2817: ZX_RATES_B rates

2813: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2814: FROM
2815: ZX_REPORTING_TYPES_B report_types,
2816: AR_VAT_TAX_ALL_B codes,
2817: ZX_RATES_B rates
2818:
2819: WHERE
2820: report_types.reporting_type_code= 'PRINT TAX LINE'
2821: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369

Line 2881: ZX_RATES_B rates,

2877: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE,
2878: rates.EFFECTIVE_FROM EFFECTIVE_FROM
2879: FROM
2880: AR_VAT_TAX_ALL_B codes,
2881: ZX_RATES_B rates,
2882: ZX_REPORTING_CODES_B report_codes,
2883: hr_locations loc
2884: WHERE
2885: codes.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'

Line 3306: zx_rates_b zx_rates

3302: min(zx_rates.effective_from) effective_from,
3303: zx_rates.tax_regime_code l_tax_regime_code
3304: FROM
3305: ap_tax_codes_all codes,
3306: zx_rates_b zx_rates
3307: WHERE
3308: codes.tax_id = zx_rates.tax_rate_id
3309: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
3310: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 3381: zx_rates_b zx_rates

3377: min(zx_rates.effective_from) effective_from,
3378: zx_rates.tax_regime_code l_tax_regime_code
3379: FROM
3380: ap_tax_codes_all codes,
3381: zx_rates_b zx_rates
3382: WHERE
3383: codes.tax_id = zx_rates.tax_rate_id
3384: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
3385: AND codes.global_attribute_category = 'JL.AR.APXTADTC.VAT'

Line 3456: zx_rates_b zx_rates

3452: min(zx_rates.effective_from) effective_from,
3453: zx_rates.tax_regime_code l_tax_regime_code
3454: FROM
3455: ap_tax_codes_all codes,
3456: zx_rates_b zx_rates
3457: WHERE
3458: codes.tax_id = zx_rates.tax_rate_id
3459: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
3460: AND codes.global_attribute_category = 'JL.CL.APXTADTC.AP_TAX_CODES'

Line 3896: zx_rates_b zx_rates

3892: zx_rates.tax_regime_code l_tax_regime_code
3893:
3894: FROM
3895: ap_tax_codes_all ap_tax,
3896: zx_rates_b zx_rates
3897: WHERE
3898: ap_tax.tax_id = zx_rates.tax_rate_id
3899: AND ap_tax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3900: AND zx_rates.record_type_code = 'MIGRATED'

Line 3958: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date

3954: select
3955: distinct
3956: tax_id_values_and_codes.location_code l_location_code,
3957: zxrb.tax_regime_code l_tax_regime_code ,
3958: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
3959: from
3960: (
3961: select tax_id,hrloc.location_code location_code
3962: from ap_tax_codes_all aptax, hr_locations hrloc

Line 3966: zx_rates_b zxrb

3962: from ap_tax_codes_all aptax, hr_locations hrloc
3963: where aptax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3964: and aptax.global_attribute1 = to_char(hrloc.location_id)
3965: ) tax_id_values_and_codes,
3966: zx_rates_b zxrb
3967: where zxrb.tax_rate_id = tax_id_values_and_codes.tax_id
3968: and tax_id_values_and_codes.tax_id = nvl(p_tax_id,tax_id_values_and_codes.tax_id)
3969: and tax_id_values_and_codes.location_code is not null
3970: and not exists

Line 4033: ZX_RATES_B rates,

4029: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
4030: FROM
4031: AP_TAX_CODES_ALL codes,
4032: HR_LOCATIONS hrloc,
4033: ZX_RATES_B rates,
4034: ZX_REPORTING_TYPES_B reporting_types,
4035: ZX_REPORTING_CODES_B report_codes
4036: WHERE
4037: codes.tax_id = rates.tax_rate_id

Line 4494: zx_rates_b zx_rates

4490: min(zx_rates.effective_from) effective_from,
4491: zx_rates.tax_regime_code l_tax_regime_code
4492: FROM
4493: AR_VAT_TAX_ALL_B vat_tax,
4494: zx_rates_b zx_rates
4495: WHERE
4496: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4497: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)
4498: AND vat_tax.global_attribute_category = 'JE.PT.ARXSUVAT.TAX_INFO'

Line 4676: zx_rates_b zx_rates

4672: min(zx_rates.effective_from) effective_from,
4673: zx_rates.tax_regime_code l_tax_regime_code
4674: FROM
4675: AR_VAT_TAX_ALL_B codes,
4676: zx_rates_b zx_rates
4677: WHERE
4678: codes.vat_tax_id = zx_rates.tax_rate_id
4679: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
4680: AND codes.global_attribute_category = 'JL.AR.ARXSUVAT.AR_VAT_TAX'

Line 4753: zx_rates_b zx_rates

4749: zx_rates.tax_regime_code l_tax_regime_code
4750:
4751: FROM
4752: ar_vat_tax_all_b vat_tax,
4753: zx_rates_b zx_rates
4754: WHERE
4755: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4756: AND zx_rates.record_type_code = 'MIGRATED'
4757: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)

Line 4828: zx_rates_b zxrb

4824: printed_tax_name ,
4825: zxrb.tax_regime_code l_tax_regime_code ,
4826: zxrb.effective_from l_start_date
4827: from ar_vat_tax_all_tl avtl ,
4828: zx_rates_b zxrb
4829: where zxrb.tax_rate_id = cursor_rec.vat_tax_id
4830: and zxrb.tax_rate_id = avtl.vat_tax_id
4831: and language = l_language_code
4832: and printed_tax_name is not null

Line 4899: zx_rates_b zx_rates

4895: -- Bug 5344337
4896: SELECT COUNT(1) INTO l_exists_cnt
4897: FROM
4898: ar_vat_tax_all_b vat_tax,
4899: zx_rates_b zx_rates
4900: WHERE
4901: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4902: AND zx_rates.record_type_code = 'MIGRATED';
4903:

Line 4980: zx_rates_b zx_rates

4976: zx_rates.tax_regime_code l_tax_regime_code
4977:
4978: FROM
4979: ar_vat_tax_all_b vat_tax,
4980: zx_rates_b zx_rates
4981: WHERE
4982: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4983: AND zx_rates.record_type_code = 'MIGRATED'
4984: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)

Line 5044: zx_rates_b zxrb

5040: adjustment_tax_code ,
5041: zxrb.tax_regime_code l_tax_regime_code ,
5042: zxrb.effective_from l_start_date
5043: from ar_vat_tax_all_b avtb ,
5044: zx_rates_b zxrb
5045: where zxrb.tax_rate_id = avtb.vat_tax_id
5046: and adjustment_tax_code is not null
5047: and not exists
5048: ( select 1 from zx_reporting_codes_b where reporting_type_id =

Line 5108: zx_rates_b zxrb

5104: avtb.global_attribute5,
5105: zxrb.tax_regime_code l_tax_regime_code ,
5106: zxrb.effective_from l_start_date
5107: from ar_vat_tax_all_b avtb ,
5108: zx_rates_b zxrb
5109: where zxrb.tax_rate_id = avtb.vat_tax_id
5110: and avtb.global_attribute_category ='JL.CL.ARXSUVAT.VAT_TAX'
5111: and avtb.global_attribute5 is not null
5112: and not exists

Line 5629: zx_rates_b zx_rates

5625: zx_rates.tax_regime_code l_tax_regime_code
5626:
5627: FROM
5628: ar_vat_tax_all_b ar_vat,
5629: zx_rates_b zx_rates
5630: WHERE
5631: ar_vat.vat_tax_id = zx_rates.tax_rate_id
5632: AND ar_vat.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'
5633: AND zx_rates.record_type_code = 'MIGRATED'

Line 5692: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date

5688: select
5689: distinct
5690: tax_id_values_and_codes.location_code l_location_code,
5691: zxrb.tax_regime_code l_tax_regime_code ,
5692: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
5693: from
5694: (
5695: select vat_tax_id,hrloc.location_code location_code
5696: from ar_vat_tax_all_b artax, hr_locations hrloc

Line 5700: zx_rates_b zxrb

5696: from ar_vat_tax_all_b artax, hr_locations hrloc
5697: where artax.global_attribute_category = 'JA.KR.ARXSUVAT.VAT' -- Bug 5031787
5698: and artax.global_attribute1 = to_char(hrloc.location_id)
5699: ) tax_id_values_and_codes,
5700: zx_rates_b zxrb
5701: where zxrb.tax_rate_id = tax_id_values_and_codes.vat_tax_id
5702: and tax_id_values_and_codes.vat_tax_id = nvl(p_tax_id,tax_id_values_and_codes.vat_tax_id)
5703: and tax_id_values_and_codes.location_code is not null
5704: and not exists

Line 5766: ZX_RATES_B rates,

5762: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
5763: FROM
5764: AR_VAT_TAX_ALL_B codes,
5765: HR_LOCATIONS hrloc,
5766: ZX_RATES_B rates,
5767: ZX_REPORTING_TYPES_B reporting_types,
5768: ZX_REPORTING_CODES_B report_codes
5769: WHERE
5770: codes.vat_tax_id = rates.tax_rate_id

Line 5808: 'ZX_RATES_B' ,--ENTITY_CODE

5804: REPORTING_TYPE_ID ,
5805: OBJECT_VERSION_NUMBER
5806: )
5807: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5808: 'ZX_RATES_B' ,--ENTITY_CODE
5809: 'Y' ,--ENABLED_FLAG
5810: fnd_global.user_id ,--CREATED_BY
5811: SYSDATE ,--CREATION_DATE
5812: fnd_global.user_id ,--LAST_UPDATED_BY

Line 5825: entity_code = 'ZX_RATES_B' );

5821: WHERE
5822: reporting_type_code = 'KR_BUSINESS_LOCATIONS'
5823: AND NOT EXISTS ( select 1 from zx_report_types_usages
5824: where reporting_type_id = rep_type.reporting_type_id and
5825: entity_code = 'ZX_RATES_B' );
5826: */
5827:
5828: IF PG_DEBUG = 'Y' THEN
5829: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AR(-)');

Line 7007: FROM zx_rates_b zx_rates,

7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7004: 1 --OBJECT_VERSION_NUMBER
7005: )
7006: SELECT min(zx_rates.effective_from) effective_from
7007: FROM zx_rates_b zx_rates,
7008: zx_regimes_b zx_regimes
7009: WHERE zx_rates.tax_regime_code = zx_regimes.tax_regime_code
7010: AND zx_regimes.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7011: 'IT','KP','KR','NO','PL','PT','SK')

Line 7338: ZX_RATES_B rates,

7334: FROM
7335: AP_TAX_CODES_ALL codes,
7336: ZX_REPORTING_TYPES_B reporting_types,
7337: ZX_REPORTING_CODES_B report_codes,
7338: ZX_RATES_B rates,
7339: -- Bug 7620818
7340: ZX_REGIMES_B reg
7341: WHERE
7342: codes.tax_id = rates.tax_rate_id

Line 7410: ZX_RATES_B rates,

7406: FROM
7407: AR_VAT_TAX_ALL codes,
7408: ZX_REPORTING_TYPES_B reporting_types,
7409: ZX_REPORTING_CODES_B report_codes,
7410: ZX_RATES_B rates,
7411: -- Bug 7620818
7412: ZX_REGIMES_B reg
7413: WHERE
7414: codes.vat_tax_id = rates.tax_rate_id

Line 7520: FROM zx_rates_b rates,

7516: 'REVERSE_CHARGE_VAT' l_reporting_type_code,
7517: rates.tax_regime_code l_tax_regime_code,
7518: rates.tax l_tax,
7519: min(rates.effective_from) l_effective_from
7520: FROM zx_rates_b rates,
7521: ar_vat_tax_all codes
7522: WHERE rates.tax_rate_id = codes.vat_tax_id
7523: AND codes.tax_type = 'REVERSE_CHARGE_VAT'
7524: AND rates.record_type_code = 'MIGRATED'

Line 7763: ZX_RATES_B rates

7759: FROM
7760: AR_VAT_TAX_ALL codes,
7761: ZX_REPORTING_TYPES_B reporting_types,
7762: ZX_REPORTING_CODES_B report_codes,
7763: ZX_RATES_B rates
7764: WHERE
7765: codes.vat_tax_id = rates.tax_rate_id
7766: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
7767: AND reporting_types.reporting_type_code ='REVERSE_CHARGE_VAT'