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_B

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 881: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,

877: PROCEDURE CREATE_REPORTING_TYPE_AR(
878: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
879: p_datatype IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_DATATYPE_CODE%TYPE,
880: p_has_rep_code IN ZX_REPORTING_TYPES_B.HAS_REPORTING_CODES_FLAG%TYPE,
881: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
882: p_tax_id IN NUMBER
883: )
884: IS
885:

Line 949: AR_VAT_TAX_ALL_B vat_tax,

945: SELECT
946: min(zx_rates.effective_from) effective_from,
947: zx_rates.tax_regime_code l_tax_regime_code
948: FROM
949: AR_VAT_TAX_ALL_B vat_tax,
950: zx_rates_b zx_rates
951: WHERE
952: vat_tax.vat_tax_id = zx_rates.tax_rate_id
953: AND vat_tax.global_attribute_category = p_category

Line 970: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,

966: PROCEDURE CREATE_REPORTING_TYPE_AP(
967: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
968: p_datatype IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_DATATYPE_CODE%TYPE,
969: p_has_rep_code IN ZX_REPORTING_TYPES_B.HAS_REPORTING_CODES_FLAG%TYPE,
970: P_category IN AR_VAT_TAX_ALL_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
971: p_tax_id IN NUMBER
972: )
973: IS
974:

Line 2046: AR_VAT_TAX_ALL_B codes,

2042: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2043: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2044: FROM
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:

Line 2084: AR_VAT_TAX_ALL_B codes,

2080: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2081: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2082: FROM
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:

Line 2119: AR_VAT_TAX_ALL_B codes,

2115: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2116: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2117: FROM
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:

Line 2154: AR_VAT_TAX_ALL_B codes,

2150: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2151: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2152: FROM
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:

Line 2189: AR_VAT_TAX_ALL_B codes,

2185: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
2186: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
2187: FROM
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:

Line 2224: AR_VAT_TAX_ALL_B codes,

2220: NULL REPORTING_CODE_DATE_VALUE,
2221: NULL REPORTING_CODE_NUM_VALUE
2222:
2223: FROM
2224: AR_VAT_TAX_ALL_B codes,
2225: ZX_RATES_B rates,
2226: ZX_REPORTING_TYPES_B report_types
2227: WHERE
2228: codes.vat_tax_id = rates.tax_rate_id

Line 2258: AR_VAT_TAX_ALL_B codes,

2254: NULL REPORTING_CODE_NUM_VALUE
2255:
2256: FROM
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:

Line 2293: AR_VAT_TAX_ALL_B codes,

2289: NULL REPORTING_CODE_DATE_VALUE,
2290: NULL REPORTING_CODE_NUM_VALUE
2291: FROM
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:

Line 2328: AR_VAT_TAX_ALL_B codes,

2324: NULL REPORTING_CODE_DATE_VALUE,
2325: NULL REPORTING_CODE_NUM_VALUE
2326: FROM
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:

Line 2365: AR_VAT_TAX_ALL_B codes,

2361: NULL REPORTING_CODE_NUM_VALUE
2362:
2363: FROM
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:

Line 2400: AR_VAT_TAX_ALL_B codes,

2396: NULL REPORTING_CODE_DATE_VALUE,
2397: NULL REPORTING_CODE_NUM_VALUE
2398: FROM
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:

Line 2436: AR_VAT_TAX_ALL_B codes,

2432: NULL REPORTING_CODE_NUM_VALUE
2433:
2434: FROM
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:

Line 2472: AR_VAT_TAX_ALL_B codes,

2468: report_codes.REPORTING_CODE_NUM_VALUE
2469:
2470: FROM
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:

Line 2509: AR_VAT_TAX_ALL_B codes,

2505: report_codes.REPORTING_CODE_NUM_VALUE
2506:
2507: FROM
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:

Line 2546: AR_VAT_TAX_ALL_B codes,

2542: report_codes.REPORTING_CODE_NUM_VALUE
2543:
2544: FROM
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:

Line 2583: AR_VAT_TAX_ALL_B codes,

2579: report_codes.REPORTING_CODE_NUM_VALUE
2580:
2581: FROM
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:

Line 2620: AR_VAT_TAX_ALL_B codes,

2616: report_codes.REPORTING_CODE_NUM_VALUE
2617:
2618: FROM
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:

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= 'CL_BILLS_OF_EXCH_TAX'

Line 2758: AR_VAT_TAX_ALL_B codes,

2754: rates.EFFECTIVE_FROM,
2755: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE
2756: FROM
2757: ZX_REPORTING_TYPES_B report_types,
2758: AR_VAT_TAX_ALL_B codes,
2759: ZX_RATES_B rates
2760:
2761: WHERE
2762: report_types.reporting_type_code= 'AR_MUNICIPAL_JUR'

Line 2786: AR_VAT_TAX_ALL_B codes,

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

Line 2814: AR_VAT_TAX_ALL_B codes,

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

Line 2843: AR_VAT_TAX_ALL_B codes,

2839: rates.EFFECTIVE_FROM,
2840: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE
2841: FROM
2842: ZX_REPORTING_TYPES_B report_types,
2843: AR_VAT_TAX_ALL_B codes,
2844: ZX_RATES_B rates
2845:
2846: WHERE
2847: report_types.reporting_type_code= 'PRINT TAX LINE'

Line 2907: AR_VAT_TAX_ALL_B codes,

2903: report_codes.REPORTING_TYPE_ID REPORTING_TYPE_ID,
2904: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE,
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

Line 4520: AR_VAT_TAX_ALL_B vat_tax,

4516: SELECT
4517: min(zx_rates.effective_from) effective_from,
4518: zx_rates.tax_regime_code l_tax_regime_code
4519: FROM
4520: AR_VAT_TAX_ALL_B vat_tax,
4521: zx_rates_b zx_rates
4522: WHERE
4523: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4524: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)

Line 4702: AR_VAT_TAX_ALL_B codes,

4698: SELECT
4699: min(zx_rates.effective_from) effective_from,
4700: zx_rates.tax_regime_code l_tax_regime_code
4701: FROM
4702: AR_VAT_TAX_ALL_B codes,
4703: zx_rates_b zx_rates
4704: WHERE
4705: codes.vat_tax_id = zx_rates.tax_rate_id
4706: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)

Line 4779: ar_vat_tax_all_b vat_tax,

4775: min(zx_rates.effective_from) effective_from,
4776: zx_rates.tax_regime_code l_tax_regime_code
4777:
4778: FROM
4779: ar_vat_tax_all_b vat_tax,
4780: zx_rates_b zx_rates
4781: WHERE
4782: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4783: AND zx_rates.record_type_code = 'MIGRATED'

Line 4797: (select vat_tax_id from ar_vat_tax_all_b )

4793: select nvl(language_code,'US') into l_language_code from FND_LANGUAGES where installed_flag = 'B' ;
4794:
4795:
4796: for cursor_rec in
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;

Line 4925: ar_vat_tax_all_b vat_tax,

4921: --Creation of reporting type for REPORTING_TYPE_CODE ZX_ADJ_TAX_CLASSIF_CODE
4922: -- Bug 5344337
4923: SELECT COUNT(1) INTO l_exists_cnt
4924: FROM
4925: ar_vat_tax_all_b vat_tax,
4926: zx_rates_b zx_rates
4927: WHERE
4928: vat_tax.vat_tax_id = zx_rates.tax_rate_id
4929: AND zx_rates.record_type_code = 'MIGRATED';

Line 5006: ar_vat_tax_all_b vat_tax,

5002: min(zx_rates.effective_from) effective_from,
5003: zx_rates.tax_regime_code l_tax_regime_code
5004:
5005: FROM
5006: ar_vat_tax_all_b vat_tax,
5007: zx_rates_b zx_rates
5008: WHERE
5009: vat_tax.vat_tax_id = zx_rates.tax_rate_id
5010: AND zx_rates.record_type_code = 'MIGRATED'

Line 5070: from ar_vat_tax_all_b avtb ,

5066: select
5067: adjustment_tax_code ,
5068: zxrb.tax_regime_code l_tax_regime_code ,
5069: min(zxrb.effective_from) l_start_date
5070: from ar_vat_tax_all_b avtb ,
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

Line 5136: from ar_vat_tax_all_b avtb ,

5132: select
5133: avtb.global_attribute5,
5134: zxrb.tax_regime_code l_tax_regime_code ,
5135: zxrb.effective_from l_start_date
5136: from ar_vat_tax_all_b avtb ,
5137: zx_rates_b zxrb
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

Line 5657: ar_vat_tax_all_b ar_vat,

5653: min(zx_rates.effective_from) effective_from,
5654: zx_rates.tax_regime_code l_tax_regime_code
5655:
5656: FROM
5657: ar_vat_tax_all_b ar_vat,
5658: zx_rates_b zx_rates
5659: WHERE
5660: ar_vat.vat_tax_id = zx_rates.tax_rate_id
5661: AND ar_vat.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'

Line 5725: from ar_vat_tax_all_b artax, hr_locations hrloc

5721: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
5722: from
5723: (
5724: select vat_tax_id,hrloc.location_code location_code
5725: from ar_vat_tax_all_b artax, hr_locations hrloc
5726: where artax.global_attribute_category = 'JA.KR.ARXSUVAT.VAT' -- Bug 5031787
5727: and artax.global_attribute1 = to_char(hrloc.location_id)
5728: ) tax_id_values_and_codes,
5729: zx_rates_b zxrb

Line 5793: AR_VAT_TAX_ALL_B codes,

5789: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
5790: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
5791: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
5792: FROM
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

Line 7903: FROM AR_VAT_TAX_ALL_B vat_tax,

7899: fnd_global.conc_login_id,
7900: 1
7901: )
7902: SELECT MIN(zx_rates.effective_from) effective_from
7903: FROM AR_VAT_TAX_ALL_B vat_tax,
7904: zx_rates_b zx_rates
7905: WHERE vat_tax.vat_tax_id = zx_rates.tax_rate_id
7906: AND zx_rates.record_type_code = ''MIGRATED''
7907: AND vat_tax.INTRA_EU_TRX_TYPE_CODE IS NOT NULL';

Line 7971: FROM AR_VAT_TAX_ALL_B vat_tax,

7967: fnd_global.conc_login_id,
7968: 1
7969: )
7970: SELECT MIN(zx_rates.effective_from) effective_from
7971: FROM AR_VAT_TAX_ALL_B vat_tax,
7972: zx_rates_b zx_rates
7973: WHERE vat_tax.vat_tax_id = zx_rates.tax_rate_id
7974: AND zx_rates.record_type_code = ''MIGRATED''
7975: AND vat_tax.LGL_JUSTIFICATION_MSG_CODE IS NOT NULL';

Line 8296: AR_VAT_TAX_ALL_B codes,

8292: report_codes.REPORTING_CODE_CHAR_VALUE,
8293: report_codes.REPORTING_CODE_DATE_VALUE,
8294: report_codes.REPORTING_CODE_NUM_VALUE
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

Line 8364: AR_VAT_TAX_ALL_B codes,

8360: report_codes.REPORTING_CODE_CHAR_VALUE,
8361: report_codes.REPORTING_CODE_DATE_VALUE,
8362: report_codes.REPORTING_CODE_NUM_VALUE
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

Line 8410: WHERE table_name = 'AR_VAT_TAX_ALL_B'

8406: PROCEDURE CREATE_REP_ENT_EUVAT IS
8407: CURSOR decide_euvat_upgrade IS
8408: SELECT NVL(SUM(1),0) result
8409: FROM sys.all_tab_columns
8410: WHERE table_name = 'AR_VAT_TAX_ALL_B'
8411: AND COLUMN_NAME IN ('INTRA_EU_TRX_TYPE_CODE','LGL_JUSTIFICATION_MSG_CODE');
8412:
8413: l_result NUMBER;
8414: