[Home] [Help]
141: FROM zx_reporting_types_b
142: WHERE reporting_type_code = 'REPORTING_STATUS_TRACKING';
143:
144: INSERT
145: INTO ZX_REPORT_CODES_ASSOC(
146: REPORTING_CODE_ASSOC_ID,
147: ENTITY_CODE ,
148: ENTITY_ID ,
149: REPORTING_TYPE_ID ,
161: REPORTING_CODE_NUM_VALUE,
162: OBJECT_VERSION_NUMBER
163: )
164: SELECT
165: ZX_REPORT_CODES_ASSOC_S.nextval ,
166: 'ZX_TAXES' ,--ENTITY_CODE
167: TAX_ID ,--ENTITY_ID
168: l_reporting_type_id ,--REPORTING_TYPE_ID
169: NULL ,--REPORTING_CODE_ID
181: 1
182: from zx_taxes_b taxes
183: where legal_reporting_status_def_val = '000000000000000'
184: AND not EXISTS
185: ( SELECT 1 from ZX_REPORT_CODES_ASSOC
186: where entity_code = 'ZX_TAXES'
187: and entity_id = taxes.tax_id
188: and reporting_type_id = l_reporting_type_id
189: );
1209:
1210: -- Code for Reporting Code Association. Bug # 3594759
1211: -- Insert the Fiscal Printer Codes into Association table
1212: IF PG_DEBUG = 'Y' THEN
1213: arp_util_tax.debug('Entering into zx_report_codes_assoc insert statement');
1214: END IF;
1215: --Bug 5247324
1216: /*
1217: INSERT INTO ZX_REPORT_CODES_ASSOC(
1213: arp_util_tax.debug('Entering into zx_report_codes_assoc insert statement');
1214: END IF;
1215: --Bug 5247324
1216: /*
1217: INSERT INTO ZX_REPORT_CODES_ASSOC(
1218: REPORTING_CODE_ASSOC_ID,
1219: ENTITY_CODE,
1220: ENTITY_ID,
1221: REPORTING_TYPE_ID,
1229: LAST_UPDATE_DATE,
1230: LAST_UPDATE_LOGIN,
1231: OBJECT_VERSION_NUMBER)
1232: (SELECT
1233: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1234: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1235: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1236: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1237: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
1255: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1256: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1257: ptp.party_id = pvs.PARTY_SITE_ID
1258:
1259: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1260: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1261: and entity_id = ptp.Party_Tax_Profile_Id
1262: and reporting_type_id = types.reporting_type_id));
1263:
1263:
1264:
1265: -- Insert the CAI Number and Date into Association table
1266:
1267: INSERT INTO ZX_REPORT_CODES_ASSOC(
1268: REPORTING_CODE_ASSOC_ID,
1269: ENTITY_CODE,
1270: ENTITY_ID,
1271: REPORTING_TYPE_ID,
1279: LAST_UPDATE_DATE,
1280: LAST_UPDATE_LOGIN,
1281: OBJECT_VERSION_NUMBER)
1282: (SELECT
1283: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1284: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1285: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1286: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1287: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
1303: types.reporting_type_code = 'CAI NUMBER' and
1304: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1305: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1306: ptp.party_id = pvs.PARTY_SITE_ID
1307: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1308: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1309: and entity_id = ptp.Party_Tax_Profile_Id
1310: and reporting_type_id = types.reporting_type_id));
1311: */
1312:
1313: --BugFix 3557652 REPORTING CODE ASSOC IMPL FOR ARGENTINE DGI TRANSACTION CODE
1314: --Association for Reporting Type Code AR_DGI_TRX_CODE
1315: INSERT INTO
1316: ZX_REPORT_CODES_ASSOC(
1317: REPORTING_CODE_ASSOC_ID,
1318: ENTITY_CODE ,
1319: ENTITY_ID ,
1320: REPORTING_TYPE_ID ,
1332: REPORTING_CODE_NUM_VALUE,
1333: OBJECT_VERSION_NUMBER
1334: )
1335: (SELECT
1336: ZX_REPORT_CODES_ASSOC_S.nextval ,
1337: 'ZX_RATES' ,--ENTITY_CODE
1338: rates.TAX_RATE_ID ,--ENTITY_ID
1339: report_codes.REPORTING_TYPE_ID ,
1340: report_codes.REPORTING_CODE_ID ,
1364: AND rates.record_type_code = 'MIGRATED'
1365: AND report_codes.record_type_code = 'MIGRATED'
1366:
1367:
1368: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1369: where entity_code = 'ZX_RATES'
1370: and entity_id = rates.tax_rate_id
1371: and reporting_type_id =
1372: report_codes.reporting_type_id)
1376: END IF; -- end of Argentina Installation verification
1377:
1378: --Association for Reporting Type Code PT_ANL_REC_TAX_BOX
1379: INSERT
1380: INTO ZX_REPORT_CODES_ASSOC(
1381: REPORTING_CODE_ASSOC_ID,
1382: ENTITY_CODE ,
1383: ENTITY_ID ,
1384: REPORTING_TYPE_ID ,
1396: REPORTING_CODE_NUM_VALUE,
1397: OBJECT_VERSION_NUMBER
1398: )
1399: SELECT
1400: ZX_REPORT_CODES_ASSOC_S.nextval ,
1401: 'ZX_RATES' ,--ENTITY_CODE
1402: TAX_RATE_ID ,--ENTITY_ID
1403: REPORTING_TYPE_ID ,
1404: REPORTING_CODE_ID ,
1439: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1440: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1441: AND report_codes.record_type_code = 'MIGRATED'
1442:
1443: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1444: where entity_code = 'ZX_RATES'
1445: and entity_id = rates.tax_rate_id
1446: and reporting_type_id =
1447: report_codes.reporting_type_id)
1471: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1472: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1473: AND report_codes.record_type_code = 'MIGRATED'
1474:
1475: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1476: where entity_code = 'ZX_RATES'
1477: and entity_id = rates.tax_rate_id
1478: and reporting_type_id =
1479: report_codes.reporting_type_id)
1502: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1503: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1504: AND report_codes.record_type_code = 'MIGRATED'
1505:
1506: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1507: where entity_code = 'ZX_RATES'
1508: and entity_id = rates.tax_rate_id
1509: and reporting_type_id =
1510: report_codes.reporting_type_id)
1533: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1534: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1535: AND report_codes.record_type_code = 'MIGRATED'
1536:
1537: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1538: where entity_code = 'ZX_RATES'
1539: and entity_id = rates.tax_rate_id
1540: and reporting_type_id =
1541: report_codes.reporting_type_id)
1564: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1565: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1566: AND report_codes.record_type_code = 'MIGRATED'
1567:
1568: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1569: where entity_code = 'ZX_RATES'
1570: and entity_id = rates.tax_rate_id
1571: and reporting_type_id =
1572: report_codes.reporting_type_id)
1595: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1596: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1597: AND report_codes.record_type_code = 'MIGRATED'
1598:
1599: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1600: where entity_code = 'ZX_RATES'
1601: and entity_id = rates.tax_rate_id
1602: and reporting_type_id =
1603: report_codes.reporting_type_id)
1629: AND reporting_types.reporting_type_code = 'PT_PRD_TAXABLE_BOX'
1630: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1631: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1632: -- AND report_codes.record_type_code = 'MIGRATED'
1633: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1634: where entity_code = 'ZX_RATES'
1635: and entity_id = rates.tax_rate_id
1636: and reporting_type_id =
1637: reporting_types.reporting_type_id)
1660: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1661: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1662: -- AND report_codes.record_type_code = 'MIGRATED'
1663:
1664: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1665: where entity_code = 'ZX_RATES'
1666: and entity_id = rates.tax_rate_id
1667: and reporting_type_id =
1668: reporting_types.reporting_type_id)
1691: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1692: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1693: -- AND report_codes.record_type_code = 'MIGRATED'
1694:
1695: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1696: where entity_code = 'ZX_RATES'
1697: and entity_id = rates.tax_rate_id
1698: and reporting_type_id =
1699: reporting_types.reporting_type_id)
1722: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1723: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1724: -- AND report_codes.record_type_code = 'MIGRATED'
1725:
1726: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1727: where entity_code = 'ZX_RATES'
1728: and entity_id = rates.tax_rate_id
1729: and reporting_type_id =
1730: reporting_types.reporting_type_id)
1755: AND rates.record_type_code = 'MIGRATED'
1756:
1757: -- AND report_codes.record_type_code = 'MIGRATED'
1758:
1759: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1760: where entity_code = 'ZX_RATES'
1761: and entity_id = rates.tax_rate_id
1762: and reporting_type_id =
1763: reporting_types.reporting_type_id)
1787: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1788: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1789: -- AND report_codes.record_type_code = 'MIGRATED'
1790:
1791: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1792: where entity_code = 'ZX_RATES'
1793: and entity_id = rates.tax_rate_id
1794: and reporting_type_id =
1795: reporting_types.reporting_type_id));
1796:
1797: -- Bug # 3935161. Association for 'MEMBER STATE'
1798: IF L_MULTI_ORG_FLAG = 'Y'
1799: THEN
1800: INSERT INTO ZX_REPORT_CODES_ASSOC(
1801: REPORTING_CODE_ASSOC_ID,
1802: ENTITY_CODE,
1803: ENTITY_ID,
1804: REPORTING_TYPE_ID,
1815: LAST_UPDATE_DATE,
1816: LAST_UPDATE_LOGIN,
1817: OBJECT_VERSION_NUMBER) -- Bug 5031787
1818: (SELECT
1819: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1820: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1821: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1822: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1823: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1847: AND etb.legal_entity_id = fin_sys_param.org_id -- Bug 5031787
1848: AND ptp.party_id = etb.party_id
1849: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1850:
1851: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1852: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1853: and entity_id = ptp.Party_Tax_Profile_Id
1854: and reporting_type_id = types.reporting_type_id));
1855: ELSE
1852: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1853: and entity_id = ptp.Party_Tax_Profile_Id
1854: and reporting_type_id = types.reporting_type_id));
1855: ELSE
1856: INSERT INTO ZX_REPORT_CODES_ASSOC(
1857: REPORTING_CODE_ASSOC_ID,
1858: ENTITY_CODE,
1859: ENTITY_ID,
1860: REPORTING_TYPE_ID,
1871: LAST_UPDATE_DATE,
1872: LAST_UPDATE_LOGIN,
1873: OBJECT_VERSION_NUMBER) -- Bug 5031787
1874: (SELECT
1875: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1876: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1877: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1878: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1879: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1904: AND etb.legal_entity_id = l_org_id
1905: AND ptp.party_id = etb.party_id
1906: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1907:
1908: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1909: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1910: and entity_id = ptp.Party_Tax_Profile_Id
1911: and reporting_type_id = types.reporting_type_id));
1912: END IF;
1914:
1915:
1916: --Bug 3922583
1917: INSERT
1918: INTO ZX_REPORT_CODES_ASSOC(
1919: REPORTING_CODE_ASSOC_ID,
1920: ENTITY_CODE ,
1921: ENTITY_ID ,
1922: REPORTING_TYPE_ID ,
1934: REPORTING_CODE_NUM_VALUE,
1935: OBJECT_VERSION_NUMBER
1936: )
1937: SELECT
1938: ZX_REPORT_CODES_ASSOC_S.nextval ,
1939: 'ZX_RATES' ,--ENTITY_CODE
1940: rates.TAX_RATE_ID ,--ENTITY_ID
1941: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
1942: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
1969: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1970: AND report_codes.record_type_code = 'MIGRATED'
1971: AND rates.record_type_code = 'MIGRATED'
1972:
1973: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1974: where entity_code = 'ZX_RATES'
1975: and entity_id = rates.tax_rate_id
1976: and reporting_type_id =
1977: report_codes.reporting_type_id);
1993: /* Create the Reporting Code association*/
1994: --Association for Reporting Type Code PT_ANL_TAX_BOX
1995: arp_util_tax.debug('ZX_REPORTING_ASSOC_AR(+)');
1996: INSERT
1997: INTO ZX_REPORT_CODES_ASSOC(
1998: REPORTING_CODE_ASSOC_ID,
1999: ENTITY_CODE ,
2000: ENTITY_ID ,
2001: REPORTING_TYPE_ID ,
2013: REPORTING_CODE_NUM_VALUE,
2014: OBJECT_VERSION_NUMBER
2015: )
2016: SELECT
2017: ZX_REPORT_CODES_ASSOC_S.nextval ,
2018: 'ZX_RATES' ,--ENTITY_CODE
2019: TAX_RATE_ID ,--ENTITY_ID
2020: REPORTING_TYPE_ID ,
2021: REPORTING_CODE_ID ,
2060: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2061: AND report_codes.record_type_code = 'MIGRATED'
2062:
2063:
2064: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2065: where entity_code = 'ZX_RATES'
2066: and entity_id = rates.tax_rate_id
2067: and reporting_type_id =
2068: report_codes.reporting_type_id)
2097: AND report_types.REPORTING_TYPE_CODE= 'CZ_TAX_ORIGIN'
2098: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2099: AND report_codes.record_type_code = 'MIGRATED'
2100:
2101: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2102: where entity_code = 'ZX_RATES'
2103: and entity_id = rates.tax_rate_id
2104: and reporting_type_id =
2105: report_codes.reporting_type_id)
2132: AND report_types.REPORTING_TYPE_CODE= 'HU_TAX_ORIGIN'
2133: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2134: AND report_codes.record_type_code = 'MIGRATED'
2135:
2136: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2137: where entity_code = 'ZX_RATES'
2138: and entity_id = rates.tax_rate_id
2139: and reporting_type_id =
2140: report_codes.reporting_type_id)
2167: AND report_types.REPORTING_TYPE_CODE= 'PL_TAX_ORIGIN'
2168: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2169: AND report_codes.record_type_code = 'MIGRATED'
2170:
2171: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2172: where entity_code = 'ZX_RATES'
2173: and entity_id = rates.tax_rate_id
2174: and reporting_type_id =
2175: report_codes.reporting_type_id)
2202: AND report_types.REPORTING_TYPE_CODE= 'TW_GOVERNMENT_TAX_TYPE'
2203: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2204: AND report_codes.record_type_code = 'MIGRATED'
2205:
2206: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2207: where entity_code = 'ZX_RATES'
2208: and entity_id = rates.tax_rate_id
2209: and reporting_type_id =
2210: report_codes.reporting_type_id)
2232: AND report_types.REPORTING_TYPE_CODE= 'CL_DEBIT_ACCOUNT'
2233: AND report_types.tax_regime_code = rates.tax_regime_code
2234: AND codes.global_attribute5 IS NOT NULL
2235:
2236: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2237: where entity_code = 'ZX_RATES'
2238: and entity_id = rates.tax_rate_id
2239: and reporting_type_id =
2240: report_types.reporting_type_id)
2273: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2274: -- AND report_codes.record_type_code = 'MIGRATED'
2275:
2276:
2277: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2278: where entity_code = 'ZX_RATES'
2279: and entity_id = rates.tax_rate_id
2280: and reporting_type_id =
2281: report_types.reporting_type_id)
2308: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2309: -- AND report_codes.record_type_code = 'MIGRATED'
2310:
2311:
2312: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2313: where entity_code = 'ZX_RATES'
2314: and entity_id = rates.tax_rate_id
2315: and reporting_type_id =
2316: report_types.reporting_type_id)
2343: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2344: -- AND report_codes.record_type_code = 'MIGRATED'
2345:
2346:
2347: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2348: where entity_code = 'ZX_RATES'
2349: and entity_id = rates.tax_rate_id
2350: and reporting_type_id =
2351: report_types.reporting_type_id)
2380: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2381: -- AND report_codes.record_type_code = 'MIGRATED'
2382:
2383:
2384: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2385: where entity_code = 'ZX_RATES'
2386: and entity_id = rates.tax_rate_id
2387: and reporting_type_id =
2388: report_types.reporting_type_id)
2415: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2416: -- AND report_codes.record_type_code = 'MIGRATED'
2417:
2418:
2419: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2420: where entity_code = 'ZX_RATES'
2421: and entity_id = rates.tax_rate_id
2422: and reporting_type_id =
2423: report_types.reporting_type_id)
2450: AND report_types.REPORTING_TYPE_CODE= 'PT_ANL_REC_TAX_BOX'
2451: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2452: -- AND report_codes.record_type_code = 'MIGRATED'
2453:
2454: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2455: where entity_code = 'ZX_RATES'
2456: and entity_id = rates.tax_rate_id
2457: and reporting_type_id =
2458: report_types.reporting_type_id)
2486: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2487: AND report_codes.record_type_code = 'MIGRATED'
2488:
2489:
2490: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2491: where entity_code = 'ZX_RATES'
2492: and entity_id = rates.tax_rate_id
2493: and reporting_type_id =
2494: report_codes.reporting_type_id)
2523: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2524: AND report_codes.record_type_code = 'MIGRATED'
2525:
2526:
2527: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2528: where entity_code = 'ZX_RATES'
2529: and entity_id = rates.tax_rate_id
2530: and reporting_type_id =
2531: report_codes.reporting_type_id)
2560: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2561: AND report_codes.record_type_code = 'MIGRATED'
2562:
2563:
2564: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2565: where entity_code = 'ZX_RATES'
2566: and entity_id = rates.tax_rate_id
2567: and reporting_type_id =
2568: report_codes.reporting_type_id)
2597: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2598: AND report_codes.record_type_code = 'MIGRATED'
2599:
2600:
2601: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2602: where entity_code = 'ZX_RATES'
2603: and entity_id = rates.tax_rate_id
2604: and reporting_type_id =
2605: report_codes.reporting_type_id)
2634: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2635: AND report_codes.record_type_code = 'MIGRATED'
2636:
2637:
2638: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2639: where entity_code = 'ZX_RATES'
2640: and entity_id = rates.tax_rate_id
2641: and reporting_type_id =
2642: report_codes.reporting_type_id)
2670: AND report_types.REPORTING_TYPE_CODE= 'PRINTED_TAX_RATE_NAME'
2671: AND report_codes.record_type_code = 'MIGRATED'
2672:
2673:
2674: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2675: where entity_code = 'ZX_RATES'
2676: and entity_id = rates.tax_rate_id
2677: and reporting_type_id =
2678: report_codes.reporting_type_id)
2680:
2681: -- To handle 'YES_NO' DataType - Reporting Type Codes
2682:
2683: INSERT
2684: INTO ZX_REPORT_CODES_ASSOC(
2685: REPORTING_CODE_ASSOC_ID,
2686: ENTITY_CODE ,
2687: ENTITY_ID ,
2688: REPORTING_TYPE_ID ,
2700: REPORTING_CODE_NUM_VALUE,
2701: OBJECT_VERSION_NUMBER
2702: )
2703: SELECT
2704: ZX_REPORT_CODES_ASSOC_S.nextval ,
2705: 'ZX_RATES' ,--ENTITY_CODE
2706: TAX_RATE_ID ,--ENTITY_ID
2707: REPORTING_TYPE_ID ,
2708: NULL ,--REPORTING_CODE_ID
2739: AND codes.global_attribute_category = 'JL.CL.ARXSUVAT.VAT_TAX'
2740: AND rates.record_type_code = 'MIGRATED'
2741: AND codes.global_attribute6 IS NOT NULL
2742:
2743: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2744: where entity_code = 'ZX_RATES'
2745: and entity_id = rates.tax_rate_id
2746: and reporting_type_id =
2747: report_types.reporting_type_id)
2766: AND codes.global_attribute_category = 'JL.AR.ARXSUVAT.AR_VAT_TAX'
2767: AND rates.record_type_code = 'MIGRATED'
2768: AND codes.global_attribute6 IS NOT NULL
2769:
2770: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2771: where entity_code = 'ZX_RATES'
2772: and entity_id = rates.tax_rate_id
2773: and reporting_type_id =
2774: report_types.reporting_type_id)
2795: AND rates.record_type_code = 'MIGRATED'
2796: AND codes.global_attribute2 IS NOT NULL
2797:
2798:
2799: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2800: where entity_code = 'ZX_RATES'
2801: and entity_id = rates.tax_rate_id
2802: and reporting_type_id =
2803: report_types.reporting_type_id)
2823: AND rates.record_type_code = 'MIGRATED'
2824: AND codes.global_attribute2 IS NOT NULL
2825:
2826:
2827: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2828: where entity_code = 'ZX_RATES'
2829: and entity_id = rates.tax_rate_id
2830: and reporting_type_id =
2831: report_types.reporting_type_id)
2851: AND codes.global_attribute_category = 'JL.CO.ARXSUVAT.AR_VAT_TAX'
2852: AND rates.record_type_code = 'MIGRATED'
2853: AND codes.global_attribute2 IS NOT NULL
2854:
2855: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2856: where entity_code = 'ZX_RATES'
2857: and entity_id = rates.tax_rate_id
2858: and reporting_type_id =
2859: report_types.reporting_type_id)
2861: );
2862:
2863: -- YK:9/22/2004: Korean GDF
2864: INSERT
2865: INTO ZX_REPORT_CODES_ASSOC(
2866: REPORTING_CODE_ASSOC_ID,
2867: ENTITY_CODE ,
2868: ENTITY_ID ,
2869: REPORTING_TYPE_ID ,
2880: LAST_UPDATE_LOGIN ,
2881: OBJECT_VERSION_NUMBER
2882: )
2883: SELECT
2884: ZX_REPORT_CODES_ASSOC_S.nextval ,
2885: 'ZX_RATES' ,--ENTITY_CODE
2886: TAX_RATE_ID ,--ENTITY_ID
2887: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID
2888: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
2915: AND report_codes.reporting_code_char_value = loc.location_code
2916: AND report_codes.record_type_code = 'MIGRATED'
2917: AND rates.record_type_code = 'MIGRATED'
2918: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
2919: AND not exists( select 1 from ZX_REPORT_CODES_ASSOC
2920: where entity_code = 'ZX_RATES'
2921: and entity_id = rates.tax_rate_id
2922: and reporting_type_id = report_codes.reporting_type_id)
2923: );
4006: -- Creation of reporting codes associations for KR_BUSINESS_LOCATIONS
4007:
4008:
4009: INSERT
4010: INTO ZX_REPORT_CODES_ASSOC(
4011: REPORTING_CODE_ASSOC_ID,
4012: ENTITY_CODE ,
4013: ENTITY_ID ,
4014: REPORTING_TYPE_ID ,
4026: REPORTING_CODE_NUM_VALUE,
4027: OBJECT_VERSION_NUMBER
4028: )
4029: SELECT
4030: ZX_REPORT_CODES_ASSOC_S.nextval ,
4031: 'ZX_RATES' ,--ENTITY_CODE
4032: TAX_RATE_ID ,--ENTITY_ID
4033: REPORTING_TYPE_ID ,
4034: REPORTING_CODE_ID ,
4071: AND reporting_types.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
4072: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
4073: AND report_codes.record_type_code = 'MIGRATED'
4074:
4075: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
4076: where entity_code = 'ZX_RATES'
4077: and entity_id = rates.tax_rate_id
4078: and reporting_type_id =
4079: report_codes.reporting_type_id)
5741: --Bug Fix 4671652
5742: --Creation of Reporting Codes Associations for KR_BUSINESS_LOCATIONS
5743:
5744: INSERT
5745: INTO ZX_REPORT_CODES_ASSOC(
5746: REPORTING_CODE_ASSOC_ID,
5747: ENTITY_CODE ,
5748: ENTITY_ID ,
5749: REPORTING_TYPE_ID ,
5761: REPORTING_CODE_NUM_VALUE,
5762: OBJECT_VERSION_NUMBER
5763: )
5764: SELECT
5765: ZX_REPORT_CODES_ASSOC_S.nextval ,
5766: 'ZX_RATES' ,--ENTITY_CODE
5767: TAX_RATE_ID ,--ENTITY_ID
5768: REPORTING_TYPE_ID ,
5769: REPORTING_CODE_ID ,
5806: AND reporting_types.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
5807: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
5808: AND report_codes.record_type_code = 'MIGRATED'
5809:
5810: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
5811: where entity_code = 'ZX_RATES'
5812: and entity_id = rates.tax_rate_id
5813: and reporting_type_id =
5814: report_codes.reporting_type_id)
5904: BEGIN
5905: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(+)');
5906: arp_util_tax.debug('p_rep_type_info='||p_rep_type_info);
5907:
5908: INSERT INTO ZX_REPORT_CODES_ASSOC(
5909: REPORTING_CODE_ASSOC_ID,
5910: ENTITY_CODE,
5911: ENTITY_ID,
5912: REPORTING_TYPE_ID,
5920: LAST_UPDATE_DATE,
5921: LAST_UPDATE_LOGIN,
5922: OBJECT_VERSION_NUMBER)
5923: SELECT
5924: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
5925: 'ZX_PARTY_TAX_PROFILE' , --ENTITY_CODE
5926: p_ptp_id , --ENTITY_ID
5927: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
5928: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE
5940: WHERE REPORTING_TYPE_CODE=p_reporting_type_code
5941:
5942: AND NOT EXISTS (SELECT 1 FROM
5943: ZX_REPORTING_TYPES_B RTB,
5944: ZX_REPORT_CODES_ASSOC RCA
5945: WHERE
5946:
5947: RTB.REPORTING_TYPE_ID = RCA.REPORTING_TYPE_ID
5948: AND RTB.REPORTING_TYPE_CODE = p_reporting_type_code
7320: BEGIN
7321: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(+)');
7322: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7323:
7324: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7325:
7326: INSERT
7327: INTO ZX_REPORT_CODES_ASSOC(
7328: REPORTING_CODE_ASSOC_ID,
7323:
7324: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7325:
7326: INSERT
7327: INTO ZX_REPORT_CODES_ASSOC(
7328: REPORTING_CODE_ASSOC_ID,
7329: ENTITY_CODE ,
7330: ENTITY_ID ,
7331: REPORTING_TYPE_ID ,
7343: REPORTING_CODE_NUM_VALUE,
7344: OBJECT_VERSION_NUMBER
7345: )
7346: SELECT
7347: ZX_REPORT_CODES_ASSOC_S.nextval ,
7348: 'ZX_RATES' ,--ENTITY_CODE
7349: rates.TAX_RATE_ID ,--ENTITY_ID
7350: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7351: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7386: AND rates.tax_regime_code = reg.tax_regime_code
7387: AND reg.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7388: 'IT','KP','KR','NO','PL','PT','SK', 'IL')
7389: -- End Bug 7620818
7390: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
7391: where entity_code = 'ZX_RATES'
7392: and entity_id = rates.tax_rate_id
7393: and reporting_type_id =
7394: report_codes.reporting_type_id);
7392: and entity_id = rates.tax_rate_id
7393: and reporting_type_id =
7394: report_codes.reporting_type_id);
7395:
7396: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AR tax codes');
7397:
7398: INSERT
7399: INTO ZX_REPORT_CODES_ASSOC(
7400: REPORTING_CODE_ASSOC_ID,
7395:
7396: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AR tax codes');
7397:
7398: INSERT
7399: INTO ZX_REPORT_CODES_ASSOC(
7400: REPORTING_CODE_ASSOC_ID,
7401: ENTITY_CODE ,
7402: ENTITY_ID ,
7403: REPORTING_TYPE_ID ,
7415: REPORTING_CODE_NUM_VALUE,
7416: OBJECT_VERSION_NUMBER
7417: )
7418: SELECT
7419: ZX_REPORT_CODES_ASSOC_S.nextval ,
7420: 'ZX_RATES' ,--ENTITY_CODE
7421: rates.TAX_RATE_ID ,--ENTITY_ID
7422: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7423: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7455: AND rates.tax_regime_code = reg.tax_regime_code
7456: AND reg.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7457: 'IT','KP','KR','NO','PL','PT','SK', 'IL')
7458: -- End Bug 7620818
7459: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
7460: where entity_code = 'ZX_RATES'
7461: and entity_id = rates.tax_rate_id
7462: and reporting_type_id = report_codes.reporting_type_id);
7463:
7745: from ZX_REPORTING_CODES_TL T
7746: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7747: and T.LANGUAGE = L.LANGUAGE_CODE);
7748:
7749: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');
7750:
7751: INSERT
7752: INTO ZX_REPORT_CODES_ASSOC(
7753: REPORTING_CODE_ASSOC_ID,
7748:
7749: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');
7750:
7751: INSERT
7752: INTO ZX_REPORT_CODES_ASSOC(
7753: REPORTING_CODE_ASSOC_ID,
7754: ENTITY_CODE ,
7755: ENTITY_ID ,
7756: REPORTING_TYPE_ID ,
7768: REPORTING_CODE_NUM_VALUE,
7769: OBJECT_VERSION_NUMBER
7770: )
7771: SELECT
7772: ZX_REPORT_CODES_ASSOC_S.nextval ,
7773: 'ZX_RATES' ,--ENTITY_CODE
7774: rates.TAX_RATE_ID ,--ENTITY_ID
7775: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7776: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7799: AND reporting_types.tax_regime_code = rates.tax_regime_code
7800: AND reporting_types.tax = rates.tax
7801: --AND report_codes.record_type_code = 'MIGRATED'
7802: AND rates.record_type_code = 'MIGRATED'
7803: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
7804: where entity_code = 'ZX_RATES'
7805: and entity_id = rates.tax_rate_id
7806: and reporting_type_id = report_codes.reporting_type_id);
7807:
8246:
8247: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EUVAT(+)');
8248:
8249: dyn_sql_stmt:=
8250: 'INSERT INTO ZX_REPORT_CODES_ASSOC
8251: (REPORTING_CODE_ASSOC_ID,
8252: ENTITY_CODE,
8253: ENTITY_ID,
8254: REPORTING_TYPE_ID,
8265: REPORTING_CODE_DATE_VALUE,
8266: REPORTING_CODE_NUM_VALUE,
8267: OBJECT_VERSION_NUMBER)
8268: SELECT
8269: ZX_REPORT_CODES_ASSOC_S.nextval,
8270: ''ZX_RATES'',
8271: TAX_RATE_ID,
8272: REPORTING_TYPE_ID,
8273: REPORTING_CODE_ID,
8305: report_types.REPORTING_TYPE_CODE = ''ZX_LGL_JUSTIFICATN_MSG_TYPE'' AND
8306: report_codes.record_type_code = ''MIGRATED'' AND
8307: NOT EXISTS
8308: (SELECT 1
8309: FROM ZX_REPORT_CODES_ASSOC
8310: WHERE entity_code = ''ZX_RATES''
8311: AND entity_id = rates.tax_rate_id
8312: AND reporting_type_id = report_codes.reporting_type_id
8313: AND reporting_code_id = report_codes.reporting_code_id))';
8314:
8315: EXECUTE IMMEDIATE dyn_sql_stmt;
8316:
8317: dyn_sql_stmt:=
8318: 'INSERT INTO ZX_REPORT_CODES_ASSOC
8319: (REPORTING_CODE_ASSOC_ID,
8320: ENTITY_CODE,
8321: ENTITY_ID,
8322: REPORTING_TYPE_ID,
8333: REPORTING_CODE_DATE_VALUE,
8334: REPORTING_CODE_NUM_VALUE,
8335: OBJECT_VERSION_NUMBER)
8336: SELECT
8337: ZX_REPORT_CODES_ASSOC_S.nextval,
8338: ''ZX_RATES'',
8339: TAX_RATE_ID,
8340: REPORTING_TYPE_ID,
8341: REPORTING_CODE_ID,
8373: report_types.REPORTING_TYPE_CODE = ''ZX_INTRA_EU_TRX_TYPE'' AND
8374: report_codes.record_type_code = ''MIGRATED'' AND
8375: NOT EXISTS
8376: (SELECT 1
8377: FROM ZX_REPORT_CODES_ASSOC
8378: WHERE entity_code = ''ZX_RATES''
8379: AND entity_id = rates.tax_rate_id
8380: AND reporting_type_id = report_codes.reporting_type_id
8381: AND reporting_code_id = report_codes.reporting_code_id))';