[Home] [Help]
126: FROM zx_reporting_types_b
127: WHERE reporting_type_code = 'REPORTING_STATUS_TRACKING';
128:
129: INSERT
130: INTO ZX_REPORT_CODES_ASSOC(
131: REPORTING_CODE_ASSOC_ID,
132: ENTITY_CODE ,
133: ENTITY_ID ,
134: REPORTING_TYPE_ID ,
146: REPORTING_CODE_NUM_VALUE,
147: OBJECT_VERSION_NUMBER
148: )
149: SELECT
150: ZX_REPORT_CODES_ASSOC_S.nextval ,
151: 'ZX_TAXES' ,--ENTITY_CODE
152: TAX_ID ,--ENTITY_ID
153: l_reporting_type_id ,--REPORTING_TYPE_ID
154: NULL ,--REPORTING_CODE_ID
166: 1
167: from zx_taxes_b taxes
168: where legal_reporting_status_def_val = '000000000000000'
169: AND not EXISTS
170: ( SELECT 1 from ZX_REPORT_CODES_ASSOC
171: where entity_code = 'ZX_TAXES'
172: and entity_id = taxes.tax_id
173: and reporting_type_id = l_reporting_type_id
174: );
1194:
1195: -- Code for Reporting Code Association. Bug # 3594759
1196: -- Insert the Fiscal Printer Codes into Association table
1197: IF PG_DEBUG = 'Y' THEN
1198: arp_util_tax.debug('Entering into zx_report_codes_assoc insert statement');
1199: END IF;
1200: --Bug 5247324
1201: /*
1202: INSERT INTO ZX_REPORT_CODES_ASSOC(
1198: arp_util_tax.debug('Entering into zx_report_codes_assoc insert statement');
1199: END IF;
1200: --Bug 5247324
1201: /*
1202: INSERT INTO ZX_REPORT_CODES_ASSOC(
1203: REPORTING_CODE_ASSOC_ID,
1204: ENTITY_CODE,
1205: ENTITY_ID,
1206: REPORTING_TYPE_ID,
1214: LAST_UPDATE_DATE,
1215: LAST_UPDATE_LOGIN,
1216: OBJECT_VERSION_NUMBER)
1217: (SELECT
1218: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1219: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1220: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1221: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1222: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
1240: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1241: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1242: ptp.party_id = pvs.PARTY_SITE_ID
1243:
1244: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1245: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1246: and entity_id = ptp.Party_Tax_Profile_Id
1247: and reporting_type_id = types.reporting_type_id));
1248:
1248:
1249:
1250: -- Insert the CAI Number and Date into Association table
1251:
1252: INSERT INTO ZX_REPORT_CODES_ASSOC(
1253: REPORTING_CODE_ASSOC_ID,
1254: ENTITY_CODE,
1255: ENTITY_ID,
1256: REPORTING_TYPE_ID,
1264: LAST_UPDATE_DATE,
1265: LAST_UPDATE_LOGIN,
1266: OBJECT_VERSION_NUMBER)
1267: (SELECT
1268: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1269: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1270: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1271: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1272: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
1288: types.reporting_type_code = 'CAI NUMBER' and
1289: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1290: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1291: ptp.party_id = pvs.PARTY_SITE_ID
1292: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1293: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1294: and entity_id = ptp.Party_Tax_Profile_Id
1295: and reporting_type_id = types.reporting_type_id));
1296: */
1297:
1298: --BugFix 3557652 REPORTING CODE ASSOC IMPL FOR ARGENTINE DGI TRANSACTION CODE
1299: --Association for Reporting Type Code AR_DGI_TRX_CODE
1300: INSERT INTO
1301: ZX_REPORT_CODES_ASSOC(
1302: REPORTING_CODE_ASSOC_ID,
1303: ENTITY_CODE ,
1304: ENTITY_ID ,
1305: REPORTING_TYPE_ID ,
1317: REPORTING_CODE_NUM_VALUE,
1318: OBJECT_VERSION_NUMBER
1319: )
1320: (SELECT
1321: ZX_REPORT_CODES_ASSOC_S.nextval ,
1322: 'ZX_RATES' ,--ENTITY_CODE
1323: rates.TAX_RATE_ID ,--ENTITY_ID
1324: report_codes.REPORTING_TYPE_ID ,
1325: report_codes.REPORTING_CODE_ID ,
1349: AND rates.record_type_code = 'MIGRATED'
1350: AND report_codes.record_type_code = 'MIGRATED'
1351:
1352:
1353: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1354: where entity_code = 'ZX_RATES'
1355: and entity_id = rates.tax_rate_id
1356: and reporting_type_id =
1357: report_codes.reporting_type_id)
1361: END IF; -- end of Argentina Installation verification
1362:
1363: --Association for Reporting Type Code PT_ANL_REC_TAX_BOX
1364: INSERT
1365: INTO ZX_REPORT_CODES_ASSOC(
1366: REPORTING_CODE_ASSOC_ID,
1367: ENTITY_CODE ,
1368: ENTITY_ID ,
1369: REPORTING_TYPE_ID ,
1381: REPORTING_CODE_NUM_VALUE,
1382: OBJECT_VERSION_NUMBER
1383: )
1384: SELECT
1385: ZX_REPORT_CODES_ASSOC_S.nextval ,
1386: 'ZX_RATES' ,--ENTITY_CODE
1387: TAX_RATE_ID ,--ENTITY_ID
1388: REPORTING_TYPE_ID ,
1389: REPORTING_CODE_ID ,
1424: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1425: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1426: AND report_codes.record_type_code = 'MIGRATED'
1427:
1428: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1429: where entity_code = 'ZX_RATES'
1430: and entity_id = rates.tax_rate_id
1431: and reporting_type_id =
1432: report_codes.reporting_type_id)
1456: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1457: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1458: AND report_codes.record_type_code = 'MIGRATED'
1459:
1460: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1461: where entity_code = 'ZX_RATES'
1462: and entity_id = rates.tax_rate_id
1463: and reporting_type_id =
1464: report_codes.reporting_type_id)
1487: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1488: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1489: AND report_codes.record_type_code = 'MIGRATED'
1490:
1491: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1492: where entity_code = 'ZX_RATES'
1493: and entity_id = rates.tax_rate_id
1494: and reporting_type_id =
1495: report_codes.reporting_type_id)
1518: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1519: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1520: AND report_codes.record_type_code = 'MIGRATED'
1521:
1522: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1523: where entity_code = 'ZX_RATES'
1524: and entity_id = rates.tax_rate_id
1525: and reporting_type_id =
1526: report_codes.reporting_type_id)
1549: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1550: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1551: AND report_codes.record_type_code = 'MIGRATED'
1552:
1553: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1554: where entity_code = 'ZX_RATES'
1555: and entity_id = rates.tax_rate_id
1556: and reporting_type_id =
1557: report_codes.reporting_type_id)
1580: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1581: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1582: AND report_codes.record_type_code = 'MIGRATED'
1583:
1584: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1585: where entity_code = 'ZX_RATES'
1586: and entity_id = rates.tax_rate_id
1587: and reporting_type_id =
1588: report_codes.reporting_type_id)
1614: AND reporting_types.reporting_type_code = 'PT_PRD_TAXABLE_BOX'
1615: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1616: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1617: -- AND report_codes.record_type_code = 'MIGRATED'
1618: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1619: where entity_code = 'ZX_RATES'
1620: and entity_id = rates.tax_rate_id
1621: and reporting_type_id =
1622: reporting_types.reporting_type_id)
1645: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1646: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1647: -- AND report_codes.record_type_code = 'MIGRATED'
1648:
1649: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1650: where entity_code = 'ZX_RATES'
1651: and entity_id = rates.tax_rate_id
1652: and reporting_type_id =
1653: reporting_types.reporting_type_id)
1676: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1677: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1678: -- AND report_codes.record_type_code = 'MIGRATED'
1679:
1680: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1681: where entity_code = 'ZX_RATES'
1682: and entity_id = rates.tax_rate_id
1683: and reporting_type_id =
1684: reporting_types.reporting_type_id)
1707: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1708: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1709: -- AND report_codes.record_type_code = 'MIGRATED'
1710:
1711: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1712: where entity_code = 'ZX_RATES'
1713: and entity_id = rates.tax_rate_id
1714: and reporting_type_id =
1715: reporting_types.reporting_type_id)
1740: AND rates.record_type_code = 'MIGRATED'
1741:
1742: -- AND report_codes.record_type_code = 'MIGRATED'
1743:
1744: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1745: where entity_code = 'ZX_RATES'
1746: and entity_id = rates.tax_rate_id
1747: and reporting_type_id =
1748: reporting_types.reporting_type_id)
1772: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1773: -- AND reporting_types.reporting_type_id = report_codes.reporting_type_id
1774: -- AND report_codes.record_type_code = 'MIGRATED'
1775:
1776: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1777: where entity_code = 'ZX_RATES'
1778: and entity_id = rates.tax_rate_id
1779: and reporting_type_id =
1780: reporting_types.reporting_type_id));
1781:
1782: -- Bug # 3935161. Association for 'MEMBER STATE'
1783: IF L_MULTI_ORG_FLAG = 'Y'
1784: THEN
1785: INSERT INTO ZX_REPORT_CODES_ASSOC(
1786: REPORTING_CODE_ASSOC_ID,
1787: ENTITY_CODE,
1788: ENTITY_ID,
1789: REPORTING_TYPE_ID,
1797: LAST_UPDATE_DATE,
1798: LAST_UPDATE_LOGIN,
1799: OBJECT_VERSION_NUMBER) -- Bug 5031787
1800: (SELECT
1801: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1802: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1803: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1804: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1805: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1826: AND etb.legal_entity_id = fin_sys_param.org_id -- Bug 5031787
1827: AND ptp.party_id = etb.party_id
1828: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1829:
1830: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1831: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1832: and entity_id = ptp.Party_Tax_Profile_Id
1833: and reporting_type_id = types.reporting_type_id));
1834: ELSE
1831: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1832: and entity_id = ptp.Party_Tax_Profile_Id
1833: and reporting_type_id = types.reporting_type_id));
1834: ELSE
1835: INSERT INTO ZX_REPORT_CODES_ASSOC(
1836: REPORTING_CODE_ASSOC_ID,
1837: ENTITY_CODE,
1838: ENTITY_ID,
1839: REPORTING_TYPE_ID,
1847: LAST_UPDATE_DATE,
1848: LAST_UPDATE_LOGIN,
1849: OBJECT_VERSION_NUMBER) -- Bug 5031787
1850: (SELECT
1851: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1852: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1853: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1854: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1855: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1877: AND etb.legal_entity_id = l_org_id
1878: AND ptp.party_id = etb.party_id
1879: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1880:
1881: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1882: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1883: and entity_id = ptp.Party_Tax_Profile_Id
1884: and reporting_type_id = types.reporting_type_id));
1885: END IF;
1887:
1888:
1889: --Bug 3922583
1890: INSERT
1891: INTO ZX_REPORT_CODES_ASSOC(
1892: REPORTING_CODE_ASSOC_ID,
1893: ENTITY_CODE ,
1894: ENTITY_ID ,
1895: REPORTING_TYPE_ID ,
1907: REPORTING_CODE_NUM_VALUE,
1908: OBJECT_VERSION_NUMBER
1909: )
1910: SELECT
1911: ZX_REPORT_CODES_ASSOC_S.nextval ,
1912: 'ZX_RATES' ,--ENTITY_CODE
1913: rates.TAX_RATE_ID ,--ENTITY_ID
1914: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
1915: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
1942: AND reporting_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
1943: AND report_codes.record_type_code = 'MIGRATED'
1944: AND rates.record_type_code = 'MIGRATED'
1945:
1946: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1947: where entity_code = 'ZX_RATES'
1948: and entity_id = rates.tax_rate_id
1949: and reporting_type_id =
1950: report_codes.reporting_type_id);
1966: /* Create the Reporting Code association*/
1967: --Association for Reporting Type Code PT_ANL_TAX_BOX
1968: arp_util_tax.debug('ZX_REPORTING_ASSOC_AR(+)');
1969: INSERT
1970: INTO ZX_REPORT_CODES_ASSOC(
1971: REPORTING_CODE_ASSOC_ID,
1972: ENTITY_CODE ,
1973: ENTITY_ID ,
1974: REPORTING_TYPE_ID ,
1986: REPORTING_CODE_NUM_VALUE,
1987: OBJECT_VERSION_NUMBER
1988: )
1989: SELECT
1990: ZX_REPORT_CODES_ASSOC_S.nextval ,
1991: 'ZX_RATES' ,--ENTITY_CODE
1992: TAX_RATE_ID ,--ENTITY_ID
1993: REPORTING_TYPE_ID ,
1994: REPORTING_CODE_ID ,
2033: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2034: AND report_codes.record_type_code = 'MIGRATED'
2035:
2036:
2037: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2038: where entity_code = 'ZX_RATES'
2039: and entity_id = rates.tax_rate_id
2040: and reporting_type_id =
2041: report_codes.reporting_type_id)
2070: AND report_types.REPORTING_TYPE_CODE= 'CZ_TAX_ORIGIN'
2071: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2072: AND report_codes.record_type_code = 'MIGRATED'
2073:
2074: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2075: where entity_code = 'ZX_RATES'
2076: and entity_id = rates.tax_rate_id
2077: and reporting_type_id =
2078: report_codes.reporting_type_id)
2105: AND report_types.REPORTING_TYPE_CODE= 'HU_TAX_ORIGIN'
2106: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2107: AND report_codes.record_type_code = 'MIGRATED'
2108:
2109: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2110: where entity_code = 'ZX_RATES'
2111: and entity_id = rates.tax_rate_id
2112: and reporting_type_id =
2113: report_codes.reporting_type_id)
2140: AND report_types.REPORTING_TYPE_CODE= 'PL_TAX_ORIGIN'
2141: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2142: AND report_codes.record_type_code = 'MIGRATED'
2143:
2144: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2145: where entity_code = 'ZX_RATES'
2146: and entity_id = rates.tax_rate_id
2147: and reporting_type_id =
2148: report_codes.reporting_type_id)
2175: AND report_types.REPORTING_TYPE_CODE= 'TW_GOVERNMENT_TAX_TYPE'
2176: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2177: AND report_codes.record_type_code = 'MIGRATED'
2178:
2179: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2180: where entity_code = 'ZX_RATES'
2181: and entity_id = rates.tax_rate_id
2182: and reporting_type_id =
2183: report_codes.reporting_type_id)
2205: AND report_types.REPORTING_TYPE_CODE= 'CL_DEBIT_ACCOUNT'
2206: AND report_types.tax_regime_code = rates.tax_regime_code
2207: AND codes.global_attribute5 IS NOT NULL
2208:
2209: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2210: where entity_code = 'ZX_RATES'
2211: and entity_id = rates.tax_rate_id
2212: and reporting_type_id =
2213: report_types.reporting_type_id)
2246: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2247: -- AND report_codes.record_type_code = 'MIGRATED'
2248:
2249:
2250: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2251: where entity_code = 'ZX_RATES'
2252: and entity_id = rates.tax_rate_id
2253: and reporting_type_id =
2254: report_types.reporting_type_id)
2281: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2282: -- AND report_codes.record_type_code = 'MIGRATED'
2283:
2284:
2285: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2286: where entity_code = 'ZX_RATES'
2287: and entity_id = rates.tax_rate_id
2288: and reporting_type_id =
2289: report_types.reporting_type_id)
2316: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2317: -- AND report_codes.record_type_code = 'MIGRATED'
2318:
2319:
2320: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2321: where entity_code = 'ZX_RATES'
2322: and entity_id = rates.tax_rate_id
2323: and reporting_type_id =
2324: report_types.reporting_type_id)
2353: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2354: -- AND report_codes.record_type_code = 'MIGRATED'
2355:
2356:
2357: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2358: where entity_code = 'ZX_RATES'
2359: and entity_id = rates.tax_rate_id
2360: and reporting_type_id =
2361: report_types.reporting_type_id)
2388: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2389: -- AND report_codes.record_type_code = 'MIGRATED'
2390:
2391:
2392: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2393: where entity_code = 'ZX_RATES'
2394: and entity_id = rates.tax_rate_id
2395: and reporting_type_id =
2396: report_types.reporting_type_id)
2423: AND report_types.REPORTING_TYPE_CODE= 'PT_ANL_REC_TAX_BOX'
2424: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2425: -- AND report_codes.record_type_code = 'MIGRATED'
2426:
2427: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2428: where entity_code = 'ZX_RATES'
2429: and entity_id = rates.tax_rate_id
2430: and reporting_type_id =
2431: report_types.reporting_type_id)
2459: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2460: AND report_codes.record_type_code = 'MIGRATED'
2461:
2462:
2463: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2464: where entity_code = 'ZX_RATES'
2465: and entity_id = rates.tax_rate_id
2466: and reporting_type_id =
2467: report_codes.reporting_type_id)
2496: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2497: AND report_codes.record_type_code = 'MIGRATED'
2498:
2499:
2500: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2501: where entity_code = 'ZX_RATES'
2502: and entity_id = rates.tax_rate_id
2503: and reporting_type_id =
2504: report_codes.reporting_type_id)
2533: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2534: AND report_codes.record_type_code = 'MIGRATED'
2535:
2536:
2537: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2538: where entity_code = 'ZX_RATES'
2539: and entity_id = rates.tax_rate_id
2540: and reporting_type_id =
2541: report_codes.reporting_type_id)
2570: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2571: AND report_codes.record_type_code = 'MIGRATED'
2572:
2573:
2574: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2575: where entity_code = 'ZX_RATES'
2576: and entity_id = rates.tax_rate_id
2577: and reporting_type_id =
2578: report_codes.reporting_type_id)
2607: AND report_types.tax_regime_code = rates.tax_regime_code --Bug 4928369
2608: AND report_codes.record_type_code = 'MIGRATED'
2609:
2610:
2611: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2612: where entity_code = 'ZX_RATES'
2613: and entity_id = rates.tax_rate_id
2614: and reporting_type_id =
2615: report_codes.reporting_type_id)
2643: AND report_types.REPORTING_TYPE_CODE= 'PRINTED_TAX_RATE_NAME'
2644: AND report_codes.record_type_code = 'MIGRATED'
2645:
2646:
2647: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2648: where entity_code = 'ZX_RATES'
2649: and entity_id = rates.tax_rate_id
2650: and reporting_type_id =
2651: report_codes.reporting_type_id)
2653:
2654: -- To handle 'YES_NO' DataType - Reporting Type Codes
2655:
2656: INSERT
2657: INTO ZX_REPORT_CODES_ASSOC(
2658: REPORTING_CODE_ASSOC_ID,
2659: ENTITY_CODE ,
2660: ENTITY_ID ,
2661: REPORTING_TYPE_ID ,
2673: REPORTING_CODE_NUM_VALUE,
2674: OBJECT_VERSION_NUMBER
2675: )
2676: SELECT
2677: ZX_REPORT_CODES_ASSOC_S.nextval ,
2678: 'ZX_RATES' ,--ENTITY_CODE
2679: TAX_RATE_ID ,--ENTITY_ID
2680: REPORTING_TYPE_ID ,
2681: NULL ,--REPORTING_CODE_ID
2712: AND codes.global_attribute_category = 'JL.CL.ARXSUVAT.VAT_TAX'
2713: AND rates.record_type_code = 'MIGRATED'
2714: AND codes.global_attribute6 IS NOT NULL
2715:
2716: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2717: where entity_code = 'ZX_RATES'
2718: and entity_id = rates.tax_rate_id
2719: and reporting_type_id =
2720: report_types.reporting_type_id)
2739: AND codes.global_attribute_category = 'JL.AR.ARXSUVAT.AR_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)
2768: AND rates.record_type_code = 'MIGRATED'
2769: AND codes.global_attribute2 IS NOT NULL
2770:
2771:
2772: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2773: where entity_code = 'ZX_RATES'
2774: and entity_id = rates.tax_rate_id
2775: and reporting_type_id =
2776: report_types.reporting_type_id)
2796: AND rates.record_type_code = 'MIGRATED'
2797: AND codes.global_attribute2 IS NOT NULL
2798:
2799:
2800: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2801: where entity_code = 'ZX_RATES'
2802: and entity_id = rates.tax_rate_id
2803: and reporting_type_id =
2804: report_types.reporting_type_id)
2824: AND codes.global_attribute_category = 'JL.CO.ARXSUVAT.AR_VAT_TAX'
2825: AND rates.record_type_code = 'MIGRATED'
2826: AND codes.global_attribute2 IS NOT NULL
2827:
2828: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
2829: where entity_code = 'ZX_RATES'
2830: and entity_id = rates.tax_rate_id
2831: and reporting_type_id =
2832: report_types.reporting_type_id)
2834: );
2835:
2836: -- YK:9/22/2004: Korean GDF
2837: INSERT
2838: INTO ZX_REPORT_CODES_ASSOC(
2839: REPORTING_CODE_ASSOC_ID,
2840: ENTITY_CODE ,
2841: ENTITY_ID ,
2842: REPORTING_TYPE_ID ,
2853: LAST_UPDATE_LOGIN ,
2854: OBJECT_VERSION_NUMBER
2855: )
2856: SELECT
2857: ZX_REPORT_CODES_ASSOC_S.nextval ,
2858: 'ZX_RATES' ,--ENTITY_CODE
2859: TAX_RATE_ID ,--ENTITY_ID
2860: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID
2861: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
2888: AND report_codes.reporting_code_char_value = loc.location_code
2889: AND report_codes.record_type_code = 'MIGRATED'
2890: AND rates.record_type_code = 'MIGRATED'
2891: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
2892: AND not exists( select 1 from ZX_REPORT_CODES_ASSOC
2893: where entity_code = 'ZX_RATES'
2894: and entity_id = rates.tax_rate_id
2895: and reporting_type_id = report_codes.reporting_type_id)
2896: );
3979: -- Creation of reporting codes associations for KR_BUSINESS_LOCATIONS
3980:
3981:
3982: INSERT
3983: INTO ZX_REPORT_CODES_ASSOC(
3984: REPORTING_CODE_ASSOC_ID,
3985: ENTITY_CODE ,
3986: ENTITY_ID ,
3987: REPORTING_TYPE_ID ,
3999: REPORTING_CODE_NUM_VALUE,
4000: OBJECT_VERSION_NUMBER
4001: )
4002: SELECT
4003: ZX_REPORT_CODES_ASSOC_S.nextval ,
4004: 'ZX_RATES' ,--ENTITY_CODE
4005: TAX_RATE_ID ,--ENTITY_ID
4006: REPORTING_TYPE_ID ,
4007: REPORTING_CODE_ID ,
4044: AND reporting_types.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
4045: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
4046: AND report_codes.record_type_code = 'MIGRATED'
4047:
4048: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
4049: where entity_code = 'ZX_RATES'
4050: and entity_id = rates.tax_rate_id
4051: and reporting_type_id =
4052: report_codes.reporting_type_id)
5712: --Bug Fix 4671652
5713: --Creation of Reporting Codes Associations for KR_BUSINESS_LOCATIONS
5714:
5715: INSERT
5716: INTO ZX_REPORT_CODES_ASSOC(
5717: REPORTING_CODE_ASSOC_ID,
5718: ENTITY_CODE ,
5719: ENTITY_ID ,
5720: REPORTING_TYPE_ID ,
5732: REPORTING_CODE_NUM_VALUE,
5733: OBJECT_VERSION_NUMBER
5734: )
5735: SELECT
5736: ZX_REPORT_CODES_ASSOC_S.nextval ,
5737: 'ZX_RATES' ,--ENTITY_CODE
5738: TAX_RATE_ID ,--ENTITY_ID
5739: REPORTING_TYPE_ID ,
5740: REPORTING_CODE_ID ,
5777: AND reporting_types.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
5778: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
5779: AND report_codes.record_type_code = 'MIGRATED'
5780:
5781: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
5782: where entity_code = 'ZX_RATES'
5783: and entity_id = rates.tax_rate_id
5784: and reporting_type_id =
5785: report_codes.reporting_type_id)
5875: BEGIN
5876: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(+)');
5877: arp_util_tax.debug('p_rep_type_info='||p_rep_type_info);
5878:
5879: INSERT INTO ZX_REPORT_CODES_ASSOC(
5880: REPORTING_CODE_ASSOC_ID,
5881: ENTITY_CODE,
5882: ENTITY_ID,
5883: REPORTING_TYPE_ID,
5891: LAST_UPDATE_DATE,
5892: LAST_UPDATE_LOGIN,
5893: OBJECT_VERSION_NUMBER)
5894: SELECT
5895: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
5896: 'ZX_PARTY_TAX_PROFILE' , --ENTITY_CODE
5897: p_ptp_id , --ENTITY_ID
5898: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
5899: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE
5911: WHERE REPORTING_TYPE_CODE=p_reporting_type_code
5912:
5913: AND NOT EXISTS (SELECT 1 FROM
5914: ZX_REPORTING_TYPES_B RTB,
5915: ZX_REPORT_CODES_ASSOC RCA
5916: WHERE
5917:
5918: RTB.REPORTING_TYPE_ID = RCA.REPORTING_TYPE_ID
5919: AND RTB.REPORTING_TYPE_CODE = p_reporting_type_code
7290: BEGIN
7291: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(+)');
7292: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7293:
7294: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7295:
7296: INSERT
7297: INTO ZX_REPORT_CODES_ASSOC(
7298: REPORTING_CODE_ASSOC_ID,
7293:
7294: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7295:
7296: INSERT
7297: INTO ZX_REPORT_CODES_ASSOC(
7298: REPORTING_CODE_ASSOC_ID,
7299: ENTITY_CODE ,
7300: ENTITY_ID ,
7301: REPORTING_TYPE_ID ,
7313: REPORTING_CODE_NUM_VALUE,
7314: OBJECT_VERSION_NUMBER
7315: )
7316: SELECT
7317: ZX_REPORT_CODES_ASSOC_S.nextval ,
7318: 'ZX_RATES' ,--ENTITY_CODE
7319: rates.TAX_RATE_ID ,--ENTITY_ID
7320: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7321: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7356: AND rates.tax_regime_code = reg.tax_regime_code
7357: AND reg.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7358: 'IT','KP','KR','NO','PL','PT','SK')
7359: -- End Bug 7620818
7360: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
7361: where entity_code = 'ZX_RATES'
7362: and entity_id = rates.tax_rate_id
7363: and reporting_type_id =
7364: report_codes.reporting_type_id);
7362: and entity_id = rates.tax_rate_id
7363: and reporting_type_id =
7364: report_codes.reporting_type_id);
7365:
7366: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AR tax codes');
7367:
7368: INSERT
7369: INTO ZX_REPORT_CODES_ASSOC(
7370: REPORTING_CODE_ASSOC_ID,
7365:
7366: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AR tax codes');
7367:
7368: INSERT
7369: INTO ZX_REPORT_CODES_ASSOC(
7370: REPORTING_CODE_ASSOC_ID,
7371: ENTITY_CODE ,
7372: ENTITY_ID ,
7373: REPORTING_TYPE_ID ,
7385: REPORTING_CODE_NUM_VALUE,
7386: OBJECT_VERSION_NUMBER
7387: )
7388: SELECT
7389: ZX_REPORT_CODES_ASSOC_S.nextval ,
7390: 'ZX_RATES' ,--ENTITY_CODE
7391: rates.TAX_RATE_ID ,--ENTITY_ID
7392: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7393: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7425: AND rates.tax_regime_code = reg.tax_regime_code
7426: AND reg.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7427: 'IT','KP','KR','NO','PL','PT','SK')
7428: -- End Bug 7620818
7429: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
7430: where entity_code = 'ZX_RATES'
7431: and entity_id = rates.tax_rate_id
7432: and reporting_type_id = report_codes.reporting_type_id);
7433:
7715: from ZX_REPORTING_CODES_TL T
7716: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7717: and T.LANGUAGE = L.LANGUAGE_CODE);
7718:
7719: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');
7720:
7721: INSERT
7722: INTO ZX_REPORT_CODES_ASSOC(
7723: REPORTING_CODE_ASSOC_ID,
7718:
7719: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');
7720:
7721: INSERT
7722: INTO ZX_REPORT_CODES_ASSOC(
7723: REPORTING_CODE_ASSOC_ID,
7724: ENTITY_CODE ,
7725: ENTITY_ID ,
7726: REPORTING_TYPE_ID ,
7738: REPORTING_CODE_NUM_VALUE,
7739: OBJECT_VERSION_NUMBER
7740: )
7741: SELECT
7742: ZX_REPORT_CODES_ASSOC_S.nextval ,
7743: 'ZX_RATES' ,--ENTITY_CODE
7744: rates.TAX_RATE_ID ,--ENTITY_ID
7745: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7746: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7769: AND reporting_types.tax_regime_code = rates.tax_regime_code
7770: AND reporting_types.tax = rates.tax
7771: --AND report_codes.record_type_code = 'MIGRATED'
7772: AND rates.record_type_code = 'MIGRATED'
7773: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
7774: where entity_code = 'ZX_RATES'
7775: and entity_id = rates.tax_rate_id
7776: and reporting_type_id = report_codes.reporting_type_id);
7777: