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_REPORTING_CODES_B

Line 211: | ZX_REPORTING_CODES_B |

207: | This routine inserts data into following zx reporting entities based |
208: | on data in AP_TAX_CODES_ALL GDF attributes. |
209: | ZX_REPORTING_TYPES_B |
210: | ZX_REPORTING_TYPES_TL |
211: | ZX_REPORTING_CODES_B |
212: | ZX_REPORTING_CODES_TL |
213: | ZX_REPORT_TYPES_USAGES |
214: | |
215: | SCOPE - PUBLIC |

Line 227: l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4936036

223: |==========================================================================*/
224:
225:
226: PROCEDURE CREATE_ZX_REP_TYPE_CODES(p_tax_id IN NUMBER ) IS
227: l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4936036
228: BEGIN
229:
230: IF PG_DEBUG = 'Y' THEN
231: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(+)');

Line 258: INTO ZX_REPORTING_CODES_B(

254: ELSE l_lookup_code := 'M';
255: END IF ;
256:
257: INSERT
258: INTO ZX_REPORTING_CODES_B(
259: REPORTING_CODE_ID ,
260: EXCEPTION_CODE ,
261: EFFECTIVE_FROM ,
262: EFFECTIVE_TO ,

Line 280: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

276: REPORTING_TYPE_ID ,
277: OBJECT_VERSION_NUMBER
278: )
279: SELECT
280: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
281: NULL ,--EXCEPTION_CODE
282: report_types.EFFECTIVE_FROM ,
283: NULL ,--EFFECTIVE_TO
284: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 305: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

301: WHERE
302: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
303: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
304: AND NOT EXISTS
305: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
306: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
307: REPORTING_CODE_CHAR_VALUE= l_lookup_code
308: );
309: END LOOP ;

Line 574: INTO ZX_REPORTING_CODES_B(

570: CREATE_REPORTING_CODES('HU_TAX_ORIGIN', 'JGZZ_TAX_ORIGIN');
571: CREATE_REPORTING_CODES('PL_TAX_ORIGIN', 'JGZZ_TAX_ORIGIN');
572:
573: INSERT
574: INTO ZX_REPORTING_CODES_B(
575: REPORTING_CODE_ID ,
576: EXCEPTION_CODE ,
577: EFFECTIVE_FROM ,
578: EFFECTIVE_TO ,

Line 596: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

592: REPORTING_TYPE_ID ,
593: OBJECT_VERSION_NUMBER
594: )
595: SELECT
596: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
597: NULL ,--EXCEPTION_CODE
598: EFFECTIVE_FROM ,
599: NULL ,--EFFECTIVE_TO
600: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 631: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

627: report_types.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'
628: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
629: AND lookups.LOOKUP_TYPE = 'JATW_GOVERNMENT_TAX_TYPE'
630: AND NOT EXISTS
631: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
632: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
633: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
634: )
635: );

Line 666: ZX_REPORTING_CODES_B CODES,

662: sysdate ,
663: fnd_global.conc_login_id
664: FROM
665: ZX_REPORTING_TYPES_B TYPES,
666: ZX_REPORTING_CODES_B CODES,
667: FND_LOOKUP_VALUES lookups,
668: FND_LANGUAGES L
669: WHERE
670:

Line 790: ZX_REPORTING_CODES_B CODES,

786: sysdate ,
787: fnd_global.conc_login_id
788: FROM
789: ZX_REPORTING_TYPES_B TYPES,
790: ZX_REPORTING_CODES_B CODES,
791: FND_LOOKUP_VALUES lookups,
792: FND_LANGUAGES L
793: WHERE
794:

Line 846: ZX_REPORTING_CODES_B CODES,

842: fnd_global.user_id ,
843: SYSDATE ,
844: fnd_global.conc_login_id
845: FROM
846: ZX_REPORTING_CODES_B CODES,
847: FND_LANGUAGES L
848:
849: WHERE
850: CODES.RECORD_TYPE_CODE = 'MIGRATED'

Line 1066: INTO ZX_REPORTING_CODES_B(

1062: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
1063: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
1064: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
1065: INSERT
1066: INTO ZX_REPORTING_CODES_B(
1067: REPORTING_CODE_ID ,
1068: EXCEPTION_CODE ,
1069: EFFECTIVE_FROM ,
1070: EFFECTIVE_TO ,

Line 1088: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

1084: REPORTING_TYPE_ID ,
1085: OBJECT_VERSION_NUMBER
1086: )
1087: SELECT
1088: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
1089: NULL ,--EXCEPTION_CODE
1090: EFFECTIVE_FROM ,
1091: NULL ,--EFFECTIVE_TO
1092: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 1123: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

1119: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
1120: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
1121: AND lookups.LOOKUP_TYPE = p_lookup_type
1122: AND NOT EXISTS
1123: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
1124: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
1125: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
1126: )
1127: );

Line 1158: ZX_REPORTING_CODES_B CODES,

1154: sysdate ,
1155: fnd_global.conc_login_id
1156: FROM
1157: ZX_REPORTING_TYPES_B TYPES,
1158: ZX_REPORTING_CODES_B CODES,
1159: FND_LOOKUP_VALUES lookups,
1160: FND_LANGUAGES L
1161: WHERE
1162:

Line 1357: ZX_REPORTING_CODES_B report_codes

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)
1361: AND codes.global_attribute_category = 'JL.AR.APXTADTC.VAT'

Line 1431: ZX_REPORTING_CODES_B report_codes

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
1434: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1435: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1463: ZX_REPORTING_CODES_B report_codes

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
1466: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1467: AND codes.global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'

Line 1494: ZX_REPORTING_CODES_B report_codes

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
1497: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1498: AND codes.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN'

Line 1525: ZX_REPORTING_CODES_B report_codes

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
1528: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1529: AND codes.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN'

Line 1556: ZX_REPORTING_CODES_B report_codes

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
1559: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1560: AND codes.global_attribute_category = 'JE.CH.APXTADTC.TAX_INFO'

Line 1587: ZX_REPORTING_CODES_B report_codes

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
1590: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1591: AND codes.global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'

Line 1621: -- ZX_REPORTING_CODES_B report_codes

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
1624: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1625: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1651: -- ZX_REPORTING_CODES_B report_codes

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
1654: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1655: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1682: -- ZX_REPORTING_CODES_B report_codes

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
1685: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1686: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1713: -- ZX_REPORTING_CODES_B report_codes

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
1716: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1717: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1744: -- ZX_REPORTING_CODES_B report_codes

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:
1747: codes.tax_id = rates.tax_rate_id
1748: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 1778: -- ZX_REPORTING_CODES_B report_codes

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
1781: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1782: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1839: zx_reporting_codes_b codes,

1835: 1 -- Bug 5031787
1836: FROM
1837: financials_system_params_all fin_sys_param,
1838: zx_reporting_types_b types,
1839: zx_reporting_codes_b codes,
1840: xle_etb_profiles etb,
1841: zx_party_tax_profile ptp
1842:
1843: WHERE

Line 1895: zx_reporting_codes_b codes,

1891: 1 -- Bug 5031787
1892: FROM
1893: financials_system_params_all fin_sys_param,
1894: zx_reporting_types_b types,
1895: zx_reporting_codes_b codes,
1896: xle_etb_profiles etb,
1897: zx_party_tax_profile ptp
1898:
1899: WHERE

Line 1958: ZX_REPORTING_CODES_B report_codes,

1954: 1
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

Line 2049: ZX_REPORTING_CODES_B report_codes

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
2052:
2053: codes.vat_tax_id = rates.tax_rate_id

Line 2087: ZX_REPORTING_CODES_B report_codes

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
2090:
2091: codes.vat_tax_id = rates.tax_rate_id

Line 2122: ZX_REPORTING_CODES_B report_codes

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
2125:
2126: codes.vat_tax_id = rates.tax_rate_id

Line 2157: ZX_REPORTING_CODES_B report_codes

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
2160:
2161: codes.vat_tax_id = rates.tax_rate_id

Line 2192: ZX_REPORTING_CODES_B report_codes

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
2195:
2196: codes.vat_tax_id = rates.tax_rate_id

Line 2261: -- ZX_REPORTING_CODES_B report_codes

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
2264:
2265: codes.vat_tax_id = rates.tax_rate_id

Line 2296: -- ZX_REPORTING_CODES_B report_codes

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
2299:
2300: codes.vat_tax_id = rates.tax_rate_id

Line 2331: -- ZX_REPORTING_CODES_B report_codes

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
2334:
2335: codes.vat_tax_id = rates.tax_rate_id

Line 2368: -- ZX_REPORTING_CODES_B report_codes

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
2371:
2372: codes.vat_tax_id = rates.tax_rate_id

Line 2403: -- ZX_REPORTING_CODES_B report_codes

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
2406:
2407: codes.vat_tax_id = rates.tax_rate_id

Line 2439: -- ZX_REPORTING_CODES_B report_codes

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
2442:
2443: codes.vat_tax_id = rates.tax_rate_id

Line 2475: ZX_REPORTING_CODES_B report_codes

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
2478:
2479: codes.vat_tax_id = rates.tax_rate_id

Line 2512: ZX_REPORTING_CODES_B report_codes

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
2515:
2516: codes.vat_tax_id = rates.tax_rate_id

Line 2549: ZX_REPORTING_CODES_B report_codes

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
2552:
2553: codes.vat_tax_id = rates.tax_rate_id

Line 2586: ZX_REPORTING_CODES_B report_codes

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
2589:
2590: codes.vat_tax_id = rates.tax_rate_id

Line 2623: ZX_REPORTING_CODES_B report_codes

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
2626:
2627: codes.vat_tax_id = rates.tax_rate_id

Line 2660: ZX_REPORTING_CODES_B report_codes

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
2663:
2664: codes.vat_tax_id = Nvl(rates.source_id,rates.tax_rate_id)

Line 2909: ZX_REPORTING_CODES_B report_codes,

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'
2913: AND codes.vat_tax_id = rates.tax_rate_id

Line 3514: INTO ZX_REPORTING_CODES_B(

3510: CREATE_REPORT_TYPE_PTP('MEMBER STATE', 'TEXT', 'Y');
3511:
3512: -- Create Reporting Codes for 'MEMBER STATE'
3513: INSERT
3514: INTO ZX_REPORTING_CODES_B(
3515: REPORTING_CODE_ID ,
3516: EXCEPTION_CODE ,
3517: EFFECTIVE_FROM ,
3518: EFFECTIVE_TO ,

Line 3534: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3530: REPORTING_TYPE_ID ,
3531: OBJECT_VERSION_NUMBER
3532: )
3533: SELECT
3534: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3535: NULL ,--EXCEPTION_CODE
3536: EFFECTIVE_FROM ,
3537: NULL ,--EFFECTIVE_TO
3538: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3569: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

3565: report_types.REPORTING_TYPE_CODE = 'MEMBER STATE'
3566: AND fin_sys_param.VAT_COUNTRY_CODE is NOT NULL
3567: -- AND report_types.RECORD_TYPE_CODE = 'MIGRATED' -- Bug 5344337
3568: AND NOT EXISTS
3569: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
3570: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
3571: fin_sys_param.VAT_COUNTRY_CODE = REPORTING_CODE_CHAR_VALUE
3572: )
3573: );

Line 3576: /*Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 1.

3572: )
3573: );
3574:
3575:
3576: /*Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 1.
3577: BugFix 3557652 REPORTING CODE IMPL FOR ARGENTINE DGI TRANSACTION CODE.
3578: Following Insert will take care of both of ABOVE since for both these
3579: the REPORTING CODES needs to pick up from FND_LOOKUPS */
3580:

Line 3584: INTO ZX_REPORTING_CODES_B(

3580:
3581: /* Commented for the Bug 4936036 : as the below logic is wrong and is based on the lookup_type = 'PT_LOCATION'
3582: which doesn't exist
3583: INSERT
3584: INTO ZX_REPORTING_CODES_B(
3585: REPORTING_CODE_ID ,
3586: EXCEPTION_CODE ,
3587: EFFECTIVE_FROM ,
3588: EFFECTIVE_TO ,

Line 3606: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3602: REPORTING_TYPE_ID,
3603: OBJECT_VERSION_NUMBER
3604: )
3605: SELECT
3606: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3607: NULL ,--EXCEPTION_CODE
3608: EFFECTIVE_FROM ,
3609: NULL ,--EFFECTIVE_TO
3610: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3645: AND NOT EXISTS(SELECT 1 FROM ZX_REPORTING_CODES_B

3641: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
3642: AND report_types.REPORTING_TYPE_CODE = lookups.LOOKUP_TYPE
3643: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
3644:
3645: AND NOT EXISTS(SELECT 1 FROM ZX_REPORTING_CODES_B
3646: WHERE REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID
3647: AND REPORTING_CODE_CHAR_VALUE = lookups.LOOKUP_CODE
3648: )
3649:

Line 3653: --Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 2..7

3649:
3650: );
3651: */
3652:
3653: --Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 2..7
3654: /* Commented : Bug 4936036 : Reporting Codes should not be created for the below reporting types
3655: as has_reporting_codes_flag = 'N'
3656: INSERT
3657: INTO ZX_REPORTING_CODES_B(

Line 3657: INTO ZX_REPORTING_CODES_B(

3653: --Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 2..7
3654: /* Commented : Bug 4936036 : Reporting Codes should not be created for the below reporting types
3655: as has_reporting_codes_flag = 'N'
3656: INSERT
3657: INTO ZX_REPORTING_CODES_B(
3658: REPORTING_CODE_ID ,
3659: EXCEPTION_CODE ,
3660: EFFECTIVE_FROM ,
3661: EFFECTIVE_TO ,

Line 3679: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3675: REPORTING_TYPE_ID ,
3676: OBJECT_VERSION_NUMBER
3677: )
3678: SELECT
3679: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3680: NULL ,--EXCEPTION_CODE
3681: effective_from ,
3682: NULL ,--EFFECTIVE_TO
3683: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3720: (select 1 from zx_reporting_codes_b where

3716: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'
3717: AND codes.global_attribute2 IS NOT NULL
3718:
3719: AND (NOT EXISTS
3720: (select 1 from zx_reporting_codes_b where
3721: reporting_type_code = types.reporting_type_code and
3722: REPORTING_CODE_CHAR_VALUE=codes.global_attribute2 )
3723: )
3724:

Line 3747: (select 1 from zx_reporting_codes_b where

3743: AND codes.global_attribute3 IS NOT NULL
3744:
3745:
3746: AND (NOT EXISTS
3747: (select 1 from zx_reporting_codes_b where
3748: reporting_type_code = types.reporting_type_code and
3749: REPORTING_CODE_CHAR_VALUE=codes.global_attribute3 )
3750: )
3751:

Line 3772: (select 1 from zx_reporting_codes_b where

3768: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'
3769: AND codes.global_attribute4 IS NOT NULL
3770:
3771: AND (NOT EXISTS
3772: (select 1 from zx_reporting_codes_b where
3773: reporting_type_code = types.reporting_type_code and
3774: REPORTING_CODE_CHAR_VALUE=codes.global_attribute4 )
3775: )
3776:

Line 3797: (select 1 from zx_reporting_codes_b where

3793: AND codes.global_attribute5 IS NOT NULL
3794:
3795:
3796: AND (NOT EXISTS
3797: (select 1 from zx_reporting_codes_b where
3798: reporting_type_code = types.reporting_type_code and
3799: REPORTING_CODE_CHAR_VALUE=codes.global_attribute5 )
3800: )
3801:

Line 3823: (select 1 from zx_reporting_codes_b where

3819: AND codes.global_attribute6 IS NOT NULL
3820:
3821:
3822: AND (NOT EXISTS
3823: (select 1 from zx_reporting_codes_b where
3824: reporting_type_code = types.reporting_type_code and
3825: codes.global_attribute6 = REPORTING_CODE_CHAR_VALUE)
3826: )
3827:

Line 3849: (select 1 from zx_reporting_codes_b where

3845: AND codes.global_attribute7 IS NOT NULL
3846:
3847:
3848: AND (NOT EXISTS
3849: (select 1 from zx_reporting_codes_b where
3850: reporting_type_code = types.reporting_type_code and
3851: codes.global_attribute7 = REPORTING_CODE_CHAR_VALUE)
3852: )
3853:

Line 3936: ZX_REPORTING_CODES_B

3932: -- Bug Fix 4671652
3933: -- Creation of reporting codes for KR_BUSINESS_LOCATIONS
3934: INSERT ALL
3935: INTO
3936: ZX_REPORTING_CODES_B
3937: (
3938: REPORTING_CODE_ID ,
3939: EXCEPTION_CODE ,
3940: EFFECTIVE_FROM ,

Line 3960: ZX_REPORTING_CODES_B_S.NEXTVAL,

3956: OBJECT_VERSION_NUMBER
3957: )
3958: VALUES
3959: (
3960: ZX_REPORTING_CODES_B_S.NEXTVAL,
3961: NULL,
3962: l_start_date,
3963: NULL,
3964: 'MIGRATED',

Line 3998: ( select 1 from zx_reporting_codes_b where reporting_type_id =

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
3998: ( select 1 from zx_reporting_codes_b where reporting_type_id =
3999: (select reporting_type_id FROM zx_reporting_types_b
4000: WHERE tax_regime_code = zxrb.tax_regime_code
4001: AND reporting_type_code = 'KR_BUSINESS_LOCATIONS')
4002: AND reporting_code_char_value = tax_id_values_and_codes.location_code);

Line 4062: ZX_REPORTING_CODES_B report_codes

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
4065: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
4066: AND codes.global_attribute1 = TO_CHAR(hrloc.location_id)

Line 4093: --l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4874049

4089:
4090: /* Used to create the reporting type and code for AR */
4091:
4092: PROCEDURE CREATE_ZX_REP_TYPE_CODES_AR(p_tax_id IN NUMBER ) IS
4093: --l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4874049
4094: l_exists_cnt NUMBER ; --Bug 5344337
4095: BEGIN
4096:
4097: IF PG_DEBUG = 'Y' THEN

Line 4715: --The creation of zx_reporting_types_b , zx_reporting_codes_b and zx_reporting_codes_tl has been put together for

4711: zx_rates.tax_regime_code;
4712: --Bug 4705196
4713: /*
4714: --Bug 4422813
4715: --The creation of zx_reporting_types_b , zx_reporting_codes_b and zx_reporting_codes_tl has been put together for
4716: --easy understanding
4717:
4718: INSERT ALL
4719: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4801: select zx_reporting_codes_b_s.nextval into l_seqid from dual;

4797: (select vat_tax_id from ar_vat_tax_all_b )
4798:
4799:
4800: LOOP
4801: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4802:
4803: INSERT ALL
4804: INTO
4805: ZX_REPORTING_CODES_B

Line 4805: ZX_REPORTING_CODES_B

4801: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4802:
4803: INSERT ALL
4804: INTO
4805: ZX_REPORTING_CODES_B
4806: (
4807: REPORTING_CODE_ID ,
4808: EXCEPTION_CODE ,
4809: EFFECTIVE_FROM ,

Line 4861: ( select 1 from zx_reporting_codes_b where reporting_type_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
4860: and not exists
4861: ( select 1 from zx_reporting_codes_b where reporting_type_id =
4862: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = zxrb.tax_regime_code
4863: and reporting_type_code = 'PRINTED_TAX_RATE_NAME')
4864: and reporting_code_char_value = printed_tax_name)
4865: );

Line 5021: ZX_REPORTING_CODES_B

5017: --Creation of Reporting Codes for Reporting Type ZX_ADJ_TAX_CLASSIF_CODE
5018:
5019: INSERT ALL
5020: INTO
5021: ZX_REPORTING_CODES_B
5022: (
5023: REPORTING_CODE_ID ,
5024: EXCEPTION_CODE ,
5025: EFFECTIVE_FROM ,

Line 5045: ZX_REPORTING_CODES_B_S.NEXTVAL,

5041: OBJECT_VERSION_NUMBER
5042: )
5043: VALUES
5044: (
5045: ZX_REPORTING_CODES_B_S.NEXTVAL,
5046: NULL,
5047: l_start_date,
5048: NULL,
5049: 'MIGRATED',

Line 5075: ( select 1 from zx_reporting_codes_b where reporting_type_id =

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 =
5076: (select reporting_type_id FROM zx_reporting_types_b
5077: WHERE tax_regime_code = zxrb.tax_regime_code
5078: AND reporting_type_code = 'ZX_ADJ_TAX_CLASSIF_CODE')
5079: AND reporting_code_char_value = adjustment_tax_code)

Line 5087: ZX_REPORTING_CODES_B

5083: --Bug# 4952838
5084: /* Bug 5031787 : Commented for the Bug as has_reporting_code_flag is 'N' and no codes creation is redundant
5085: INSERT ALL
5086: INTO
5087: ZX_REPORTING_CODES_B
5088: (
5089: REPORTING_CODE_ID ,
5090: EXCEPTION_CODE ,
5091: EFFECTIVE_FROM ,

Line 5111: ZX_REPORTING_CODES_B_S.NEXTVAL,

5107: OBJECT_VERSION_NUMBER
5108: )
5109: VALUES
5110: (
5111: ZX_REPORTING_CODES_B_S.NEXTVAL,
5112: NULL,
5113: l_start_date,
5114: NULL,
5115: 'MIGRATED',

Line 5142: ( select 1 from zx_reporting_codes_b where reporting_type_id =

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
5142: ( select 1 from zx_reporting_codes_b where reporting_type_id =
5143: (select reporting_type_id FROM zx_reporting_types_b
5144: WHERE tax_regime_code = zxrb.tax_regime_code
5145: AND reporting_type_code = 'CL_DEBIT_ACCOUNT')
5146: AND reporting_code_char_value = avtb.global_attribute5);*/

Line 5325: INTO ZX_REPORTING_CODES_B(

5321: ELSE l_lookup_code := 'M';
5322: END IF ;
5323:
5324: INSERT
5325: INTO ZX_REPORTING_CODES_B(
5326: REPORTING_CODE_ID ,
5327: EXCEPTION_CODE ,
5328: EFFECTIVE_FROM ,
5329: EFFECTIVE_TO ,

Line 5347: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5343: REPORTING_TYPE_ID ,
5344: OBJECT_VERSION_NUMBER
5345: )
5346: SELECT
5347: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5348: NULL ,--EXCEPTION_CODE
5349: report_types.EFFECTIVE_FROM ,
5350: NULL ,--EFFECTIVE_TO
5351: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 5372: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

5368: WHERE
5369: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
5370: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
5371: AND NOT EXISTS
5372: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
5373: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
5374: REPORTING_CODE_CHAR_VALUE= l_lookup_code
5375: );
5376: END LOOP ; */

Line 5408: ZX_REPORTING_CODES_B CODES,

5404: sysdate ,
5405: fnd_global.conc_login_id
5406: FROM
5407: ZX_REPORTING_TYPES_B TYPES,
5408: ZX_REPORTING_CODES_B CODES,
5409: FND_LOOKUP_VALUES lookups,
5410: FND_LANGUAGES L
5411: WHERE
5412: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID

Line 5456: ZX_REPORTING_CODES_B CODES,

5452: sysdate ,
5453: fnd_global.conc_login_id
5454: FROM
5455: ZX_REPORTING_TYPES_B TYPES,
5456: ZX_REPORTING_CODES_B CODES,
5457: FND_LOOKUP_VALUES lookups,
5458: FND_LANGUAGES L
5459: WHERE
5460: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID

Line 5478: INTO ZX_REPORTING_CODES_B(

5474: */
5475:
5476: -- YK:9/22/2004: Korean GDF: Reporting Code creation
5477: INSERT
5478: INTO ZX_REPORTING_CODES_B(
5479: REPORTING_CODE_ID ,
5480: REPORTING_CODE_CHAR_VALUE,
5481: REPORTING_CODE_NUM_VALUE,
5482: REPORTING_CODE_DATE_VALUE,

Line 5500: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5496: PROGRAM_LOGIN_ID ,
5497: OBJECT_VERSION_NUMBER
5498: )
5499: SELECT
5500: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5501: global_attribute ,--REPORTING_CODE_CHAR_VALUE
5502: NULL ,--REPORTING_CODE_NUM_VALUE
5503: NULL ,--REPORTING_CODE_DATE_VALUE
5504: reporting_type_id ,--REPORTING_TYPE_ID

Line 5535: AND (NOT EXISTS (select 1 from zx_reporting_codes_b

5531: AND types.record_type_code = 'MIGRATED'
5532: AND locations.global_attribute_category = 'JA.KR.PERWSLOC.WITHHOLDING'
5533: AND locations.global_attribute1 IS NOT NULL
5534:
5535: AND (NOT EXISTS (select 1 from zx_reporting_codes_b
5536: where reporting_type_id = types.reporting_type_id
5537: and reporting_code_char_value = locations.location_code
5538: /*(select location_code
5539: from hr_locations

Line 5570: ZX_REPORTING_CODES_B CODES,

5566: sysdate ,
5567: fnd_global.conc_login_id
5568: FROM
5569: ZX_REPORTING_TYPES_B TYPES,
5570: ZX_REPORTING_CODES_B CODES,
5571: FND_LOOKUP_VALUES lookups,
5572: FND_LANGUAGES L
5573: WHERE
5574:

Line 5672: ZX_REPORTING_CODES_B

5668: --Creation of Reporting Codes for KR_BUSINESS_LOCATIONS
5669:
5670: INSERT ALL
5671: INTO
5672: ZX_REPORTING_CODES_B
5673: (
5674: REPORTING_CODE_ID ,
5675: EXCEPTION_CODE ,
5676: EFFECTIVE_FROM ,

Line 5696: ZX_REPORTING_CODES_B_S.NEXTVAL,

5692: OBJECT_VERSION_NUMBER
5693: )
5694: VALUES
5695: (
5696: ZX_REPORTING_CODES_B_S.NEXTVAL,
5697: NULL,
5698: l_start_date,
5699: NULL,
5700: 'MIGRATED',

Line 5734: ( select 1 from zx_reporting_codes_b where reporting_type_id =

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
5734: ( select 1 from zx_reporting_codes_b where reporting_type_id =
5735: (select reporting_type_id FROM zx_reporting_types_b
5736: WHERE tax_regime_code = zxrb.tax_regime_code
5737: AND reporting_type_code = 'KR_BUSINESS_LOCATIONS')
5738: AND reporting_code_char_value = tax_id_values_and_codes.location_code);

Line 5797: ZX_REPORTING_CODES_B report_codes

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
5800: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
5801: AND codes.global_attribute1 = TO_CHAR(hrloc.location_id)

Line 6278: INTO ZX_REPORTING_CODES_B(

6274: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
6275: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
6276: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
6277: INSERT
6278: INTO ZX_REPORTING_CODES_B(
6279: REPORTING_CODE_ID ,
6280: EXCEPTION_CODE ,
6281: EFFECTIVE_FROM ,
6282: EFFECTIVE_TO ,

Line 6300: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6296: REPORTING_TYPE_ID ,
6297: OBJECT_VERSION_NUMBER
6298: )
6299: SELECT
6300: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6301: NULL ,--EXCEPTION_CODE
6302: EFFECTIVE_FROM ,
6303: NULL ,--EFFECTIVE_TO
6304: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6335: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

6331: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
6332: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6333: AND lookups.LOOKUP_TYPE = p_lookup_type
6334: AND NOT EXISTS
6335: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
6336: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
6337: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6338: )
6339: );

Line 6370: ZX_REPORTING_CODES_B CODES,

6366: sysdate ,
6367: 0
6368: FROM
6369: ZX_REPORTING_TYPES_B TYPES,
6370: ZX_REPORTING_CODES_B CODES,
6371: FND_LOOKUP_VALUES lookups,
6372: FND_LANGUAGES L
6373: WHERE
6374:

Line 6545: INTO ZX_REPORTING_CODES_B(

6541: ELSE l_lookup_code := 'M';
6542: END IF ;
6543:
6544: INSERT
6545: INTO ZX_REPORTING_CODES_B(
6546: REPORTING_CODE_ID ,
6547: EXCEPTION_CODE ,
6548: EFFECTIVE_FROM ,
6549: EFFECTIVE_TO ,

Line 6567: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6563: REPORTING_TYPE_ID ,
6564: OBJECT_VERSION_NUMBER
6565: )
6566: SELECT
6567: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6568: NULL ,--EXCEPTION_CODE
6569: report_types.EFFECTIVE_FROM ,
6570: NULL ,--EFFECTIVE_TO
6571: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6592: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

6588: WHERE
6589: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
6590: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6591: AND NOT EXISTS
6592: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
6593: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
6594: REPORTING_CODE_CHAR_VALUE= l_lookup_code
6595: );
6596: END LOOP ;

Line 6634: ZX_REPORTING_CODES_B CODES,

6630: 120 ,
6631: SYSDATE ,
6632: 0
6633: FROM
6634: ZX_REPORTING_CODES_B CODES,
6635: FND_LANGUAGES L
6636: WHERE
6637: CODES.RECORD_TYPE_CODE = 'SEEDED'
6638: AND codes.reporting_type_id = ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B

Line 6698: INTO ZX_REPORTING_CODES_B(

6694: CREATE_REPORT_TYPE_SEED('TW_GOVERNMENT_TAX_TYPE','TEXT','Y');
6695:
6696: --Create Reporting Codes
6697: INSERT
6698: INTO ZX_REPORTING_CODES_B(
6699: REPORTING_CODE_ID ,
6700: EXCEPTION_CODE ,
6701: EFFECTIVE_FROM ,
6702: EFFECTIVE_TO ,

Line 6720: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6716: REPORTING_TYPE_ID ,
6717: OBJECT_VERSION_NUMBER
6718: )
6719: SELECT
6720: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6721: NULL ,--EXCEPTION_CODE
6722: EFFECTIVE_FROM ,
6723: NULL ,--EFFECTIVE_TO
6724: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6755: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

6751: report_types.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'
6752: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6753: AND lookups.LOOKUP_TYPE = 'JATW_GOVERNMENT_TAX_TYPE'
6754: AND NOT EXISTS
6755: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
6756: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
6757: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6758: )
6759: );

Line 6790: ZX_REPORTING_CODES_B CODES,

6786: sysdate ,
6787: 0
6788: FROM
6789: ZX_REPORTING_TYPES_B TYPES,
6790: ZX_REPORTING_CODES_B CODES,
6791: FND_LOOKUP_VALUES lookups,
6792: FND_LANGUAGES L
6793: WHERE
6794:

Line 7165: INTO ZX_REPORTING_CODES_B(

7161: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(+)');
7162: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7163: arp_util_tax.debug('p_lookup_type = '||'ZX_TAX_TYPE_CATEGORY');
7164: INSERT
7165: INTO ZX_REPORTING_CODES_B(
7166: REPORTING_CODE_ID ,
7167: EXCEPTION_CODE ,
7168: EFFECTIVE_FROM ,
7169: EFFECTIVE_TO ,

Line 7187: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7183: REPORTING_TYPE_ID ,
7184: OBJECT_VERSION_NUMBER
7185: )
7186: SELECT
7187: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7188: NULL ,--EXCEPTION_CODE
7189: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7190: NULL ,--EFFECTIVE_TO
7191: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 7234: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

7230: 'VAT-KA','VAT-KS','VAT-RA','VAT-RS','VAT-NO-REP',
7231: 'IL_VAT_EXEMPT','IL_VAT','VAT-C','VAT-P','VAT-H','VAT-0',
7232: 'VAT-L','VAT-M','VAT-Y','VAT-I','VAT-EXEMPT')
7233: AND NOT EXISTS
7234: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
7235: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
7236: REPORTING_CODE_CHAR_VALUE = DECODE(lookups.LOOKUP_CODE,
7237: 'SALES','SALES_TAX',
7238: 'Exempt Vat','EXEMPT',

Line 7273: ZX_REPORTING_CODES_B CODES,

7269: sysdate ,
7270: fnd_global.conc_login_id
7271: FROM
7272: ZX_REPORTING_TYPES_B TYPES,
7273: ZX_REPORTING_CODES_B CODES,
7274: FND_LOOKUP_VALUES lookups,
7275: FND_LANGUAGES L
7276: WHERE
7277:

Line 7367: ZX_REPORTING_CODES_B report_codes,

7363: 1
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

Line 7439: ZX_REPORTING_CODES_B report_codes,

7435: 1
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

Line 7631: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');

7627: AND NOT EXISTS ( select 1 from zx_report_types_usages
7628: where reporting_type_id = types.reporting_type_id
7629: and entity_code = 'ZX_RATES');
7630:
7631: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');
7632:
7633: INSERT
7634: INTO ZX_REPORTING_CODES_B(
7635: REPORTING_CODE_ID ,

Line 7634: INTO ZX_REPORTING_CODES_B(

7630:
7631: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');
7632:
7633: INSERT
7634: INTO ZX_REPORTING_CODES_B(
7635: REPORTING_CODE_ID ,
7636: EXCEPTION_CODE ,
7637: EFFECTIVE_FROM ,
7638: EFFECTIVE_TO ,

Line 7656: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7652: REPORTING_TYPE_ID ,
7653: OBJECT_VERSION_NUMBER
7654: )
7655: SELECT
7656: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7657: NULL ,--EXCEPTION_CODE
7658: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7659: NULL ,--EFFECTIVE_TO
7660: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 7694: FROM ZX_REPORTING_CODES_B

7690: --Consider only the following lookup_codes
7691: AND lookups.LOOKUP_CODE = 'REVERSE_CHARGE_VAT'
7692: AND NOT EXISTS
7693: (SELECT 1
7694: FROM ZX_REPORTING_CODES_B
7695: WHERE REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID
7696: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
7697: )
7698: );

Line 7729: ZX_REPORTING_CODES_B CODES,

7725: sysdate ,
7726: fnd_global.conc_login_id
7727: FROM
7728: ZX_REPORTING_TYPES_B TYPES,
7729: ZX_REPORTING_CODES_B CODES,
7730: FND_LOOKUP_VALUES lookups,
7731: FND_LANGUAGES L
7732: WHERE
7733:

Line 7792: ZX_REPORTING_CODES_B report_codes,

7788: 1
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

Line 8113: INTO ZX_REPORTING_CODES_B

8109: BEGIN
8110: arp_util_tax.debug('CREATE_REPORTING_CODES_EUVAT(+)');
8111:
8112: INSERT
8113: INTO ZX_REPORTING_CODES_B
8114: (
8115: REPORTING_CODE_ID ,
8116: EXCEPTION_CODE ,
8117: EFFECTIVE_FROM ,

Line 8135: SELECT zx_reporting_codes_b_s.nextval ,--REPORTING_CODE_ID

8131: REPORTING_CODE_NUM_VALUE ,
8132: REPORTING_TYPE_ID ,
8133: OBJECT_VERSION_NUMBER
8134: )
8135: SELECT zx_reporting_codes_b_s.nextval ,--REPORTING_CODE_ID
8136: NULL ,--EXCEPTION_CODE
8137: EFFECTIVE_FROM ,--EFFECTIVE_FROM
8138: NULL ,--EFFECTIVE_TO
8139: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 8168: FROM ZX_REPORTING_CODES_B

8164: 'ZX_INTRA_EU_TRX_TYPE','AR_TX_INTRA_EU_TRX_TYPE',
8165: 'ZX_LGL_JUSTIFICATN_MSG_TYPE','AR_TX_LGL_JUSTIFICATN_MSG')
8166: AND NOT EXISTS
8167: (SELECT 1
8168: FROM ZX_REPORTING_CODES_B
8169: WHERE REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID
8170: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
8171: )
8172: );

Line 8203: ZX_REPORTING_CODES_B CODES,

8199: fnd_global.user_id ,
8200: SYSDATE ,
8201: fnd_global.conc_login_id
8202: FROM ZX_REPORTING_TYPES_B TYPES,
8203: ZX_REPORTING_CODES_B CODES,
8204: FND_LOOKUP_VALUES lookups ,
8205: FND_LANGUAGES L
8206: WHERE TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
8207: AND TYPES.REPORTING_TYPE_CODE in ('ZX_INTRA_EU_TRX_TYPE',

Line 8299: ZX_REPORTING_CODES_B report_codes

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
8302: Upper(codes.LGL_JUSTIFICATION_MSG_CODE) = report_codes.REPORTING_CODE_CHAR_VALUE AND
8303: rates.record_type_code = ''MIGRATED'' AND

Line 8367: ZX_REPORTING_CODES_B report_codes

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
8370: Upper(codes.INTRA_EU_TRX_TYPE_CODE) = report_codes.REPORTING_CODE_CHAR_VALUE AND
8371: rates.record_type_code = ''MIGRATED'' AND