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_TAX_DEF_COMMON dependencies on ZX_MIGRATE_UTIL

Line 49: Zx_Migrate_Util.GET_TAX_REGIME(

45: codes.name tax_code,
46: 'INPUT' tax_class,
47: case when codes.tax_type = 'USE'
48: then
49: Zx_Migrate_Util.GET_TAX_REGIME(
50: codes.tax_type,
51: codes.org_id)
52: else
53: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

Line 53: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

49: Zx_Migrate_Util.GET_TAX_REGIME(
50: codes.tax_type,
51: codes.org_id)
52: else
53: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'
54: end tax_regime_code,
55: Nvl(CASE WHEN codes.global_attribute_category
56: IN ('JE.CZ.APXTADTC.TAX_ORIGIN','JE.HU.APXTADTC.TAX_ORIGIN','JE.PL.APXTADTC.TAX_ORIGIN','JE.CH.APXTADTC.TAX_INFO'
57: )

Line 61: rtrim(substrb(CODES.GLOBAL_ATTRIBUTE1,1,24))||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')

57: )
58: THEN
59: CASE WHEN lengthb (codes.global_attribute1) > 30
60: THEN
61: rtrim(substrb(CODES.GLOBAL_ATTRIBUTE1,1,24))||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
62: ELSE
63: CODES.GLOBAL_ATTRIBUTE1
64: END
65: END

Line 69: RTRIM(substrb(Zx_Migrate_Util.GET_TAX(

65: END
66: ,
67: CASE WHEN codes.tax_type ='USE'
68: THEN
69: RTRIM(substrb(Zx_Migrate_Util.GET_TAX(
70: codes.name,
71: codes.tax_type),1,30))
72: ELSE
73: CASE WHEN

Line 74: Zx_Migrate_Util.GET_TAX(

70: codes.name,
71: codes.tax_type),1,30))
72: ELSE
73: CASE WHEN
74: Zx_Migrate_Util.GET_TAX(
75: codes.name,
76: codes.tax_type) <> codes.tax_type
77: THEN
78: CASE WHEN

Line 79: Lengthb(Zx_Migrate_Util.GET_TAX(

75: codes.name,
76: codes.tax_type) <> codes.tax_type
77: THEN
78: CASE WHEN
79: Lengthb(Zx_Migrate_Util.GET_TAX(
80: codes.name,
81: codes.tax_type)||'-'||codes.tax_type) > 30
82: THEN
83: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

Line 83: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

79: Lengthb(Zx_Migrate_Util.GET_TAX(
80: codes.name,
81: codes.tax_type)||'-'||codes.tax_type) > 30
82: THEN
83: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
84: codes.name,
85: codes.tax_type)||'-'||codes.tax_type,1,30))
86: ELSE
87: Zx_Migrate_Util.GET_TAX(

Line 87: Zx_Migrate_Util.GET_TAX(

83: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
84: codes.name,
85: codes.tax_type)||'-'||codes.tax_type,1,30))
86: ELSE
87: Zx_Migrate_Util.GET_TAX(
88: codes.name,
89: codes.tax_type)||'-'||codes.tax_type
90: END
91: ELSE

Line 92: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

88: codes.name,
89: codes.tax_type)||'-'||codes.tax_type
90: END
91: ELSE
92: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
93: codes.name,
94: codes.tax_type),1,30))
95: END
96:

Line 105: zx_migrate_util.get_country(codes.org_id) country_code,

101: nvl(codes.global_attribute1,'STANDARD'),
102: 'STANDARD') tax_status_code,
103: NULL recovery_type_code, --Bug Fix 5028009
104: 'N' frozen,
105: zx_migrate_util.get_country(codes.org_id) country_code,
106: codes.start_date effective_from,
107: codes.inactive_date effective_to,
108: fnd_global.user_id created_by,
109: sysdate creation_date,

Line 155: Zx_Migrate_Util.GET_TAX_REGIME(

151: codes.name tax_code,
152: 'INPUT' tax_class,
153: case when codes.tax_type = 'USE'
154: then
155: Zx_Migrate_Util.GET_TAX_REGIME(
156: codes.tax_type,
157: codes.org_id)
158: else
159: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

Line 159: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

155: Zx_Migrate_Util.GET_TAX_REGIME(
156: codes.tax_type,
157: codes.org_id)
158: else
159: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'
160: end tax_regime_code,
161: Nvl(CASE WHEN codes.global_attribute_category
162: IN ('JE.CZ.APXTADTC.TAX_ORIGIN','JE.HU.APXTADTC.TAX_ORIGIN','JE.PL.APXTADTC.TAX_ORIGIN','JE.CH.APXTADTC.TAX_INFO'
163: )

Line 167: rtrim(substrb(CODES.GLOBAL_ATTRIBUTE1,1,24))||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')

163: )
164: THEN
165: CASE WHEN lengthb (codes.global_attribute1) > 30
166: THEN
167: rtrim(substrb(CODES.GLOBAL_ATTRIBUTE1,1,24))||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
168: ELSE
169: CODES.GLOBAL_ATTRIBUTE1
170: END
171: END

Line 175: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

171: END
172: ,
173: CASE WHEN codes.tax_type ='USE'
174: THEN
175: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
176: codes.name,
177: codes.tax_type),1,30))
178: ELSE
179: CASE WHEN

Line 180: Zx_Migrate_Util.GET_TAX(

176: codes.name,
177: codes.tax_type),1,30))
178: ELSE
179: CASE WHEN
180: Zx_Migrate_Util.GET_TAX(
181: codes.name,
182: codes.tax_type) <> codes.tax_type
183: THEN
184: CASE WHEN

Line 185: lengthb(Zx_Migrate_Util.GET_TAX(

181: codes.name,
182: codes.tax_type) <> codes.tax_type
183: THEN
184: CASE WHEN
185: lengthb(Zx_Migrate_Util.GET_TAX(
186: codes.name,
187: codes.tax_type)||'-'||codes.tax_type) > 30
188: THEN
189: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

Line 189: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

185: lengthb(Zx_Migrate_Util.GET_TAX(
186: codes.name,
187: codes.tax_type)||'-'||codes.tax_type) > 30
188: THEN
189: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
190: codes.name,
191: codes.tax_type)||'-'||codes.tax_type,1,30))
192: ELSE
193: Zx_Migrate_Util.GET_TAX(

Line 193: Zx_Migrate_Util.GET_TAX(

189: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
190: codes.name,
191: codes.tax_type)||'-'||codes.tax_type,1,30))
192: ELSE
193: Zx_Migrate_Util.GET_TAX(
194: codes.name,
195: codes.tax_type)||'-'||codes.tax_type
196: END
197: ELSE

Line 198: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

194: codes.name,
195: codes.tax_type)||'-'||codes.tax_type
196: END
197: ELSE
198: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
199: codes.name,
200: codes.tax_type),1,30))
201: END
202:

Line 211: zx_migrate_util.get_country(codes.org_id) country_code,

207: nvl(codes.global_attribute1,'STANDARD'),
208: 'STANDARD') tax_status_code,
209: NULL recovery_type_code, --Bug Fix 5028009
210: 'N' frozen,
211: zx_migrate_util.get_country(codes.org_id) country_code,
212: codes.start_date effective_from,
213: codes.inactive_date effective_to,
214: fnd_global.user_id created_by,
215: sysdate creation_date,

Line 267: Zx_Migrate_Util.GET_TAX_REGIME(

263: offset.name tax_code,
264: 'INPUT' tax_class,
265: case when codes.tax_type = 'USE'
266: then
267: Zx_Migrate_Util.GET_TAX_REGIME(
268: codes.tax_type,
269: codes.org_id)
270: else
271: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

Line 271: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

267: Zx_Migrate_Util.GET_TAX_REGIME(
268: codes.tax_type,
269: codes.org_id)
270: else
271: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'
272: end tax_regime_code,
273: NVL(CASE WHEN offset.global_attribute_category
274: IN ('JE.CZ.APXTADTC.TAX_ORIGIN','JE.HU.APXTADTC.TAX_ORIGIN','JE.PL.APXTADTC.TAX_ORIGIN','JE.CH.APXTADTC.TAX_INFO'
275: )

Line 285: Zx_Migrate_Util.GET_TAX(

281: offset.GLOBAL_ATTRIBUTE1||'-OFFST'
282: END
283: END,
284: CASE WHEN
285: Zx_Migrate_Util.GET_TAX(
286: offset.name,
287: offset.tax_type)
288: <> offset.tax_type
289: THEN CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

Line 289: THEN CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

285: Zx_Migrate_Util.GET_TAX(
286: offset.name,
287: offset.tax_type)
288: <> offset.tax_type
289: THEN CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
290: offset.name,
291: offset.tax_type)
292: ||'-OFFSET-'||offset.tax_type) > 30 THEN
293: RTRIM(SUBSTRB(

Line 294: Zx_Migrate_Util.GET_TAX(

290: offset.name,
291: offset.tax_type)
292: ||'-OFFSET-'||offset.tax_type) > 30 THEN
293: RTRIM(SUBSTRB(
294: Zx_Migrate_Util.GET_TAX(
295: offset.name,
296: offset.tax_type)
297: ||'-OFFSET-'||offset.tax_type,1,30))
298: ELSE

Line 299: Zx_Migrate_Util.GET_TAX(

295: offset.name,
296: offset.tax_type)
297: ||'-OFFSET-'||offset.tax_type,1,30))
298: ELSE
299: Zx_Migrate_Util.GET_TAX(
300: offset.name,
301: offset.tax_type)
302: ||'-OFFSET-'||offset.tax_type
303: END

Line 305: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

301: offset.tax_type)
302: ||'-OFFSET-'||offset.tax_type
303: END
304: ELSE
305: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
306: offset.name,
307: offset.tax_type),1,24))
308: ||'-OFFST'
309: END )tax,

Line 316: zx_migrate_util.get_country(offset.org_id) country_code,

312: nvl(offset.global_attribute1,'STANDARD'),
313: 'STANDARD') tax_status_code,
314: NULL recovery_type_code, --Bug Fix 5028009
315: 'N' frozen,
316: zx_migrate_util.get_country(offset.org_id) country_code,
317: offset.start_date effective_from,
318: offset.inactive_date effective_to,
319: fnd_global.user_id created_by,
320: sysdate creation_date,

Line 371: Zx_Migrate_Util.GET_TAX_REGIME(

367: offset.name tax_code,
368: 'INPUT' tax_class,
369: case when codes.tax_type = 'USE'
370: then
371: Zx_Migrate_Util.GET_TAX_REGIME(
372: codes.tax_type,
373: codes.org_id)
374: else
375: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

Line 375: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'

371: Zx_Migrate_Util.GET_TAX_REGIME(
372: codes.tax_type,
373: codes.org_id)
374: else
375: Zx_Migrate_Util.Get_Country(codes.Org_Id)||'-Tax'
376: end tax_regime_code,
377: NVL(CASE WHEN offset.global_attribute_category
378: IN ('JE.CZ.APXTADTC.TAX_ORIGIN','JE.HU.APXTADTC.TAX_ORIGIN','JE.PL.APXTADTC.TAX_ORIGIN','JE.CH.APXTADTC.TAX_INFO'
379: )

Line 389: Zx_Migrate_Util.GET_TAX(

385: offset.GLOBAL_ATTRIBUTE1||'-OFFST'
386: END
387: END,
388: CASE WHEN
389: Zx_Migrate_Util.GET_TAX(
390: offset.name,
391: offset.tax_type)
392: <> offset.tax_type
393: THEN CASE WHEN LENGTHB(

Line 394: Zx_Migrate_Util.GET_TAX(

390: offset.name,
391: offset.tax_type)
392: <> offset.tax_type
393: THEN CASE WHEN LENGTHB(
394: Zx_Migrate_Util.GET_TAX(
395: offset.name,
396: offset.tax_type)
397: ||'-OFFSET-'||offset.tax_type) > 30 THEN
398: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 398: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

394: Zx_Migrate_Util.GET_TAX(
395: offset.name,
396: offset.tax_type)
397: ||'-OFFSET-'||offset.tax_type) > 30 THEN
398: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
399: offset.name,
400: offset.tax_type)
401: ||'-OFFSET-'||offset.tax_type,1,30))
402: ELSE

Line 403: Zx_Migrate_Util.GET_TAX(

399: offset.name,
400: offset.tax_type)
401: ||'-OFFSET-'||offset.tax_type,1,30))
402: ELSE
403: Zx_Migrate_Util.GET_TAX(
404: offset.name,
405: offset.tax_type)
406: ||'-OFFSET-'||offset.tax_type
407: END

Line 409: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

405: offset.tax_type)
406: ||'-OFFSET-'||offset.tax_type
407: END
408: ELSE
409: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
410: offset.name,
411: offset.tax_type),1,24))
412: ||'-OFFST'
413: END ) tax,

Line 420: zx_migrate_util.get_country(offset.org_id) country_code,

416: nvl(offset.global_attribute1,'STANDARD'),
417: 'STANDARD') tax_status_code,
418: NULL recovery_type_code, --Bug Fix 5028009
419: 'N' frozen,
420: zx_migrate_util.get_country(offset.org_id) country_code,
421: offset.start_date effective_from,
422: offset.inactive_date effective_to,
423: fnd_global.user_id created_by,
424: sysdate creation_date,

Line 476: Zx_Migrate_Util.Get_Country(Offset.Org_Id)||'-Tax' tax_regime_code,

472: offset.tax_id tax_code_id,
473: offset.org_id org_id,
474: offset.name tax_code,
475: 'INPUT' tax_class,
476: Zx_Migrate_Util.Get_Country(Offset.Org_Id)||'-Tax' tax_regime_code,
477: NVL(CASE WHEN offset.global_attribute_category
478: IN ('JE.CZ.APXTADTC.TAX_ORIGIN','JE.HU.APXTADTC.TAX_ORIGIN','JE.PL.APXTADTC.TAX_ORIGIN','JE.CH.APXTADTC.TAX_INFO'
479: )
480: THEN

Line 488: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

484: ELSE
485: offset.GLOBAL_ATTRIBUTE1
486: END
487: END,
488: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
489: offset.name,
490: offset.tax_type),1,24))
491: ) ||'-OFFST' tax,
492: DECODE(offset.global_attribute_category,

Line 498: zx_migrate_util.get_country(offset.org_id) country_code,

494: nvl(offset.global_attribute1,'STANDARD'),
495: 'STANDARD') tax_status_code,
496: NULL recovery_type_code, --Bug Fix 5028009
497: 'N' frozen,
498: zx_migrate_util.get_country(offset.org_id) country_code,
499: offset.start_date effective_from,
500: offset.inactive_date effective_to,
501: fnd_global.user_id created_by,
502: sysdate creation_date,

Line 546: Zx_Migrate_Util.Get_Country(Offset.Org_Id)||'-Tax' tax_regime_code,

542: offset.tax_id tax_code_id,
543: offset.org_id org_id,
544: offset.name tax_code,
545: 'INPUT' tax_class,
546: Zx_Migrate_Util.Get_Country(Offset.Org_Id)||'-Tax' tax_regime_code,
547: NVL(CASE WHEN offset.global_attribute_category
548: IN ('JE.CZ.APXTADTC.TAX_ORIGIN','JE.HU.APXTADTC.TAX_ORIGIN','JE.PL.APXTADTC.TAX_ORIGIN','JE.CH.APXTADTC.TAX_INFO'
549: )
550: THEN

Line 558: rtrim(substrb(Zx_Migrate_Util.GET_TAX(

554: ELSE
555: offset.GLOBAL_ATTRIBUTE1
556: END
557: END,
558: rtrim(substrb(Zx_Migrate_Util.GET_TAX(
559: offset.name,
560: offset.tax_type),1,24))
561: ) ||'-OFFST' tax,
562: DECODE(offset.global_attribute_category,

Line 568: zx_migrate_util.get_country(offset.org_id) country_code,

564: nvl(offset.global_attribute1,'STANDARD'),
565: 'STANDARD') tax_status_code,
566: NULL recovery_type_code, --Bug Fix 5028009
567: 'N' frozen,
568: zx_migrate_util.get_country(offset.org_id) country_code,
569: offset.start_date effective_from,
570: offset.inactive_date effective_to,
571: fnd_global.user_id created_by,
572: sysdate creation_date,

Line 633: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'

629: 'JL.CO.ARXSYSPA.SYS_PARAMETERS') THEN
630: asp.global_attribute13 || '-' || codes.tax_type
631: ELSE
632: CASE WHEN codes.tax_type <> 'SALES_TAX' then
633: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
634: ELSE
635:
636: Zx_Migrate_Util.GET_TAX_REGIME(
637: codes.tax_type,

Line 636: Zx_Migrate_Util.GET_TAX_REGIME(

632: CASE WHEN codes.tax_type <> 'SALES_TAX' then
633: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
634: ELSE
635:
636: Zx_Migrate_Util.GET_TAX_REGIME(
637: codes.tax_type,
638: codes.org_id)
639: END
640: END tax_regime_code,

Line 660: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(

656: and org_id = codes.org_id)
657: ELSE
658: NULL
659: END,
660: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
661: codes.tax_code,
662: codes.tax_type)
663: THEN
664: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 664: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

660: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
661: codes.tax_code,
662: codes.tax_type)
663: THEN
664: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
665: codes.tax_code,
666: codes.tax_type),1,30))
667: ELSE
668: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

Line 668: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

664: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
665: codes.tax_code,
666: codes.tax_type),1,30))
667: ELSE
668: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
669: codes.tax_code,
670: codes.tax_type)||'-'||codes.tax_type) > 30
671: THEN
672: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 672: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

668: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
669: codes.tax_code,
670: codes.tax_type)||'-'||codes.tax_type) > 30
671: THEN
672: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
673: codes.tax_code,
674: codes.tax_type)||'-'||codes.tax_type,1,30))
675: ELSE
676: Zx_Migrate_Util.GET_TAX(

Line 676: Zx_Migrate_Util.GET_TAX(

672: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
673: codes.tax_code,
674: codes.tax_type)||'-'||codes.tax_type,1,30))
675: ELSE
676: Zx_Migrate_Util.GET_TAX(
677: codes.tax_code,
678: codes.tax_type)||'-'||codes.tax_type
679: END
680: END

Line 691: zx_migrate_util.get_country(codes.org_id) country_code,

687: 'I', 'STANDARD-AR-INPUT',
688: 'STANDARD')) tax_status_code,
689: NULL recovery_type_code,
690: 'N' frozen,
691: zx_migrate_util.get_country(codes.org_id) country_code,
692: codes.start_date effective_from,
693: codes.end_date effective_to,
694: fnd_global.user_id created_by,
695: sysdate creation_date,

Line 757: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'

753: 'JL.CO.ARXSYSPA.SYS_PARAMETERS') THEN
754: asp.global_attribute13 || '-' || codes.tax_type
755: ELSE
756: CASE WHEN codes.tax_type <> 'SALES_TAX' then
757: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
758: ELSE
759:
760: Zx_Migrate_Util.GET_TAX_REGIME(
761: codes.tax_type,

Line 760: Zx_Migrate_Util.GET_TAX_REGIME(

756: CASE WHEN codes.tax_type <> 'SALES_TAX' then
757: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
758: ELSE
759:
760: Zx_Migrate_Util.GET_TAX_REGIME(
761: codes.tax_type,
762: codes.org_id)
763: END
764: END tax_regime_code,

Line 783: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(

779: and org_id = codes.org_id)
780: ELSE
781: NULL
782: END,
783: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
784: codes.tax_code,
785: codes.tax_type)
786: THEN
787: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 787: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

783: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
784: codes.tax_code,
785: codes.tax_type)
786: THEN
787: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
788: codes.tax_code,
789: codes.tax_type),1,30))
790: ELSE
791: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

Line 791: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

787: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
788: codes.tax_code,
789: codes.tax_type),1,30))
790: ELSE
791: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
792: codes.tax_code,
793: codes.tax_type)||'-'||codes.tax_type) > 30
794: THEN
795: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 795: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

791: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
792: codes.tax_code,
793: codes.tax_type)||'-'||codes.tax_type) > 30
794: THEN
795: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
796: codes.tax_code,
797: codes.tax_type)||'-'||codes.tax_type,1,30))
798: ELSE
799: Zx_Migrate_Util.GET_TAX(

Line 799: Zx_Migrate_Util.GET_TAX(

795: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
796: codes.tax_code,
797: codes.tax_type)||'-'||codes.tax_type,1,30))
798: ELSE
799: Zx_Migrate_Util.GET_TAX(
800: codes.tax_code,
801: codes.tax_type)||'-'||codes.tax_type
802: END
803:

Line 813: zx_migrate_util.get_country(codes.org_id) country_code,

809: 'I', 'STANDARD-AR-INPUT',
810: 'STANDARD')) tax_status_code,
811: NULL recovery_type_code,
812: 'N' frozen,
813: zx_migrate_util.get_country(codes.org_id) country_code,
814: codes.start_date effective_from,
815: codes.end_date effective_to,
816: fnd_global.user_id created_by,
817: sysdate creation_date,

Line 916: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'

912: codes.org_id org_id,
913: codes.tax_code tax_code,
914: 'OUTPUT' tax_class,
915: CASE WHEN codes.tax_type <> 'SALES_TAX' then
916: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
917: ELSE
918:
919: Zx_Migrate_Util.GET_TAX_REGIME(
920: codes.tax_type,

Line 919: Zx_Migrate_Util.GET_TAX_REGIME(

915: CASE WHEN codes.tax_type <> 'SALES_TAX' then
916: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
917: ELSE
918:
919: Zx_Migrate_Util.GET_TAX_REGIME(
920: codes.tax_type,
921: codes.org_id)
922: END tax_regime_code,
923: NVL(CASE WHEN codes.global_attribute_category IN ('JE.CZ.ARXSUVAT.TAX_ORIGIN',

Line 940: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(

936: and org_id = codes.org_id)
937: ELSE
938: NULL
939: END,
940: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
941: codes.tax_code,
942: codes.tax_type)
943: THEN
944: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 944: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

940: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
941: codes.tax_code,
942: codes.tax_type)
943: THEN
944: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
945: codes.tax_code,
946: codes.tax_type),1,30))
947: ELSE
948: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

Line 948: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

944: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
945: codes.tax_code,
946: codes.tax_type),1,30))
947: ELSE
948: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
949: codes.tax_code,
950: codes.tax_type)||'-'||codes.tax_type) > 30
951: THEN
952: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 952: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

948: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
949: codes.tax_code,
950: codes.tax_type)||'-'||codes.tax_type) > 30
951: THEN
952: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
953: codes.tax_code,
954: codes.tax_type)||'-'||codes.tax_type,1,30))
955: ELSE
956: Zx_Migrate_Util.GET_TAX(

Line 956: Zx_Migrate_Util.GET_TAX(

952: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
953: codes.tax_code,
954: codes.tax_type)||'-'||codes.tax_type,1,30))
955: ELSE
956: Zx_Migrate_Util.GET_TAX(
957: codes.tax_code,
958: codes.tax_type)||'-'||codes.tax_type
959: END
960: END

Line 973: zx_migrate_util.get_country(codes.org_id) country_code,

969: 'I', 'STANDARD-AR-INPUT',
970: 'STANDARD')) tax_status_code,
971: NULL recovery_type_code,
972: 'N' frozen,
973: zx_migrate_util.get_country(codes.org_id) country_code,
974: codes.start_date effective_from,
975: codes.end_date effective_to,
976: fnd_global.user_id created_by,
977: sysdate creation_date,

Line 1036: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'

1032: codes.org_id org_id,
1033: codes.tax_code tax_code,
1034: 'OUTPUT' tax_class,
1035: CASE WHEN codes.tax_type <> 'SALES_TAX' then
1036: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
1037: ELSE
1038: Zx_Migrate_Util.GET_TAX_REGIME(
1039: codes.tax_type,
1040: codes.org_id)

Line 1038: Zx_Migrate_Util.GET_TAX_REGIME(

1034: 'OUTPUT' tax_class,
1035: CASE WHEN codes.tax_type <> 'SALES_TAX' then
1036: Zx_Migrate_Util.Get_Country(Codes.Org_Id)||'-Tax'
1037: ELSE
1038: Zx_Migrate_Util.GET_TAX_REGIME(
1039: codes.tax_type,
1040: codes.org_id)
1041: END tax_regime_code,
1042: NVL(CASE WHEN codes.global_attribute_category IN ('JE.CZ.ARXSUVAT.TAX_ORIGIN',

Line 1059: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(

1055: and org_id = codes.org_id)
1056: ELSE
1057: NULL
1058: END,
1059: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
1060: codes.tax_code,
1061: codes.tax_type)
1062: THEN
1063: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 1063: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

1059: CASE WHEN codes.tax_type = Zx_Migrate_Util.GET_TAX(
1060: codes.tax_code,
1061: codes.tax_type)
1062: THEN
1063: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1064: codes.tax_code,
1065: codes.tax_type),1,30))
1066: ELSE
1067: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

Line 1067: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(

1063: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1064: codes.tax_code,
1065: codes.tax_type),1,30))
1066: ELSE
1067: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
1068: codes.tax_code,
1069: codes.tax_type)||'-'||codes.tax_type) > 30
1070: THEN
1071: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

Line 1071: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

1067: CASE WHEN LENGTHB(Zx_Migrate_Util.GET_TAX(
1068: codes.tax_code,
1069: codes.tax_type)||'-'||codes.tax_type) > 30
1070: THEN
1071: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1072: codes.tax_code,
1073: codes.tax_type)||'-'||codes.tax_type,1,30))
1074: ELSE
1075: Zx_Migrate_Util.GET_TAX(

Line 1075: Zx_Migrate_Util.GET_TAX(

1071: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1072: codes.tax_code,
1073: codes.tax_type)||'-'||codes.tax_type,1,30))
1074: ELSE
1075: Zx_Migrate_Util.GET_TAX(
1076: codes.tax_code,
1077: codes.tax_type)||'-'||codes.tax_type
1078: END
1079: END

Line 1092: zx_migrate_util.get_country(codes.org_id) country_code,

1088: 'I', 'STANDARD-AR-INPUT',
1089: 'STANDARD')) tax_status_code,
1090: NULL recovery_type_code,
1091: 'N' frozen,
1092: zx_migrate_util.get_country(codes.org_id) country_code,
1093: codes.start_date effective_from,
1094: codes.end_date effective_to,
1095: fnd_global.user_id created_by,
1096: sysdate creation_date,

Line 1184: Zx_Migrate_Util.GET_TAX_REGIME(

1180: ap_codes.tax_id tax_code_id,
1181: ap_codes.org_id org_id,
1182: ap_codes.name tax_code,
1183: 'INPUT' tax_class,
1184: Zx_Migrate_Util.GET_TAX_REGIME(
1185: ap_codes.tax_type,
1186: ap_codes.org_id) tax_regime_code,
1187: DECODE(ap_codes.global_attribute_category,
1188: 'JE.CZ.ARXSUVAT.TAX_ORIGIN',

Line 1200: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

1196: 'JE.PL.ARXSUVAT.TAX_ORIGIN',
1197: CASE WHEN LENGTHB(ap_codes.global_attribute1) > 30 THEN
1198: RTRIM(SUBSTRB(ap_codes.global_attribute1,1,24))
1199: ELSE ap_codes.global_attribute1 END,
1200: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1201: ap_codes.name,
1202: ap_codes.tax_type),1,30))
1203: ) tax,
1204: DECODE(ap_codes.global_attribute_category,

Line 1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,

1206: nvl(ap_codes.global_attribute1,'STANDARD'),
1207: 'STANDARD') tax_status_code,
1208: 'STANDARD' recovery_type_code,
1209: 'N' frozen,
1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1211: fnd_global.user_id created_by,
1212: sysdate creation_date,
1213: fnd_global.user_id last_updated_by,
1214: sysdate last_updated_date,

Line 1299: Zx_Migrate_Util.GET_TAX_REGIME(

1295: ar_codes.vat_tax_id tax_code_id,
1296: decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id) org_id,
1297: ar_codes.tax_code tax_code,
1298: 'OUTPUT' tax_class,
1299: Zx_Migrate_Util.GET_TAX_REGIME(
1300: ar_codes.tax_type,
1301: decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) tax_regime_code,
1302: -- YK:02/09/2005:Needs substrb
1303: NVL(CASE WHEN ar_codes.global_attribute_category IN ('JE.CZ.ARXSUVAT.TAX_ORIGIN',

Line 1320: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(

1316: and org_id = ar_codes.org_id)
1317: ELSE
1318: NULL
1319: END,
1320: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1321: ar_codes.tax_code,
1322: ar_codes.tax_type),1,30))) tax,
1323: DECODE(ar_codes.global_attribute_category,
1324: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),

Line 1331: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,

1327: 'I', 'STANDARD-AR-INPUT',
1328: 'STANDARD')) tax_status_code,
1329: NULL recovery_type_code,
1330: 'N' frozen,
1331: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1332: fnd_global.user_id created_by,
1333: sysdate creation_date,
1334: fnd_global.user_id last_updated_by,
1335: sysdate last_updated_date,

Line 1641: IF zx_migrate_util.is_installed('AP') = 'Y' THEN

1637:
1638: );
1639:
1640:
1641: IF zx_migrate_util.is_installed('AP') = 'Y' THEN
1642: /*------------------------------------------------------------------------------------
1643: |
1644: | For Brazilian Regimes : BR-IPI when BR-ICMS Regime exists
1645: |

Line 1988: IF zx_migrate_util.is_installed('AR') = 'Y' THEN

1984: WHERE tax_regime_code = 'BR-ISS');
1985:
1986: END IF;
1987:
1988: IF zx_migrate_util.is_installed('AR') = 'Y' THEN
1989: /*-------------------------------------------------------------------------
1990: |
1991: | For GTE US Sales Tax Regimes
1992: | It also inserts zx_regimes_tl.