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 AR_VAT_TAX_ALL

Line 26: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,

22: PROCEDURE CREATE_REPORTING_TYPE_AR(
23: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
24: p_datatype IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_DATATYPE_CODE%TYPE,
25: p_has_rep_code IN ZX_REPORTING_TYPES_B.HAS_REPORTING_CODES_FLAG%TYPE,
26: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
27: p_tax_id IN NUMBER
28: );
29:
30: /* Common procedure used to create Reporting Types for AP*/

Line 35: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,

31: PROCEDURE CREATE_REPORTING_TYPE_AP(
32: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
33: p_datatype IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_DATATYPE_CODE%TYPE,
34: p_has_rep_code IN ZX_REPORTING_TYPES_B.HAS_REPORTING_CODES_FLAG%TYPE,
35: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
36: p_tax_id IN NUMBER
37: );
38:
39: /* Common procedure used to create Reporting Codes */

Line 866: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,

862: PROCEDURE CREATE_REPORTING_TYPE_AR(
863: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
864: p_datatype IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_DATATYPE_CODE%TYPE,
865: p_has_rep_code IN ZX_REPORTING_TYPES_B.HAS_REPORTING_CODES_FLAG%TYPE,
866: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
867: p_tax_id IN NUMBER
868: )
869: IS
870:

Line 934: AR_VAT_TAX_ALL_B vat_tax,

930: SELECT
931: min(zx_rates.effective_from) effective_from,
932: zx_rates.tax_regime_code l_tax_regime_code
933: FROM
934: AR_VAT_TAX_ALL_B vat_tax,
935: zx_rates_b zx_rates
936: WHERE
937: vat_tax.vat_tax_id = zx_rates.tax_rate_id
938: AND vat_tax.global_attribute_category = p_category

Line 955: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,

951: PROCEDURE CREATE_REPORTING_TYPE_AP(
952: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
953: p_datatype IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_DATATYPE_CODE%TYPE,
954: p_has_rep_code IN ZX_REPORTING_TYPES_B.HAS_REPORTING_CODES_FLAG%TYPE,
955: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
956: p_tax_id IN NUMBER
957: )
958: IS
959:

Line 2019: AR_VAT_TAX_ALL_B codes,

2015: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2016: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2017: FROM
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:

Line 2057: AR_VAT_TAX_ALL_B codes,

2053: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2054: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2055: FROM
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:

Line 2092: AR_VAT_TAX_ALL_B codes,

2088: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2089: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2090: FROM
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:

Line 2127: AR_VAT_TAX_ALL_B codes,

2123: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2124: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2125: FROM
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:

Line 2162: AR_VAT_TAX_ALL_B codes,

2158: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2159: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2160: FROM
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:

Line 2197: AR_VAT_TAX_ALL_B codes,

2193: NULL REPORTING_CODE_DATE_VALUE,
2194: NULL REPORTING_CODE_NUM_VALUE
2195:
2196: FROM
2197: AR_VAT_TAX_ALL_B codes,
2198: ZX_RATES_B rates,
2199: ZX_REPORTING_TYPES_B report_types
2200: WHERE
2201: codes.vat_tax_id = rates.tax_rate_id

Line 2231: AR_VAT_TAX_ALL_B codes,

2227: NULL REPORTING_CODE_NUM_VALUE
2228:
2229: FROM
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:

Line 2266: AR_VAT_TAX_ALL_B codes,

2262: NULL REPORTING_CODE_DATE_VALUE,
2263: NULL REPORTING_CODE_NUM_VALUE
2264: FROM
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:

Line 2301: AR_VAT_TAX_ALL_B codes,

2297: NULL REPORTING_CODE_DATE_VALUE,
2298: NULL REPORTING_CODE_NUM_VALUE
2299: FROM
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:

Line 2338: AR_VAT_TAX_ALL_B codes,

2334: NULL REPORTING_CODE_NUM_VALUE
2335:
2336: FROM
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:

Line 2373: AR_VAT_TAX_ALL_B codes,

2369: NULL REPORTING_CODE_DATE_VALUE,
2370: NULL REPORTING_CODE_NUM_VALUE
2371: FROM
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:

Line 2409: AR_VAT_TAX_ALL_B codes,

2405: NULL REPORTING_CODE_NUM_VALUE
2406:
2407: FROM
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:

Line 2445: AR_VAT_TAX_ALL_B codes,

2441: report_codes.REPORTING_CODE_NUM_VALUE
2442:
2443: FROM
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:

Line 2482: AR_VAT_TAX_ALL_B codes,

2478: report_codes.REPORTING_CODE_NUM_VALUE
2479:
2480: FROM
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:

Line 2519: AR_VAT_TAX_ALL_B codes,

2515: report_codes.REPORTING_CODE_NUM_VALUE
2516:
2517: FROM
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:

Line 2556: AR_VAT_TAX_ALL_B codes,

2552: report_codes.REPORTING_CODE_NUM_VALUE
2553:
2554: FROM
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:

Line 2593: AR_VAT_TAX_ALL_B codes,

2589: report_codes.REPORTING_CODE_NUM_VALUE
2590:
2591: FROM
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:

Line 2630: AR_VAT_TAX_ALL_TL codes,

2626: report_codes.REPORTING_CODE_CHAR_VALUE,
2627: report_codes.REPORTING_CODE_DATE_VALUE,
2628: report_codes.REPORTING_CODE_NUM_VALUE
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:

Line 2704: AR_VAT_TAX_ALL_B codes,

2700: rates.EFFECTIVE_FROM,
2701: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE
2702: FROM
2703: ZX_REPORTING_TYPES_B report_types,
2704: AR_VAT_TAX_ALL_B codes,
2705: ZX_RATES_B rates
2706:
2707: WHERE
2708: report_types.reporting_type_code= 'CL_BILLS_OF_EXCH_TAX'

Line 2731: AR_VAT_TAX_ALL_B codes,

2727: rates.EFFECTIVE_FROM,
2728: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE
2729: FROM
2730: ZX_REPORTING_TYPES_B report_types,
2731: AR_VAT_TAX_ALL_B codes,
2732: ZX_RATES_B rates
2733:
2734: WHERE
2735: report_types.reporting_type_code= 'AR_MUNICIPAL_JUR'

Line 2759: AR_VAT_TAX_ALL_B codes,

2755: rates.EFFECTIVE_FROM,
2756: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2757: FROM
2758: ZX_REPORTING_TYPES_B report_types,
2759: AR_VAT_TAX_ALL_B codes,
2760: ZX_RATES_B rates
2761:
2762: WHERE
2763: report_types.reporting_type_code= 'PRINT TAX LINE'

Line 2787: AR_VAT_TAX_ALL_B codes,

2783: rates.EFFECTIVE_FROM,
2784: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2785: FROM
2786: ZX_REPORTING_TYPES_B report_types,
2787: AR_VAT_TAX_ALL_B codes,
2788: ZX_RATES_B rates
2789:
2790: WHERE
2791: report_types.reporting_type_code= 'PRINT TAX LINE'

Line 2816: AR_VAT_TAX_ALL_B codes,

2812: rates.EFFECTIVE_FROM,
2813: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2814: FROM
2815: ZX_REPORTING_TYPES_B report_types,
2816: AR_VAT_TAX_ALL_B codes,
2817: ZX_RATES_B rates
2818:
2819: WHERE
2820: report_types.reporting_type_code= 'PRINT TAX LINE'

Line 2880: AR_VAT_TAX_ALL_B codes,

2876: report_codes.REPORTING_TYPE_ID REPORTING_TYPE_ID,
2877: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE,
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

Line 4493: AR_VAT_TAX_ALL_B vat_tax,

4489: SELECT
4490: min(zx_rates.effective_from) effective_from,
4491: zx_rates.tax_regime_code l_tax_regime_code
4492: FROM
4493: AR_VAT_TAX_ALL_B vat_tax,
4494: zx_rates_b zx_rates
4495: WHERE
4496: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4497: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)

Line 4675: AR_VAT_TAX_ALL_B codes,

4671: SELECT
4672: min(zx_rates.effective_from) effective_from,
4673: zx_rates.tax_regime_code l_tax_regime_code
4674: FROM
4675: AR_VAT_TAX_ALL_B codes,
4676: zx_rates_b zx_rates
4677: WHERE
4678: codes.vat_tax_id = zx_rates.tax_rate_id
4679: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)

Line 4752: ar_vat_tax_all_b vat_tax,

4748: min(zx_rates.effective_from) effective_from,
4749: zx_rates.tax_regime_code l_tax_regime_code
4750:
4751: FROM
4752: ar_vat_tax_all_b vat_tax,
4753: zx_rates_b zx_rates
4754: WHERE
4755: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4756: AND zx_rates.record_type_code = 'MIGRATED'

Line 4770: (select vat_tax_id from ar_vat_tax_all_b )

4766: select nvl(language_code,'US') into l_language_code from FND_LANGUAGES where installed_flag = 'B' ;
4767:
4768:
4769: for cursor_rec in
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;

Line 4827: from ar_vat_tax_all_tl avtl ,

4823: (select
4824: printed_tax_name ,
4825: zxrb.tax_regime_code l_tax_regime_code ,
4826: zxrb.effective_from l_start_date
4827: from ar_vat_tax_all_tl avtl ,
4828: zx_rates_b zxrb
4829: where zxrb.tax_rate_id = cursor_rec.vat_tax_id
4830: and zxrb.tax_rate_id = avtl.vat_tax_id
4831: and language = l_language_code

Line 4878: ar_vat_tax_all_tl avtl

4874: avtl.source_lang l_source_lang,
4875: avtl.printed_tax_name l_printed_tax_name
4876:
4877: from
4878: ar_vat_tax_all_tl avtl
4879: where avtl.vat_tax_id = cursor_rec.vat_tax_id
4880: and avtl.printed_tax_name is not null
4881: and not exists
4882: (select 1 from zx_reporting_codes_tl where reporting_code_id = l_seqid

Line 4898: ar_vat_tax_all_b vat_tax,

4894: --Creation of reporting type for REPORTING_TYPE_CODE ZX_ADJ_TAX_CLASSIF_CODE
4895: -- Bug 5344337
4896: SELECT COUNT(1) INTO l_exists_cnt
4897: FROM
4898: ar_vat_tax_all_b vat_tax,
4899: zx_rates_b zx_rates
4900: WHERE
4901: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4902: AND zx_rates.record_type_code = 'MIGRATED';

Line 4979: ar_vat_tax_all_b vat_tax,

4975: min(zx_rates.effective_from) effective_from,
4976: zx_rates.tax_regime_code l_tax_regime_code
4977:
4978: FROM
4979: ar_vat_tax_all_b vat_tax,
4980: zx_rates_b zx_rates
4981: WHERE
4982: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4983: AND zx_rates.record_type_code = 'MIGRATED'

Line 5043: from ar_vat_tax_all_b avtb ,

5039: select
5040: adjustment_tax_code ,
5041: zxrb.tax_regime_code l_tax_regime_code ,
5042: zxrb.effective_from l_start_date
5043: from ar_vat_tax_all_b avtb ,
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

Line 5107: from ar_vat_tax_all_b avtb ,

5103: select
5104: avtb.global_attribute5,
5105: zxrb.tax_regime_code l_tax_regime_code ,
5106: zxrb.effective_from l_start_date
5107: from ar_vat_tax_all_b avtb ,
5108: zx_rates_b zxrb
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

Line 5628: ar_vat_tax_all_b ar_vat,

5624: min(zx_rates.effective_from) effective_from,
5625: zx_rates.tax_regime_code l_tax_regime_code
5626:
5627: FROM
5628: ar_vat_tax_all_b ar_vat,
5629: zx_rates_b zx_rates
5630: WHERE
5631: ar_vat.vat_tax_id = zx_rates.tax_rate_id
5632: AND ar_vat.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'

Line 5696: from ar_vat_tax_all_b artax, hr_locations hrloc

5692: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
5693: from
5694: (
5695: select vat_tax_id,hrloc.location_code location_code
5696: from ar_vat_tax_all_b artax, hr_locations hrloc
5697: where artax.global_attribute_category = 'JA.KR.ARXSUVAT.VAT' -- Bug 5031787
5698: and artax.global_attribute1 = to_char(hrloc.location_id)
5699: ) tax_id_values_and_codes,
5700: zx_rates_b zxrb

Line 5764: AR_VAT_TAX_ALL_B codes,

5760: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
5761: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
5762: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
5763: FROM
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

Line 7407: AR_VAT_TAX_ALL codes,

7403: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7404: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
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

Line 7521: ar_vat_tax_all codes

7517: rates.tax_regime_code l_tax_regime_code,
7518: rates.tax l_tax,
7519: min(rates.effective_from) l_effective_from
7520: FROM zx_rates_b rates,
7521: ar_vat_tax_all codes
7522: WHERE rates.tax_rate_id = codes.vat_tax_id
7523: AND codes.tax_type = 'REVERSE_CHARGE_VAT'
7524: AND rates.record_type_code = 'MIGRATED'
7525: GROUP BY rates.tax_regime_code, rates.tax;

Line 7760: AR_VAT_TAX_ALL codes,

7756: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7757: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
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