[Home] [Help]
946: min(zx_rates.effective_from) effective_from,
947: zx_rates.tax_regime_code l_tax_regime_code
948: FROM
949: AR_VAT_TAX_ALL_B vat_tax,
950: zx_rates_b zx_rates
951: WHERE
952: vat_tax.vat_tax_id = zx_rates.tax_rate_id
953: AND vat_tax.global_attribute_category = p_category
954: AND zx_rates.record_type_code = 'MIGRATED'
1035: min(zx_rates.effective_from) effective_from,
1036: zx_rates.tax_regime_code l_tax_regime_code
1037: FROM
1038: ap_tax_codes_all codes,
1039: zx_rates_b zx_rates
1040: WHERE
1041: codes.tax_id = zx_rates.tax_rate_id
1042: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1043: AND codes.global_attribute_category = p_category
1352: 1
1353: FROM
1354:
1355: AP_TAX_CODES_ALL codes,
1356: ZX_RATES_B rates,
1357: ZX_REPORTING_CODES_B report_codes
1358: WHERE
1359: codes.tax_id = rates.tax_rate_id
1360: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1425: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1426: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1427: FROM
1428: AP_TAX_CODES_ALL codes,
1429: ZX_RATES_B rates,
1430: ZX_REPORTING_TYPES_B reporting_types,
1431: ZX_REPORTING_CODES_B report_codes
1432: WHERE
1433: codes.tax_id = rates.tax_rate_id
1457: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1458: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1459: FROM
1460: AP_TAX_CODES_ALL codes,
1461: ZX_RATES_B rates,
1462: ZX_REPORTING_TYPES_B reporting_types,
1463: ZX_REPORTING_CODES_B report_codes
1464: WHERE
1465: codes.tax_id = rates.tax_rate_id
1488: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1489: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1490: FROM
1491: AP_TAX_CODES_ALL codes,
1492: ZX_RATES_B rates,
1493: ZX_REPORTING_TYPES_B reporting_types,
1494: ZX_REPORTING_CODES_B report_codes
1495: WHERE
1496: codes.tax_id = rates.tax_rate_id
1519: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1520: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1521: FROM
1522: AP_TAX_CODES_ALL codes,
1523: ZX_RATES_B rates,
1524: ZX_REPORTING_TYPES_B reporting_types,
1525: ZX_REPORTING_CODES_B report_codes
1526: WHERE
1527: codes.tax_id = rates.tax_rate_id
1550: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1551: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1552: FROM
1553: AP_TAX_CODES_ALL codes,
1554: ZX_RATES_B rates,
1555: ZX_REPORTING_TYPES_B reporting_types,
1556: ZX_REPORTING_CODES_B report_codes
1557: WHERE
1558: codes.tax_id = rates.tax_rate_id
1581: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1582: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1583: FROM
1584: AP_TAX_CODES_ALL codes,
1585: ZX_RATES_B rates,
1586: ZX_REPORTING_TYPES_B reporting_types,
1587: ZX_REPORTING_CODES_B report_codes
1588: WHERE
1589: codes.tax_id = rates.tax_rate_id
1615: NULL REPORTING_CODE_DATE_VALUE,
1616: NULL REPORTING_CODE_NUM_VALUE
1617: FROM
1618: AP_TAX_CODES_ALL codes,
1619: ZX_RATES_B rates,
1620: ZX_REPORTING_TYPES_B reporting_types
1621: -- ZX_REPORTING_CODES_B report_codes
1622: WHERE
1623: codes.tax_id = rates.tax_rate_id
1645: NULL REPORTING_CODE_DATE_VALUE,
1646: NULL REPORTING_CODE_NUM_VALUE
1647: FROM
1648: AP_TAX_CODES_ALL codes,
1649: ZX_RATES_B rates,
1650: ZX_REPORTING_TYPES_B reporting_types
1651: -- ZX_REPORTING_CODES_B report_codes
1652: WHERE
1653: codes.tax_id = rates.tax_rate_id
1676: NULL REPORTING_CODE_DATE_VALUE,
1677: NULL REPORTING_CODE_NUM_VALUE
1678: FROM
1679: AP_TAX_CODES_ALL codes,
1680: ZX_RATES_B rates,
1681: ZX_REPORTING_TYPES_B reporting_types
1682: -- ZX_REPORTING_CODES_B report_codes
1683: WHERE
1684: codes.tax_id = rates.tax_rate_id
1707: NULL REPORTING_CODE_DATE_VALUE,
1708: NULL REPORTING_CODE_NUM_VALUE
1709: FROM
1710: AP_TAX_CODES_ALL codes,
1711: ZX_RATES_B rates,
1712: ZX_REPORTING_TYPES_B reporting_types
1713: -- ZX_REPORTING_CODES_B report_codes
1714: WHERE
1715: codes.tax_id = rates.tax_rate_id
1738: NULL REPORTING_CODE_DATE_VALUE,
1739: NULL REPORTING_CODE_NUM_VALUE
1740: FROM
1741: AP_TAX_CODES_ALL codes,
1742: ZX_RATES_B rates,
1743: ZX_REPORTING_TYPES_B reporting_types
1744: -- ZX_REPORTING_CODES_B report_codes
1745: WHERE
1746:
1772: NULL REPORTING_CODE_NUM_VALUE
1773:
1774: FROM
1775: AP_TAX_CODES_ALL codes,
1776: ZX_RATES_B rates,
1777: ZX_REPORTING_TYPES_B reporting_types
1778: -- ZX_REPORTING_CODES_B report_codes
1779: WHERE
1780: codes.tax_id = rates.tax_rate_id
1955: FROM
1956: AP_TAX_CODES_ALL codes,
1957: ZX_REPORTING_TYPES_B reporting_types,
1958: ZX_REPORTING_CODES_B report_codes,
1959: ZX_RATES_B rates
1960:
1961:
1962: WHERE
1963: codes.tax_id = rates.tax_rate_id
2043: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2044: FROM
2045:
2046: AR_VAT_TAX_ALL_B codes,
2047: ZX_RATES_B rates,
2048: ZX_REPORTING_TYPES_B report_types,
2049: ZX_REPORTING_CODES_B report_codes
2050:
2051: WHERE
2081: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2082: FROM
2083:
2084: AR_VAT_TAX_ALL_B codes,
2085: ZX_RATES_B rates,
2086: ZX_REPORTING_TYPES_B report_types,
2087: ZX_REPORTING_CODES_B report_codes
2088:
2089: WHERE
2116: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2117: FROM
2118:
2119: AR_VAT_TAX_ALL_B codes,
2120: ZX_RATES_B rates,
2121: ZX_REPORTING_TYPES_B report_types,
2122: ZX_REPORTING_CODES_B report_codes
2123:
2124: WHERE
2151: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2152: FROM
2153:
2154: AR_VAT_TAX_ALL_B codes,
2155: ZX_RATES_B rates,
2156: ZX_REPORTING_TYPES_B report_types,
2157: ZX_REPORTING_CODES_B report_codes
2158:
2159: WHERE
2186: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2187: FROM
2188:
2189: AR_VAT_TAX_ALL_B codes,
2190: ZX_RATES_B rates,
2191: ZX_REPORTING_TYPES_B report_types,
2192: ZX_REPORTING_CODES_B report_codes
2193:
2194: WHERE
2221: NULL REPORTING_CODE_NUM_VALUE
2222:
2223: FROM
2224: AR_VAT_TAX_ALL_B codes,
2225: ZX_RATES_B rates,
2226: ZX_REPORTING_TYPES_B report_types
2227: WHERE
2228: codes.vat_tax_id = rates.tax_rate_id
2229: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
2255:
2256: FROM
2257:
2258: AR_VAT_TAX_ALL_B codes,
2259: ZX_RATES_B rates,
2260: ZX_REPORTING_TYPES_B report_types
2261: -- ZX_REPORTING_CODES_B report_codes
2262:
2263: WHERE
2290: NULL REPORTING_CODE_NUM_VALUE
2291: FROM
2292:
2293: AR_VAT_TAX_ALL_B codes,
2294: ZX_RATES_B rates,
2295: ZX_REPORTING_TYPES_B report_types
2296: -- ZX_REPORTING_CODES_B report_codes
2297:
2298: WHERE
2325: NULL REPORTING_CODE_NUM_VALUE
2326: FROM
2327:
2328: AR_VAT_TAX_ALL_B codes,
2329: ZX_RATES_B rates,
2330: ZX_REPORTING_TYPES_B report_types
2331: -- ZX_REPORTING_CODES_B report_codes
2332:
2333: WHERE
2362:
2363: FROM
2364:
2365: AR_VAT_TAX_ALL_B codes,
2366: ZX_RATES_B rates,
2367: ZX_REPORTING_TYPES_B report_types
2368: -- ZX_REPORTING_CODES_B report_codes
2369:
2370: WHERE
2397: NULL REPORTING_CODE_NUM_VALUE
2398: FROM
2399:
2400: AR_VAT_TAX_ALL_B codes,
2401: ZX_RATES_B rates,
2402: ZX_REPORTING_TYPES_B report_types
2403: -- ZX_REPORTING_CODES_B report_codes
2404:
2405: WHERE
2433:
2434: FROM
2435:
2436: AR_VAT_TAX_ALL_B codes,
2437: ZX_RATES_B rates,
2438: ZX_REPORTING_TYPES_B report_types
2439: -- ZX_REPORTING_CODES_B report_codes
2440:
2441: WHERE
2469:
2470: FROM
2471:
2472: AR_VAT_TAX_ALL_B codes,
2473: ZX_RATES_B rates,
2474: ZX_REPORTING_TYPES_B report_types,
2475: ZX_REPORTING_CODES_B report_codes
2476:
2477: WHERE
2506:
2507: FROM
2508:
2509: AR_VAT_TAX_ALL_B codes,
2510: ZX_RATES_B rates,
2511: ZX_REPORTING_TYPES_B report_types,
2512: ZX_REPORTING_CODES_B report_codes
2513:
2514: WHERE
2543:
2544: FROM
2545:
2546: AR_VAT_TAX_ALL_B codes,
2547: ZX_RATES_B rates,
2548: ZX_REPORTING_TYPES_B report_types,
2549: ZX_REPORTING_CODES_B report_codes
2550:
2551: WHERE
2580:
2581: FROM
2582:
2583: AR_VAT_TAX_ALL_B codes,
2584: ZX_RATES_B rates,
2585: ZX_REPORTING_TYPES_B report_types,
2586: ZX_REPORTING_CODES_B report_codes
2587:
2588: WHERE
2617:
2618: FROM
2619:
2620: AR_VAT_TAX_ALL_B codes,
2621: ZX_RATES_B rates,
2622: ZX_REPORTING_TYPES_B report_types,
2623: ZX_REPORTING_CODES_B report_codes
2624:
2625: WHERE
2654: report_codes.REPORTING_CODE_DATE_VALUE,
2655: report_codes.REPORTING_CODE_NUM_VALUE
2656: FROM
2657: AR_VAT_TAX_ALL_TL codes,
2658: ZX_RATES_B rates,
2659: ZX_REPORTING_TYPES_B report_types,
2660: ZX_REPORTING_CODES_B report_codes
2661:
2662: WHERE
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= 'CL_BILLS_OF_EXCH_TAX'
2736: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2755: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE
2756: FROM
2757: ZX_REPORTING_TYPES_B report_types,
2758: AR_VAT_TAX_ALL_B codes,
2759: ZX_RATES_B rates
2760:
2761: WHERE
2762: report_types.reporting_type_code= 'AR_MUNICIPAL_JUR'
2763: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2783: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2784: FROM
2785: ZX_REPORTING_TYPES_B report_types,
2786: AR_VAT_TAX_ALL_B codes,
2787: ZX_RATES_B rates
2788:
2789: WHERE
2790: report_types.reporting_type_code= 'PRINT TAX LINE'
2791: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2811: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2812: FROM
2813: ZX_REPORTING_TYPES_B report_types,
2814: AR_VAT_TAX_ALL_B codes,
2815: ZX_RATES_B rates
2816:
2817: WHERE
2818: report_types.reporting_type_code= 'PRINT TAX LINE'
2819: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2840: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2841: FROM
2842: ZX_REPORTING_TYPES_B report_types,
2843: AR_VAT_TAX_ALL_B codes,
2844: ZX_RATES_B rates
2845:
2846: WHERE
2847: report_types.reporting_type_code= 'PRINT TAX LINE'
2848: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2904: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE,
2905: rates.EFFECTIVE_FROM EFFECTIVE_FROM
2906: FROM
2907: AR_VAT_TAX_ALL_B codes,
2908: ZX_RATES_B rates,
2909: ZX_REPORTING_CODES_B report_codes,
2910: hr_locations loc
2911: WHERE
2912: codes.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'
3329: min(zx_rates.effective_from) effective_from,
3330: zx_rates.tax_regime_code l_tax_regime_code
3331: FROM
3332: ap_tax_codes_all codes,
3333: zx_rates_b zx_rates
3334: WHERE
3335: codes.tax_id = zx_rates.tax_rate_id
3336: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
3337: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'
3404: min(zx_rates.effective_from) effective_from,
3405: zx_rates.tax_regime_code l_tax_regime_code
3406: FROM
3407: ap_tax_codes_all codes,
3408: zx_rates_b zx_rates
3409: WHERE
3410: codes.tax_id = zx_rates.tax_rate_id
3411: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
3412: AND codes.global_attribute_category = 'JL.AR.APXTADTC.VAT'
3479: min(zx_rates.effective_from) effective_from,
3480: zx_rates.tax_regime_code l_tax_regime_code
3481: FROM
3482: ap_tax_codes_all codes,
3483: zx_rates_b zx_rates
3484: WHERE
3485: codes.tax_id = zx_rates.tax_rate_id
3486: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
3487: AND codes.global_attribute_category = 'JL.CL.APXTADTC.AP_TAX_CODES'
3919: zx_rates.tax_regime_code l_tax_regime_code
3920:
3921: FROM
3922: ap_tax_codes_all ap_tax,
3923: zx_rates_b zx_rates
3924: WHERE
3925: ap_tax.tax_id = zx_rates.tax_rate_id
3926: AND ap_tax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3927: AND zx_rates.record_type_code = 'MIGRATED'
3981: select
3982: distinct
3983: tax_id_values_and_codes.location_code l_location_code,
3984: zxrb.tax_regime_code l_tax_regime_code ,
3985: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
3986: from
3987: (
3988: select tax_id,hrloc.location_code location_code
3989: from ap_tax_codes_all aptax, hr_locations hrloc
3989: from ap_tax_codes_all aptax, hr_locations hrloc
3990: where aptax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3991: and aptax.global_attribute1 = to_char(hrloc.location_id)
3992: ) tax_id_values_and_codes,
3993: zx_rates_b zxrb
3994: where zxrb.tax_rate_id = tax_id_values_and_codes.tax_id
3995: and tax_id_values_and_codes.tax_id = nvl(p_tax_id,tax_id_values_and_codes.tax_id)
3996: and tax_id_values_and_codes.location_code is not null
3997: and not exists
4056: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
4057: FROM
4058: AP_TAX_CODES_ALL codes,
4059: HR_LOCATIONS hrloc,
4060: ZX_RATES_B rates,
4061: ZX_REPORTING_TYPES_B reporting_types,
4062: ZX_REPORTING_CODES_B report_codes
4063: WHERE
4064: codes.tax_id = rates.tax_rate_id
4517: min(zx_rates.effective_from) effective_from,
4518: zx_rates.tax_regime_code l_tax_regime_code
4519: FROM
4520: AR_VAT_TAX_ALL_B vat_tax,
4521: zx_rates_b zx_rates
4522: WHERE
4523: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4524: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)
4525: AND vat_tax.global_attribute_category = 'JE.PT.ARXSUVAT.TAX_INFO'
4699: min(zx_rates.effective_from) effective_from,
4700: zx_rates.tax_regime_code l_tax_regime_code
4701: FROM
4702: AR_VAT_TAX_ALL_B codes,
4703: zx_rates_b zx_rates
4704: WHERE
4705: codes.vat_tax_id = zx_rates.tax_rate_id
4706: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
4707: AND codes.global_attribute_category = 'JL.AR.ARXSUVAT.AR_VAT_TAX'
4776: zx_rates.tax_regime_code l_tax_regime_code
4777:
4778: FROM
4779: ar_vat_tax_all_b vat_tax,
4780: zx_rates_b zx_rates
4781: WHERE
4782: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4783: AND zx_rates.record_type_code = 'MIGRATED'
4784: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)
4851: printed_tax_name ,
4852: zxrb.tax_regime_code l_tax_regime_code ,
4853: zxrb.effective_from l_start_date
4854: from ar_vat_tax_all_tl avtl ,
4855: zx_rates_b zxrb
4856: where zxrb.tax_rate_id = cursor_rec.vat_tax_id
4857: and zxrb.tax_rate_id = avtl.vat_tax_id
4858: and language = l_language_code
4859: and printed_tax_name is not null
4922: -- Bug 5344337
4923: SELECT COUNT(1) INTO l_exists_cnt
4924: FROM
4925: ar_vat_tax_all_b vat_tax,
4926: zx_rates_b zx_rates
4927: WHERE
4928: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4929: AND zx_rates.record_type_code = 'MIGRATED';
4930:
5003: zx_rates.tax_regime_code l_tax_regime_code
5004:
5005: FROM
5006: ar_vat_tax_all_b vat_tax,
5007: zx_rates_b zx_rates
5008: WHERE
5009: vat_tax.vat_tax_id = zx_rates.tax_rate_id
5010: AND zx_rates.record_type_code = 'MIGRATED'
5011: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)
5067: adjustment_tax_code ,
5068: zxrb.tax_regime_code l_tax_regime_code ,
5069: min(zxrb.effective_from) l_start_date
5070: from ar_vat_tax_all_b avtb ,
5071: zx_rates_b zxrb
5072: where zxrb.tax_rate_id = avtb.vat_tax_id
5073: and adjustment_tax_code is not null
5074: and not exists
5075: ( select 1 from zx_reporting_codes_b where reporting_type_id =
5133: avtb.global_attribute5,
5134: zxrb.tax_regime_code l_tax_regime_code ,
5135: zxrb.effective_from l_start_date
5136: from ar_vat_tax_all_b avtb ,
5137: zx_rates_b zxrb
5138: where zxrb.tax_rate_id = avtb.vat_tax_id
5139: and avtb.global_attribute_category ='JL.CL.ARXSUVAT.VAT_TAX'
5140: and avtb.global_attribute5 is not null
5141: and not exists
5654: zx_rates.tax_regime_code l_tax_regime_code
5655:
5656: FROM
5657: ar_vat_tax_all_b ar_vat,
5658: zx_rates_b zx_rates
5659: WHERE
5660: ar_vat.vat_tax_id = zx_rates.tax_rate_id
5661: AND ar_vat.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'
5662: AND zx_rates.record_type_code = 'MIGRATED'
5717: select
5718: distinct
5719: tax_id_values_and_codes.location_code l_location_code,
5720: zxrb.tax_regime_code l_tax_regime_code ,
5721: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
5722: from
5723: (
5724: select vat_tax_id,hrloc.location_code location_code
5725: from ar_vat_tax_all_b artax, hr_locations hrloc
5725: from ar_vat_tax_all_b artax, hr_locations hrloc
5726: where artax.global_attribute_category = 'JA.KR.ARXSUVAT.VAT' -- Bug 5031787
5727: and artax.global_attribute1 = to_char(hrloc.location_id)
5728: ) tax_id_values_and_codes,
5729: zx_rates_b zxrb
5730: where zxrb.tax_rate_id = tax_id_values_and_codes.vat_tax_id
5731: and tax_id_values_and_codes.vat_tax_id = nvl(p_tax_id,tax_id_values_and_codes.vat_tax_id)
5732: and tax_id_values_and_codes.location_code is not null
5733: and not exists
5791: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
5792: FROM
5793: AR_VAT_TAX_ALL_B codes,
5794: HR_LOCATIONS hrloc,
5795: ZX_RATES_B rates,
5796: ZX_REPORTING_TYPES_B reporting_types,
5797: ZX_REPORTING_CODES_B report_codes
5798: WHERE
5799: codes.vat_tax_id = rates.tax_rate_id
5833: REPORTING_TYPE_ID ,
5834: OBJECT_VERSION_NUMBER
5835: )
5836: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5837: 'ZX_RATES_B' ,--ENTITY_CODE
5838: 'Y' ,--ENABLED_FLAG
5839: fnd_global.user_id ,--CREATED_BY
5840: SYSDATE ,--CREATION_DATE
5841: fnd_global.user_id ,--LAST_UPDATED_BY
5850: WHERE
5851: reporting_type_code = 'KR_BUSINESS_LOCATIONS'
5852: AND NOT EXISTS ( select 1 from zx_report_types_usages
5853: where reporting_type_id = rep_type.reporting_type_id and
5854: entity_code = 'ZX_RATES_B' );
5855: */
5856:
5857: IF PG_DEBUG = 'Y' THEN
5858: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AR(-)');
7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7033: 1 --OBJECT_VERSION_NUMBER
7034: )
7035: SELECT min(zx_rates.effective_from) effective_from
7036: FROM zx_rates_b zx_rates,
7037: zx_regimes_b zx_regimes
7038: WHERE zx_rates.tax_regime_code = zx_regimes.tax_regime_code
7039: AND zx_regimes.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7040: 'IT','KP','KR','NO','PL','PT','SK', 'IL')
7364: FROM
7365: AP_TAX_CODES_ALL codes,
7366: ZX_REPORTING_TYPES_B reporting_types,
7367: ZX_REPORTING_CODES_B report_codes,
7368: ZX_RATES_B rates,
7369: -- Bug 7620818
7370: ZX_REGIMES_B reg
7371: WHERE
7372: codes.tax_id = rates.tax_rate_id
7436: FROM
7437: AR_VAT_TAX_ALL codes,
7438: ZX_REPORTING_TYPES_B reporting_types,
7439: ZX_REPORTING_CODES_B report_codes,
7440: ZX_RATES_B rates,
7441: -- Bug 7620818
7442: ZX_REGIMES_B reg
7443: WHERE
7444: codes.vat_tax_id = rates.tax_rate_id
7546: 'REVERSE_CHARGE_VAT' l_reporting_type_code,
7547: rates.tax_regime_code l_tax_regime_code,
7548: rates.tax l_tax,
7549: min(rates.effective_from) l_effective_from
7550: FROM zx_rates_b rates,
7551: ar_vat_tax_all codes
7552: WHERE rates.tax_rate_id = codes.vat_tax_id
7553: AND codes.tax_type = 'REVERSE_CHARGE_VAT'
7554: AND rates.record_type_code = 'MIGRATED'
7789: FROM
7790: AR_VAT_TAX_ALL codes,
7791: ZX_REPORTING_TYPES_B reporting_types,
7792: ZX_REPORTING_CODES_B report_codes,
7793: ZX_RATES_B rates
7794: WHERE
7795: codes.vat_tax_id = rates.tax_rate_id
7796: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
7797: AND reporting_types.reporting_type_code ='REVERSE_CHARGE_VAT'
7900: 1
7901: )
7902: SELECT MIN(zx_rates.effective_from) effective_from
7903: FROM AR_VAT_TAX_ALL_B vat_tax,
7904: zx_rates_b zx_rates
7905: WHERE vat_tax.vat_tax_id = zx_rates.tax_rate_id
7906: AND zx_rates.record_type_code = ''MIGRATED''
7907: AND vat_tax.INTRA_EU_TRX_TYPE_CODE IS NOT NULL';
7908:
7968: 1
7969: )
7970: SELECT MIN(zx_rates.effective_from) effective_from
7971: FROM AR_VAT_TAX_ALL_B vat_tax,
7972: zx_rates_b zx_rates
7973: WHERE vat_tax.vat_tax_id = zx_rates.tax_rate_id
7974: AND zx_rates.record_type_code = ''MIGRATED''
7975: AND vat_tax.LGL_JUSTIFICATION_MSG_CODE IS NOT NULL';
7976:
8293: report_codes.REPORTING_CODE_DATE_VALUE,
8294: report_codes.REPORTING_CODE_NUM_VALUE
8295: FROM
8296: AR_VAT_TAX_ALL_B codes,
8297: ZX_RATES_B rates,
8298: ZX_REPORTING_TYPES_B report_types,
8299: ZX_REPORTING_CODES_B report_codes
8300: WHERE
8301: codes.vat_tax_id = rates.tax_rate_id AND
8361: report_codes.REPORTING_CODE_DATE_VALUE,
8362: report_codes.REPORTING_CODE_NUM_VALUE
8363: FROM
8364: AR_VAT_TAX_ALL_B codes,
8365: ZX_RATES_B rates,
8366: ZX_REPORTING_TYPES_B report_types,
8367: ZX_REPORTING_CODES_B report_codes
8368: WHERE
8369: codes.vat_tax_id = rates.tax_rate_id AND