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 196: | ZX_REPORTING_CODES_B |

192: | This routine inserts data into following zx reporting entities based |
193: | on data in AP_TAX_CODES_ALL GDF attributes. |
194: | ZX_REPORTING_TYPES_B |
195: | ZX_REPORTING_TYPES_TL |
196: | ZX_REPORTING_CODES_B |
197: | ZX_REPORTING_CODES_TL |
198: | ZX_REPORT_TYPES_USAGES |
199: | |
200: | SCOPE - PUBLIC |

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

208: |==========================================================================*/
209:
210:
211: PROCEDURE CREATE_ZX_REP_TYPE_CODES(p_tax_id IN NUMBER ) IS
212: l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4936036
213: BEGIN
214:
215: IF PG_DEBUG = 'Y' THEN
216: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(+)');

Line 243: INTO ZX_REPORTING_CODES_B(

239: ELSE l_lookup_code := 'M';
240: END IF ;
241:
242: INSERT
243: INTO ZX_REPORTING_CODES_B(
244: REPORTING_CODE_ID ,
245: EXCEPTION_CODE ,
246: EFFECTIVE_FROM ,
247: EFFECTIVE_TO ,

Line 265: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

261: REPORTING_TYPE_ID ,
262: OBJECT_VERSION_NUMBER
263: )
264: SELECT
265: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
266: NULL ,--EXCEPTION_CODE
267: report_types.EFFECTIVE_FROM ,
268: NULL ,--EFFECTIVE_TO
269: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 290: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

286: WHERE
287: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
288: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
289: AND NOT EXISTS
290: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
291: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
292: REPORTING_CODE_CHAR_VALUE= l_lookup_code
293: );
294: END LOOP ;

Line 559: INTO ZX_REPORTING_CODES_B(

555: CREATE_REPORTING_CODES('HU_TAX_ORIGIN', 'JGZZ_TAX_ORIGIN');
556: CREATE_REPORTING_CODES('PL_TAX_ORIGIN', 'JGZZ_TAX_ORIGIN');
557:
558: INSERT
559: INTO ZX_REPORTING_CODES_B(
560: REPORTING_CODE_ID ,
561: EXCEPTION_CODE ,
562: EFFECTIVE_FROM ,
563: EFFECTIVE_TO ,

Line 581: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

577: REPORTING_TYPE_ID ,
578: OBJECT_VERSION_NUMBER
579: )
580: SELECT
581: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
582: NULL ,--EXCEPTION_CODE
583: EFFECTIVE_FROM ,
584: NULL ,--EFFECTIVE_TO
585: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 616: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

612: report_types.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'
613: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
614: AND lookups.LOOKUP_TYPE = 'JATW_GOVERNMENT_TAX_TYPE'
615: AND NOT EXISTS
616: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
617: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
618: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
619: )
620: );

Line 651: ZX_REPORTING_CODES_B CODES,

647: sysdate ,
648: fnd_global.conc_login_id
649: FROM
650: ZX_REPORTING_TYPES_B TYPES,
651: ZX_REPORTING_CODES_B CODES,
652: FND_LOOKUP_VALUES lookups,
653: FND_LANGUAGES L
654: WHERE
655:

Line 775: ZX_REPORTING_CODES_B CODES,

771: sysdate ,
772: fnd_global.conc_login_id
773: FROM
774: ZX_REPORTING_TYPES_B TYPES,
775: ZX_REPORTING_CODES_B CODES,
776: FND_LOOKUP_VALUES lookups,
777: FND_LANGUAGES L
778: WHERE
779:

Line 831: ZX_REPORTING_CODES_B CODES,

827: fnd_global.user_id ,
828: SYSDATE ,
829: fnd_global.conc_login_id
830: FROM
831: ZX_REPORTING_CODES_B CODES,
832: FND_LANGUAGES L
833:
834: WHERE
835: CODES.RECORD_TYPE_CODE = 'MIGRATED'

Line 1051: INTO ZX_REPORTING_CODES_B(

1047: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
1048: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
1049: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
1050: INSERT
1051: INTO ZX_REPORTING_CODES_B(
1052: REPORTING_CODE_ID ,
1053: EXCEPTION_CODE ,
1054: EFFECTIVE_FROM ,
1055: EFFECTIVE_TO ,

Line 1073: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

1069: REPORTING_TYPE_ID ,
1070: OBJECT_VERSION_NUMBER
1071: )
1072: SELECT
1073: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
1074: NULL ,--EXCEPTION_CODE
1075: EFFECTIVE_FROM ,
1076: NULL ,--EFFECTIVE_TO
1077: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 1108: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

1104: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
1105: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
1106: AND lookups.LOOKUP_TYPE = p_lookup_type
1107: AND NOT EXISTS
1108: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
1109: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
1110: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
1111: )
1112: );

Line 1143: ZX_REPORTING_CODES_B CODES,

1139: sysdate ,
1140: fnd_global.conc_login_id
1141: FROM
1142: ZX_REPORTING_TYPES_B TYPES,
1143: ZX_REPORTING_CODES_B CODES,
1144: FND_LOOKUP_VALUES lookups,
1145: FND_LANGUAGES L
1146: WHERE
1147:

Line 1342: ZX_REPORTING_CODES_B report_codes

1338: FROM
1339:
1340: AP_TAX_CODES_ALL codes,
1341: ZX_RATES_B rates,
1342: ZX_REPORTING_CODES_B report_codes
1343: WHERE
1344: codes.tax_id = rates.tax_rate_id
1345: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1346: AND codes.global_attribute_category = 'JL.AR.APXTADTC.VAT'

Line 1416: ZX_REPORTING_CODES_B report_codes

1412: FROM
1413: AP_TAX_CODES_ALL codes,
1414: ZX_RATES_B rates,
1415: ZX_REPORTING_TYPES_B reporting_types,
1416: ZX_REPORTING_CODES_B report_codes
1417: WHERE
1418: codes.tax_id = rates.tax_rate_id
1419: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1420: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1448: ZX_REPORTING_CODES_B report_codes

1444: FROM
1445: AP_TAX_CODES_ALL codes,
1446: ZX_RATES_B rates,
1447: ZX_REPORTING_TYPES_B reporting_types,
1448: ZX_REPORTING_CODES_B report_codes
1449: WHERE
1450: codes.tax_id = rates.tax_rate_id
1451: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1452: AND codes.global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'

Line 1479: ZX_REPORTING_CODES_B report_codes

1475: FROM
1476: AP_TAX_CODES_ALL codes,
1477: ZX_RATES_B rates,
1478: ZX_REPORTING_TYPES_B reporting_types,
1479: ZX_REPORTING_CODES_B report_codes
1480: WHERE
1481: codes.tax_id = rates.tax_rate_id
1482: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1483: AND codes.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN'

Line 1510: ZX_REPORTING_CODES_B report_codes

1506: FROM
1507: AP_TAX_CODES_ALL codes,
1508: ZX_RATES_B rates,
1509: ZX_REPORTING_TYPES_B reporting_types,
1510: ZX_REPORTING_CODES_B report_codes
1511: WHERE
1512: codes.tax_id = rates.tax_rate_id
1513: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1514: AND codes.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN'

Line 1541: ZX_REPORTING_CODES_B report_codes

1537: FROM
1538: AP_TAX_CODES_ALL codes,
1539: ZX_RATES_B rates,
1540: ZX_REPORTING_TYPES_B reporting_types,
1541: ZX_REPORTING_CODES_B report_codes
1542: WHERE
1543: codes.tax_id = rates.tax_rate_id
1544: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1545: AND codes.global_attribute_category = 'JE.CH.APXTADTC.TAX_INFO'

Line 1572: ZX_REPORTING_CODES_B report_codes

1568: FROM
1569: AP_TAX_CODES_ALL codes,
1570: ZX_RATES_B rates,
1571: ZX_REPORTING_TYPES_B reporting_types,
1572: ZX_REPORTING_CODES_B report_codes
1573: WHERE
1574: codes.tax_id = rates.tax_rate_id
1575: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1576: AND codes.global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'

Line 1606: -- ZX_REPORTING_CODES_B report_codes

1602: FROM
1603: AP_TAX_CODES_ALL codes,
1604: ZX_RATES_B rates,
1605: ZX_REPORTING_TYPES_B reporting_types
1606: -- ZX_REPORTING_CODES_B report_codes
1607: WHERE
1608: codes.tax_id = rates.tax_rate_id
1609: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1610: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1636: -- ZX_REPORTING_CODES_B report_codes

1632: FROM
1633: AP_TAX_CODES_ALL codes,
1634: ZX_RATES_B rates,
1635: ZX_REPORTING_TYPES_B reporting_types
1636: -- ZX_REPORTING_CODES_B report_codes
1637: WHERE
1638: codes.tax_id = rates.tax_rate_id
1639: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1640: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1667: -- ZX_REPORTING_CODES_B report_codes

1663: FROM
1664: AP_TAX_CODES_ALL codes,
1665: ZX_RATES_B rates,
1666: ZX_REPORTING_TYPES_B reporting_types
1667: -- ZX_REPORTING_CODES_B report_codes
1668: WHERE
1669: codes.tax_id = rates.tax_rate_id
1670: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1671: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1698: -- ZX_REPORTING_CODES_B report_codes

1694: FROM
1695: AP_TAX_CODES_ALL codes,
1696: ZX_RATES_B rates,
1697: ZX_REPORTING_TYPES_B reporting_types
1698: -- ZX_REPORTING_CODES_B report_codes
1699: WHERE
1700: codes.tax_id = rates.tax_rate_id
1701: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1702: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1729: -- ZX_REPORTING_CODES_B report_codes

1725: FROM
1726: AP_TAX_CODES_ALL codes,
1727: ZX_RATES_B rates,
1728: ZX_REPORTING_TYPES_B reporting_types
1729: -- ZX_REPORTING_CODES_B report_codes
1730: WHERE
1731:
1732: codes.tax_id = rates.tax_rate_id
1733: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 1763: -- ZX_REPORTING_CODES_B report_codes

1759: FROM
1760: AP_TAX_CODES_ALL codes,
1761: ZX_RATES_B rates,
1762: ZX_REPORTING_TYPES_B reporting_types
1763: -- ZX_REPORTING_CODES_B report_codes
1764: WHERE
1765: codes.tax_id = rates.tax_rate_id
1766: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
1767: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'

Line 1818: zx_reporting_codes_b codes,

1814: 1 -- Bug 5031787
1815: FROM
1816: financials_system_params_all fin_sys_param,
1817: zx_reporting_types_b types,
1818: zx_reporting_codes_b codes,
1819: xle_etb_profiles etb,
1820: zx_party_tax_profile ptp
1821:
1822: WHERE

Line 1868: zx_reporting_codes_b codes,

1864: 1 -- Bug 5031787
1865: FROM
1866: financials_system_params_all fin_sys_param,
1867: zx_reporting_types_b types,
1868: zx_reporting_codes_b codes,
1869: xle_etb_profiles etb,
1870: zx_party_tax_profile ptp
1871:
1872: WHERE

Line 1931: ZX_REPORTING_CODES_B report_codes,

1927: 1
1928: FROM
1929: AP_TAX_CODES_ALL codes,
1930: ZX_REPORTING_TYPES_B reporting_types,
1931: ZX_REPORTING_CODES_B report_codes,
1932: ZX_RATES_B rates
1933:
1934:
1935: WHERE

Line 2022: ZX_REPORTING_CODES_B report_codes

2018:
2019: AR_VAT_TAX_ALL_B codes,
2020: ZX_RATES_B rates,
2021: ZX_REPORTING_TYPES_B report_types,
2022: ZX_REPORTING_CODES_B report_codes
2023:
2024: WHERE
2025:
2026: codes.vat_tax_id = rates.tax_rate_id

Line 2060: ZX_REPORTING_CODES_B report_codes

2056:
2057: AR_VAT_TAX_ALL_B codes,
2058: ZX_RATES_B rates,
2059: ZX_REPORTING_TYPES_B report_types,
2060: ZX_REPORTING_CODES_B report_codes
2061:
2062: WHERE
2063:
2064: codes.vat_tax_id = rates.tax_rate_id

Line 2095: ZX_REPORTING_CODES_B report_codes

2091:
2092: AR_VAT_TAX_ALL_B codes,
2093: ZX_RATES_B rates,
2094: ZX_REPORTING_TYPES_B report_types,
2095: ZX_REPORTING_CODES_B report_codes
2096:
2097: WHERE
2098:
2099: codes.vat_tax_id = rates.tax_rate_id

Line 2130: ZX_REPORTING_CODES_B report_codes

2126:
2127: AR_VAT_TAX_ALL_B codes,
2128: ZX_RATES_B rates,
2129: ZX_REPORTING_TYPES_B report_types,
2130: ZX_REPORTING_CODES_B report_codes
2131:
2132: WHERE
2133:
2134: codes.vat_tax_id = rates.tax_rate_id

Line 2165: ZX_REPORTING_CODES_B report_codes

2161:
2162: AR_VAT_TAX_ALL_B codes,
2163: ZX_RATES_B rates,
2164: ZX_REPORTING_TYPES_B report_types,
2165: ZX_REPORTING_CODES_B report_codes
2166:
2167: WHERE
2168:
2169: codes.vat_tax_id = rates.tax_rate_id

Line 2234: -- ZX_REPORTING_CODES_B report_codes

2230:
2231: AR_VAT_TAX_ALL_B codes,
2232: ZX_RATES_B rates,
2233: ZX_REPORTING_TYPES_B report_types
2234: -- ZX_REPORTING_CODES_B report_codes
2235:
2236: WHERE
2237:
2238: codes.vat_tax_id = rates.tax_rate_id

Line 2269: -- ZX_REPORTING_CODES_B report_codes

2265:
2266: AR_VAT_TAX_ALL_B codes,
2267: ZX_RATES_B rates,
2268: ZX_REPORTING_TYPES_B report_types
2269: -- ZX_REPORTING_CODES_B report_codes
2270:
2271: WHERE
2272:
2273: codes.vat_tax_id = rates.tax_rate_id

Line 2304: -- ZX_REPORTING_CODES_B report_codes

2300:
2301: AR_VAT_TAX_ALL_B codes,
2302: ZX_RATES_B rates,
2303: ZX_REPORTING_TYPES_B report_types
2304: -- ZX_REPORTING_CODES_B report_codes
2305:
2306: WHERE
2307:
2308: codes.vat_tax_id = rates.tax_rate_id

Line 2341: -- ZX_REPORTING_CODES_B report_codes

2337:
2338: AR_VAT_TAX_ALL_B codes,
2339: ZX_RATES_B rates,
2340: ZX_REPORTING_TYPES_B report_types
2341: -- ZX_REPORTING_CODES_B report_codes
2342:
2343: WHERE
2344:
2345: codes.vat_tax_id = rates.tax_rate_id

Line 2376: -- ZX_REPORTING_CODES_B report_codes

2372:
2373: AR_VAT_TAX_ALL_B codes,
2374: ZX_RATES_B rates,
2375: ZX_REPORTING_TYPES_B report_types
2376: -- ZX_REPORTING_CODES_B report_codes
2377:
2378: WHERE
2379:
2380: codes.vat_tax_id = rates.tax_rate_id

Line 2412: -- ZX_REPORTING_CODES_B report_codes

2408:
2409: AR_VAT_TAX_ALL_B codes,
2410: ZX_RATES_B rates,
2411: ZX_REPORTING_TYPES_B report_types
2412: -- ZX_REPORTING_CODES_B report_codes
2413:
2414: WHERE
2415:
2416: codes.vat_tax_id = rates.tax_rate_id

Line 2448: ZX_REPORTING_CODES_B report_codes

2444:
2445: AR_VAT_TAX_ALL_B codes,
2446: ZX_RATES_B rates,
2447: ZX_REPORTING_TYPES_B report_types,
2448: ZX_REPORTING_CODES_B report_codes
2449:
2450: WHERE
2451:
2452: codes.vat_tax_id = rates.tax_rate_id

Line 2485: ZX_REPORTING_CODES_B report_codes

2481:
2482: AR_VAT_TAX_ALL_B codes,
2483: ZX_RATES_B rates,
2484: ZX_REPORTING_TYPES_B report_types,
2485: ZX_REPORTING_CODES_B report_codes
2486:
2487: WHERE
2488:
2489: codes.vat_tax_id = rates.tax_rate_id

Line 2522: ZX_REPORTING_CODES_B report_codes

2518:
2519: AR_VAT_TAX_ALL_B codes,
2520: ZX_RATES_B rates,
2521: ZX_REPORTING_TYPES_B report_types,
2522: ZX_REPORTING_CODES_B report_codes
2523:
2524: WHERE
2525:
2526: codes.vat_tax_id = rates.tax_rate_id

Line 2559: ZX_REPORTING_CODES_B report_codes

2555:
2556: AR_VAT_TAX_ALL_B codes,
2557: ZX_RATES_B rates,
2558: ZX_REPORTING_TYPES_B report_types,
2559: ZX_REPORTING_CODES_B report_codes
2560:
2561: WHERE
2562:
2563: codes.vat_tax_id = rates.tax_rate_id

Line 2596: ZX_REPORTING_CODES_B report_codes

2592:
2593: AR_VAT_TAX_ALL_B codes,
2594: ZX_RATES_B rates,
2595: ZX_REPORTING_TYPES_B report_types,
2596: ZX_REPORTING_CODES_B report_codes
2597:
2598: WHERE
2599:
2600: codes.vat_tax_id = rates.tax_rate_id

Line 2633: ZX_REPORTING_CODES_B report_codes

2629: FROM
2630: AR_VAT_TAX_ALL_TL codes,
2631: ZX_RATES_B rates,
2632: ZX_REPORTING_TYPES_B report_types,
2633: ZX_REPORTING_CODES_B report_codes
2634:
2635: WHERE
2636:
2637: codes.vat_tax_id = Nvl(rates.source_id,rates.tax_rate_id)

Line 2882: ZX_REPORTING_CODES_B report_codes,

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

Line 3487: INTO ZX_REPORTING_CODES_B(

3483: CREATE_REPORT_TYPE_PTP('MEMBER STATE', 'TEXT', 'Y');
3484:
3485: -- Create Reporting Codes for 'MEMBER STATE'
3486: INSERT
3487: INTO ZX_REPORTING_CODES_B(
3488: REPORTING_CODE_ID ,
3489: EXCEPTION_CODE ,
3490: EFFECTIVE_FROM ,
3491: EFFECTIVE_TO ,

Line 3507: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3503: REPORTING_TYPE_ID ,
3504: OBJECT_VERSION_NUMBER
3505: )
3506: SELECT
3507: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3508: NULL ,--EXCEPTION_CODE
3509: EFFECTIVE_FROM ,
3510: NULL ,--EFFECTIVE_TO
3511: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3542: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

3538: report_types.REPORTING_TYPE_CODE = 'MEMBER STATE'
3539: AND fin_sys_param.VAT_COUNTRY_CODE is NOT NULL
3540: -- AND report_types.RECORD_TYPE_CODE = 'MIGRATED' -- Bug 5344337
3541: AND NOT EXISTS
3542: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
3543: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
3544: fin_sys_param.VAT_COUNTRY_CODE = REPORTING_CODE_CHAR_VALUE
3545: )
3546: );

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

3545: )
3546: );
3547:
3548:
3549: /*Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 1.
3550: BugFix 3557652 REPORTING CODE IMPL FOR ARGENTINE DGI TRANSACTION CODE.
3551: Following Insert will take care of both of ABOVE since for both these
3552: the REPORTING CODES needs to pick up from FND_LOOKUPS */
3553:

Line 3557: INTO ZX_REPORTING_CODES_B(

3553:
3554: /* Commented for the Bug 4936036 : as the below logic is wrong and is based on the lookup_type = 'PT_LOCATION'
3555: which doesn't exist
3556: INSERT
3557: INTO ZX_REPORTING_CODES_B(
3558: REPORTING_CODE_ID ,
3559: EXCEPTION_CODE ,
3560: EFFECTIVE_FROM ,
3561: EFFECTIVE_TO ,

Line 3579: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3575: REPORTING_TYPE_ID,
3576: OBJECT_VERSION_NUMBER
3577: )
3578: SELECT
3579: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3580: NULL ,--EXCEPTION_CODE
3581: EFFECTIVE_FROM ,
3582: NULL ,--EFFECTIVE_TO
3583: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3618: AND NOT EXISTS(SELECT 1 FROM ZX_REPORTING_CODES_B

3614: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
3615: AND report_types.REPORTING_TYPE_CODE = lookups.LOOKUP_TYPE
3616: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
3617:
3618: AND NOT EXISTS(SELECT 1 FROM ZX_REPORTING_CODES_B
3619: WHERE REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID
3620: AND REPORTING_CODE_CHAR_VALUE = lookups.LOOKUP_CODE
3621: )
3622:

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

3622:
3623: );
3624: */
3625:
3626: --Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 2..7
3627: /* Commented : Bug 4936036 : Reporting Codes should not be created for the below reporting types
3628: as has_reporting_codes_flag = 'N'
3629: INSERT
3630: INTO ZX_REPORTING_CODES_B(

Line 3630: INTO ZX_REPORTING_CODES_B(

3626: --Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 2..7
3627: /* Commented : Bug 4936036 : Reporting Codes should not be created for the below reporting types
3628: as has_reporting_codes_flag = 'N'
3629: INSERT
3630: INTO ZX_REPORTING_CODES_B(
3631: REPORTING_CODE_ID ,
3632: EXCEPTION_CODE ,
3633: EFFECTIVE_FROM ,
3634: EFFECTIVE_TO ,

Line 3652: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3648: REPORTING_TYPE_ID ,
3649: OBJECT_VERSION_NUMBER
3650: )
3651: SELECT
3652: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3653: NULL ,--EXCEPTION_CODE
3654: effective_from ,
3655: NULL ,--EFFECTIVE_TO
3656: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3693: (select 1 from zx_reporting_codes_b where

3689: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'
3690: AND codes.global_attribute2 IS NOT NULL
3691:
3692: AND (NOT EXISTS
3693: (select 1 from zx_reporting_codes_b where
3694: reporting_type_code = types.reporting_type_code and
3695: REPORTING_CODE_CHAR_VALUE=codes.global_attribute2 )
3696: )
3697:

Line 3720: (select 1 from zx_reporting_codes_b where

3716: AND codes.global_attribute3 IS NOT NULL
3717:
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_attribute3 )
3723: )
3724:

Line 3745: (select 1 from zx_reporting_codes_b where

3741: AND codes.global_attribute_category = 'JE.PT.APXTADTC.TAX_INFO'
3742: AND codes.global_attribute4 IS NOT NULL
3743:
3744: AND (NOT EXISTS
3745: (select 1 from zx_reporting_codes_b where
3746: reporting_type_code = types.reporting_type_code and
3747: REPORTING_CODE_CHAR_VALUE=codes.global_attribute4 )
3748: )
3749:

Line 3770: (select 1 from zx_reporting_codes_b where

3766: AND codes.global_attribute5 IS NOT NULL
3767:
3768:
3769: AND (NOT EXISTS
3770: (select 1 from zx_reporting_codes_b where
3771: reporting_type_code = types.reporting_type_code and
3772: REPORTING_CODE_CHAR_VALUE=codes.global_attribute5 )
3773: )
3774:

Line 3796: (select 1 from zx_reporting_codes_b where

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

Line 3822: (select 1 from zx_reporting_codes_b where

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

Line 3909: ZX_REPORTING_CODES_B

3905: -- Bug Fix 4671652
3906: -- Creation of reporting codes for KR_BUSINESS_LOCATIONS
3907: INSERT ALL
3908: INTO
3909: ZX_REPORTING_CODES_B
3910: (
3911: REPORTING_CODE_ID ,
3912: EXCEPTION_CODE ,
3913: EFFECTIVE_FROM ,

Line 3933: ZX_REPORTING_CODES_B_S.NEXTVAL,

3929: OBJECT_VERSION_NUMBER
3930: )
3931: VALUES
3932: (
3933: ZX_REPORTING_CODES_B_S.NEXTVAL,
3934: NULL,
3935: l_start_date,
3936: NULL,
3937: 'MIGRATED',

Line 3971: ( select 1 from zx_reporting_codes_b where reporting_type_id =

3967: where zxrb.tax_rate_id = tax_id_values_and_codes.tax_id
3968: and tax_id_values_and_codes.tax_id = nvl(p_tax_id,tax_id_values_and_codes.tax_id)
3969: and tax_id_values_and_codes.location_code is not null
3970: and not exists
3971: ( select 1 from zx_reporting_codes_b where reporting_type_id =
3972: (select reporting_type_id FROM zx_reporting_types_b
3973: WHERE tax_regime_code = zxrb.tax_regime_code
3974: AND reporting_type_code = 'KR_BUSINESS_LOCATIONS')
3975: AND reporting_code_char_value = tax_id_values_and_codes.location_code);

Line 4035: ZX_REPORTING_CODES_B report_codes

4031: AP_TAX_CODES_ALL codes,
4032: HR_LOCATIONS hrloc,
4033: ZX_RATES_B rates,
4034: ZX_REPORTING_TYPES_B reporting_types,
4035: ZX_REPORTING_CODES_B report_codes
4036: WHERE
4037: codes.tax_id = rates.tax_rate_id
4038: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
4039: AND codes.global_attribute1 = TO_CHAR(hrloc.location_id)

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

4062:
4063: /* Used to create the reporting type and code for AR */
4064:
4065: PROCEDURE CREATE_ZX_REP_TYPE_CODES_AR(p_tax_id IN NUMBER ) IS
4066: --l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4874049
4067: l_exists_cnt NUMBER ; --Bug 5344337
4068: BEGIN
4069:
4070: IF PG_DEBUG = 'Y' THEN

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

4684: zx_rates.tax_regime_code;
4685: --Bug 4705196
4686: /*
4687: --Bug 4422813
4688: --The creation of zx_reporting_types_b , zx_reporting_codes_b and zx_reporting_codes_tl has been put together for
4689: --easy understanding
4690:
4691: INSERT ALL
4692: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4770: (select vat_tax_id from ar_vat_tax_all_b )
4771:
4772:
4773: LOOP
4774: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4775:
4776: INSERT ALL
4777: INTO
4778: ZX_REPORTING_CODES_B

Line 4778: ZX_REPORTING_CODES_B

4774: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4775:
4776: INSERT ALL
4777: INTO
4778: ZX_REPORTING_CODES_B
4779: (
4780: REPORTING_CODE_ID ,
4781: EXCEPTION_CODE ,
4782: EFFECTIVE_FROM ,

Line 4834: ( select 1 from zx_reporting_codes_b where reporting_type_id =

4830: and zxrb.tax_rate_id = avtl.vat_tax_id
4831: and language = l_language_code
4832: and printed_tax_name is not null
4833: and not exists
4834: ( select 1 from zx_reporting_codes_b where reporting_type_id =
4835: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = zxrb.tax_regime_code
4836: and reporting_type_code = 'PRINTED_TAX_RATE_NAME')
4837: and reporting_code_char_value = printed_tax_name)
4838: );

Line 4994: ZX_REPORTING_CODES_B

4990: --Creation of Reporting Codes for Reporting Type ZX_ADJ_TAX_CLASSIF_CODE
4991:
4992: INSERT ALL
4993: INTO
4994: ZX_REPORTING_CODES_B
4995: (
4996: REPORTING_CODE_ID ,
4997: EXCEPTION_CODE ,
4998: EFFECTIVE_FROM ,

Line 5018: ZX_REPORTING_CODES_B_S.NEXTVAL,

5014: OBJECT_VERSION_NUMBER
5015: )
5016: VALUES
5017: (
5018: ZX_REPORTING_CODES_B_S.NEXTVAL,
5019: NULL,
5020: l_start_date,
5021: NULL,
5022: 'MIGRATED',

Line 5048: ( select 1 from zx_reporting_codes_b where reporting_type_id =

5044: zx_rates_b zxrb
5045: where zxrb.tax_rate_id = avtb.vat_tax_id
5046: and adjustment_tax_code is not null
5047: and not exists
5048: ( select 1 from zx_reporting_codes_b where reporting_type_id =
5049: (select reporting_type_id FROM zx_reporting_types_b
5050: WHERE tax_regime_code = zxrb.tax_regime_code
5051: AND reporting_type_code = 'ZX_ADJ_TAX_CLASSIF_CODE')
5052: AND reporting_code_char_value = adjustment_tax_code);

Line 5058: ZX_REPORTING_CODES_B

5054: --Bug# 4952838
5055: /* Bug 5031787 : Commented for the Bug as has_reporting_code_flag is 'N' and no codes creation is redundant
5056: INSERT ALL
5057: INTO
5058: ZX_REPORTING_CODES_B
5059: (
5060: REPORTING_CODE_ID ,
5061: EXCEPTION_CODE ,
5062: EFFECTIVE_FROM ,

Line 5082: ZX_REPORTING_CODES_B_S.NEXTVAL,

5078: OBJECT_VERSION_NUMBER
5079: )
5080: VALUES
5081: (
5082: ZX_REPORTING_CODES_B_S.NEXTVAL,
5083: NULL,
5084: l_start_date,
5085: NULL,
5086: 'MIGRATED',

Line 5113: ( select 1 from zx_reporting_codes_b where reporting_type_id =

5109: where zxrb.tax_rate_id = avtb.vat_tax_id
5110: and avtb.global_attribute_category ='JL.CL.ARXSUVAT.VAT_TAX'
5111: and avtb.global_attribute5 is not null
5112: and not exists
5113: ( select 1 from zx_reporting_codes_b where reporting_type_id =
5114: (select reporting_type_id FROM zx_reporting_types_b
5115: WHERE tax_regime_code = zxrb.tax_regime_code
5116: AND reporting_type_code = 'CL_DEBIT_ACCOUNT')
5117: AND reporting_code_char_value = avtb.global_attribute5);*/

Line 5296: INTO ZX_REPORTING_CODES_B(

5292: ELSE l_lookup_code := 'M';
5293: END IF ;
5294:
5295: INSERT
5296: INTO ZX_REPORTING_CODES_B(
5297: REPORTING_CODE_ID ,
5298: EXCEPTION_CODE ,
5299: EFFECTIVE_FROM ,
5300: EFFECTIVE_TO ,

Line 5318: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5314: REPORTING_TYPE_ID ,
5315: OBJECT_VERSION_NUMBER
5316: )
5317: SELECT
5318: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5319: NULL ,--EXCEPTION_CODE
5320: report_types.EFFECTIVE_FROM ,
5321: NULL ,--EFFECTIVE_TO
5322: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 5343: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

5339: WHERE
5340: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
5341: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
5342: AND NOT EXISTS
5343: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
5344: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
5345: REPORTING_CODE_CHAR_VALUE= l_lookup_code
5346: );
5347: END LOOP ; */

Line 5379: ZX_REPORTING_CODES_B CODES,

5375: sysdate ,
5376: fnd_global.conc_login_id
5377: FROM
5378: ZX_REPORTING_TYPES_B TYPES,
5379: ZX_REPORTING_CODES_B CODES,
5380: FND_LOOKUP_VALUES lookups,
5381: FND_LANGUAGES L
5382: WHERE
5383: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID

Line 5427: ZX_REPORTING_CODES_B CODES,

5423: sysdate ,
5424: fnd_global.conc_login_id
5425: FROM
5426: ZX_REPORTING_TYPES_B TYPES,
5427: ZX_REPORTING_CODES_B CODES,
5428: FND_LOOKUP_VALUES lookups,
5429: FND_LANGUAGES L
5430: WHERE
5431: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID

Line 5449: INTO ZX_REPORTING_CODES_B(

5445: */
5446:
5447: -- YK:9/22/2004: Korean GDF: Reporting Code creation
5448: INSERT
5449: INTO ZX_REPORTING_CODES_B(
5450: REPORTING_CODE_ID ,
5451: REPORTING_CODE_CHAR_VALUE,
5452: REPORTING_CODE_NUM_VALUE,
5453: REPORTING_CODE_DATE_VALUE,

Line 5471: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5467: PROGRAM_LOGIN_ID ,
5468: OBJECT_VERSION_NUMBER
5469: )
5470: SELECT
5471: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5472: global_attribute ,--REPORTING_CODE_CHAR_VALUE
5473: NULL ,--REPORTING_CODE_NUM_VALUE
5474: NULL ,--REPORTING_CODE_DATE_VALUE
5475: reporting_type_id ,--REPORTING_TYPE_ID

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

5502: AND types.record_type_code = 'MIGRATED'
5503: AND locations.global_attribute_category = 'JA.KR.PERWSLOC.WITHHOLDING'
5504: AND locations.global_attribute1 IS NOT NULL
5505:
5506: AND (NOT EXISTS (select 1 from zx_reporting_codes_b
5507: where reporting_type_id = types.reporting_type_id
5508: and reporting_code_char_value = locations.location_code
5509: /*(select location_code
5510: from hr_locations

Line 5541: ZX_REPORTING_CODES_B CODES,

5537: sysdate ,
5538: fnd_global.conc_login_id
5539: FROM
5540: ZX_REPORTING_TYPES_B TYPES,
5541: ZX_REPORTING_CODES_B CODES,
5542: FND_LOOKUP_VALUES lookups,
5543: FND_LANGUAGES L
5544: WHERE
5545:

Line 5643: ZX_REPORTING_CODES_B

5639: --Creation of Reporting Codes for KR_BUSINESS_LOCATIONS
5640:
5641: INSERT ALL
5642: INTO
5643: ZX_REPORTING_CODES_B
5644: (
5645: REPORTING_CODE_ID ,
5646: EXCEPTION_CODE ,
5647: EFFECTIVE_FROM ,

Line 5667: ZX_REPORTING_CODES_B_S.NEXTVAL,

5663: OBJECT_VERSION_NUMBER
5664: )
5665: VALUES
5666: (
5667: ZX_REPORTING_CODES_B_S.NEXTVAL,
5668: NULL,
5669: l_start_date,
5670: NULL,
5671: 'MIGRATED',

Line 5705: ( select 1 from zx_reporting_codes_b where reporting_type_id =

5701: where zxrb.tax_rate_id = tax_id_values_and_codes.vat_tax_id
5702: and tax_id_values_and_codes.vat_tax_id = nvl(p_tax_id,tax_id_values_and_codes.vat_tax_id)
5703: and tax_id_values_and_codes.location_code is not null
5704: and not exists
5705: ( select 1 from zx_reporting_codes_b where reporting_type_id =
5706: (select reporting_type_id FROM zx_reporting_types_b
5707: WHERE tax_regime_code = zxrb.tax_regime_code
5708: AND reporting_type_code = 'KR_BUSINESS_LOCATIONS')
5709: AND reporting_code_char_value = tax_id_values_and_codes.location_code);

Line 5768: ZX_REPORTING_CODES_B report_codes

5764: AR_VAT_TAX_ALL_B codes,
5765: HR_LOCATIONS hrloc,
5766: ZX_RATES_B rates,
5767: ZX_REPORTING_TYPES_B reporting_types,
5768: ZX_REPORTING_CODES_B report_codes
5769: WHERE
5770: codes.vat_tax_id = rates.tax_rate_id
5771: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
5772: AND codes.global_attribute1 = TO_CHAR(hrloc.location_id)

Line 6249: INTO ZX_REPORTING_CODES_B(

6245: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
6246: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
6247: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
6248: INSERT
6249: INTO ZX_REPORTING_CODES_B(
6250: REPORTING_CODE_ID ,
6251: EXCEPTION_CODE ,
6252: EFFECTIVE_FROM ,
6253: EFFECTIVE_TO ,

Line 6271: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6267: REPORTING_TYPE_ID ,
6268: OBJECT_VERSION_NUMBER
6269: )
6270: SELECT
6271: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6272: NULL ,--EXCEPTION_CODE
6273: EFFECTIVE_FROM ,
6274: NULL ,--EFFECTIVE_TO
6275: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6306: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

6302: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
6303: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6304: AND lookups.LOOKUP_TYPE = p_lookup_type
6305: AND NOT EXISTS
6306: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
6307: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
6308: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6309: )
6310: );

Line 6341: ZX_REPORTING_CODES_B CODES,

6337: sysdate ,
6338: 0
6339: FROM
6340: ZX_REPORTING_TYPES_B TYPES,
6341: ZX_REPORTING_CODES_B CODES,
6342: FND_LOOKUP_VALUES lookups,
6343: FND_LANGUAGES L
6344: WHERE
6345:

Line 6516: INTO ZX_REPORTING_CODES_B(

6512: ELSE l_lookup_code := 'M';
6513: END IF ;
6514:
6515: INSERT
6516: INTO ZX_REPORTING_CODES_B(
6517: REPORTING_CODE_ID ,
6518: EXCEPTION_CODE ,
6519: EFFECTIVE_FROM ,
6520: EFFECTIVE_TO ,

Line 6538: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6534: REPORTING_TYPE_ID ,
6535: OBJECT_VERSION_NUMBER
6536: )
6537: SELECT
6538: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6539: NULL ,--EXCEPTION_CODE
6540: report_types.EFFECTIVE_FROM ,
6541: NULL ,--EFFECTIVE_TO
6542: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6563: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

6559: WHERE
6560: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'
6561: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6562: AND NOT EXISTS
6563: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
6564: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
6565: REPORTING_CODE_CHAR_VALUE= l_lookup_code
6566: );
6567: END LOOP ;

Line 6605: ZX_REPORTING_CODES_B CODES,

6601: 120 ,
6602: SYSDATE ,
6603: 0
6604: FROM
6605: ZX_REPORTING_CODES_B CODES,
6606: FND_LANGUAGES L
6607: WHERE
6608: CODES.RECORD_TYPE_CODE = 'SEEDED'
6609: AND codes.reporting_type_id = ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B

Line 6669: INTO ZX_REPORTING_CODES_B(

6665: CREATE_REPORT_TYPE_SEED('TW_GOVERNMENT_TAX_TYPE','TEXT','Y');
6666:
6667: --Create Reporting Codes
6668: INSERT
6669: INTO ZX_REPORTING_CODES_B(
6670: REPORTING_CODE_ID ,
6671: EXCEPTION_CODE ,
6672: EFFECTIVE_FROM ,
6673: EFFECTIVE_TO ,

Line 6691: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6687: REPORTING_TYPE_ID ,
6688: OBJECT_VERSION_NUMBER
6689: )
6690: SELECT
6691: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6692: NULL ,--EXCEPTION_CODE
6693: EFFECTIVE_FROM ,
6694: NULL ,--EFFECTIVE_TO
6695: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6726: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

6722: report_types.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'
6723: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6724: AND lookups.LOOKUP_TYPE = 'JATW_GOVERNMENT_TAX_TYPE'
6725: AND NOT EXISTS
6726: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
6727: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
6728: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6729: )
6730: );

Line 6761: ZX_REPORTING_CODES_B CODES,

6757: sysdate ,
6758: 0
6759: FROM
6760: ZX_REPORTING_TYPES_B TYPES,
6761: ZX_REPORTING_CODES_B CODES,
6762: FND_LOOKUP_VALUES lookups,
6763: FND_LANGUAGES L
6764: WHERE
6765:

Line 7136: INTO ZX_REPORTING_CODES_B(

7132: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(+)');
7133: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7134: arp_util_tax.debug('p_lookup_type = '||'ZX_TAX_TYPE_CATEGORY');
7135: INSERT
7136: INTO ZX_REPORTING_CODES_B(
7137: REPORTING_CODE_ID ,
7138: EXCEPTION_CODE ,
7139: EFFECTIVE_FROM ,
7140: EFFECTIVE_TO ,

Line 7158: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7154: REPORTING_TYPE_ID ,
7155: OBJECT_VERSION_NUMBER
7156: )
7157: SELECT
7158: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7159: NULL ,--EXCEPTION_CODE
7160: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7161: NULL ,--EFFECTIVE_TO
7162: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 7204: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE

7200: 'SERVICES','SERV','INTER EC','VAT-A','VAT-S',
7201: 'VAT-KA','VAT-KS','VAT-RA','VAT-RS','VAT-NO-REP',
7202: 'IL_VAT_EXEMPT','IL_VAT')
7203: AND NOT EXISTS
7204: (SELECT 1 FROM ZX_REPORTING_CODES_B WHERE
7205: REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID AND
7206: REPORTING_CODE_CHAR_VALUE = DECODE(lookups.LOOKUP_CODE,
7207: 'SALES','SALES_TAX',
7208: 'Exempt Vat','EXEMPT',

Line 7243: ZX_REPORTING_CODES_B CODES,

7239: sysdate ,
7240: fnd_global.conc_login_id
7241: FROM
7242: ZX_REPORTING_TYPES_B TYPES,
7243: ZX_REPORTING_CODES_B CODES,
7244: FND_LOOKUP_VALUES lookups,
7245: FND_LANGUAGES L
7246: WHERE
7247:

Line 7337: ZX_REPORTING_CODES_B report_codes,

7333: 1
7334: FROM
7335: AP_TAX_CODES_ALL codes,
7336: ZX_REPORTING_TYPES_B reporting_types,
7337: ZX_REPORTING_CODES_B report_codes,
7338: ZX_RATES_B rates,
7339: -- Bug 7620818
7340: ZX_REGIMES_B reg
7341: WHERE

Line 7409: ZX_REPORTING_CODES_B report_codes,

7405: 1
7406: FROM
7407: AR_VAT_TAX_ALL codes,
7408: ZX_REPORTING_TYPES_B reporting_types,
7409: ZX_REPORTING_CODES_B report_codes,
7410: ZX_RATES_B rates,
7411: -- Bug 7620818
7412: ZX_REGIMES_B reg
7413: WHERE

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

7597: AND NOT EXISTS ( select 1 from zx_report_types_usages
7598: where reporting_type_id = types.reporting_type_id
7599: and entity_code = 'ZX_RATES');
7600:
7601: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');
7602:
7603: INSERT
7604: INTO ZX_REPORTING_CODES_B(
7605: REPORTING_CODE_ID ,

Line 7604: INTO ZX_REPORTING_CODES_B(

7600:
7601: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');
7602:
7603: INSERT
7604: INTO ZX_REPORTING_CODES_B(
7605: REPORTING_CODE_ID ,
7606: EXCEPTION_CODE ,
7607: EFFECTIVE_FROM ,
7608: EFFECTIVE_TO ,

Line 7626: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7622: REPORTING_TYPE_ID ,
7623: OBJECT_VERSION_NUMBER
7624: )
7625: SELECT
7626: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7627: NULL ,--EXCEPTION_CODE
7628: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7629: NULL ,--EFFECTIVE_TO
7630: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 7664: FROM ZX_REPORTING_CODES_B

7660: --Consider only the following lookup_codes
7661: AND lookups.LOOKUP_CODE = 'REVERSE_CHARGE_VAT'
7662: AND NOT EXISTS
7663: (SELECT 1
7664: FROM ZX_REPORTING_CODES_B
7665: WHERE REPORTING_TYPE_ID = report_types.REPORTING_TYPE_ID
7666: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
7667: )
7668: );

Line 7699: ZX_REPORTING_CODES_B CODES,

7695: sysdate ,
7696: fnd_global.conc_login_id
7697: FROM
7698: ZX_REPORTING_TYPES_B TYPES,
7699: ZX_REPORTING_CODES_B CODES,
7700: FND_LOOKUP_VALUES lookups,
7701: FND_LANGUAGES L
7702: WHERE
7703:

Line 7762: ZX_REPORTING_CODES_B report_codes,

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