51: where profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS'), -- PROFILE_OPTION_ID
52: LEVEL_ID,
53: LEVEL_VALUE,
54: sysdate, --LAST_UPDATE_DATE
55: fnd_global.user_id, --LAST_UPDATED_BY
56: sysdate, --CREATION_DATE
57: fnd_global.user_id, --CREATED_BY
58: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
59: PROFILE_OPTION_VALUE,
53: LEVEL_VALUE,
54: sysdate, --LAST_UPDATE_DATE
55: fnd_global.user_id, --LAST_UPDATED_BY
56: sysdate, --CREATION_DATE
57: fnd_global.user_id, --CREATED_BY
58: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
59: PROFILE_OPTION_VALUE,
60: LEVEL_VALUE_APPLICATION_ID
61: FROM fnd_profile_option_values
54: sysdate, --LAST_UPDATE_DATE
55: fnd_global.user_id, --LAST_UPDATED_BY
56: sysdate, --CREATION_DATE
57: fnd_global.user_id, --CREATED_BY
58: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
59: PROFILE_OPTION_VALUE,
60: LEVEL_VALUE_APPLICATION_ID
61: FROM fnd_profile_option_values
62: WHERE profile_option_id = (select profile_option_id
92: where profile_option_name = 'ZX_ALLOW_TAX_UPDATE'), -- PROFILE_OPTION_ID
93: LEVEL_ID,
94: LEVEL_VALUE,
95: sysdate, --LAST_UPDATE_DATE
96: fnd_global.user_id, --LAST_UPDATED_BY
97: sysdate, --CREATION_DATE
98: fnd_global.user_id, --CREATED_BY
99: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
100: PROFILE_OPTION_VALUE,
94: LEVEL_VALUE,
95: sysdate, --LAST_UPDATE_DATE
96: fnd_global.user_id, --LAST_UPDATED_BY
97: sysdate, --CREATION_DATE
98: fnd_global.user_id, --CREATED_BY
99: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
100: PROFILE_OPTION_VALUE,
101: LEVEL_VALUE_APPLICATION_ID
102: FROM fnd_profile_option_values
95: sysdate, --LAST_UPDATE_DATE
96: fnd_global.user_id, --LAST_UPDATED_BY
97: sysdate, --CREATION_DATE
98: fnd_global.user_id, --CREATED_BY
99: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
100: PROFILE_OPTION_VALUE,
101: LEVEL_VALUE_APPLICATION_ID
102: FROM fnd_profile_option_values
103: WHERE profile_option_id = (select profile_option_id
134: where profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES'), -- PROFILE_OPTION_ID
135: LEVEL_ID,
136: LEVEL_VALUE,
137: sysdate, --LAST_UPDATE_DATE
138: fnd_global.user_id, --LAST_UPDATED_BY
139: sysdate, --CREATION_DATE
140: fnd_global.user_id, --CREATED_BY
141: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
142: PROFILE_OPTION_VALUE,
136: LEVEL_VALUE,
137: sysdate, --LAST_UPDATE_DATE
138: fnd_global.user_id, --LAST_UPDATED_BY
139: sysdate, --CREATION_DATE
140: fnd_global.user_id, --CREATED_BY
141: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
142: PROFILE_OPTION_VALUE,
143: LEVEL_VALUE_APPLICATION_ID
144: FROM fnd_profile_option_values
137: sysdate, --LAST_UPDATE_DATE
138: fnd_global.user_id, --LAST_UPDATED_BY
139: sysdate, --CREATION_DATE
140: fnd_global.user_id, --CREATED_BY
141: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
142: PROFILE_OPTION_VALUE,
143: LEVEL_VALUE_APPLICATION_ID
144: FROM fnd_profile_option_values
145: WHERE profile_option_id = (select profile_option_id
175: where profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT'), -- PROFILE_OPTION_ID
176: LEVEL_ID,
177: LEVEL_VALUE,
178: sysdate, --LAST_UPDATE_DATE
179: fnd_global.user_id, --LAST_UPDATED_BY
180: sysdate, --CREATION_DATE
181: fnd_global.user_id, --CREATED_BY
182: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
183: PROFILE_OPTION_VALUE,
177: LEVEL_VALUE,
178: sysdate, --LAST_UPDATE_DATE
179: fnd_global.user_id, --LAST_UPDATED_BY
180: sysdate, --CREATION_DATE
181: fnd_global.user_id, --CREATED_BY
182: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
183: PROFILE_OPTION_VALUE,
184: LEVEL_VALUE_APPLICATION_ID
185: FROM fnd_profile_option_values
178: sysdate, --LAST_UPDATE_DATE
179: fnd_global.user_id, --LAST_UPDATED_BY
180: sysdate, --CREATION_DATE
181: fnd_global.user_id, --CREATED_BY
182: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
183: PROFILE_OPTION_VALUE,
184: LEVEL_VALUE_APPLICATION_ID
185: FROM fnd_profile_option_values
186: WHERE profile_option_id = (select profile_option_id
217: where profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE'), -- PROFILE_OPTION_ID
218: LEVEL_ID,
219: LEVEL_VALUE,
220: sysdate, --LAST_UPDATE_DATE
221: fnd_global.user_id, --LAST_UPDATED_BY
222: sysdate, --CREATION_DATE
223: fnd_global.user_id, --CREATED_BY
224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
225: PROFILE_OPTION_VALUE,
219: LEVEL_VALUE,
220: sysdate, --LAST_UPDATE_DATE
221: fnd_global.user_id, --LAST_UPDATED_BY
222: sysdate, --CREATION_DATE
223: fnd_global.user_id, --CREATED_BY
224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
225: PROFILE_OPTION_VALUE,
226: LEVEL_VALUE_APPLICATION_ID
227: FROM fnd_profile_option_values
220: sysdate, --LAST_UPDATE_DATE
221: fnd_global.user_id, --LAST_UPDATED_BY
222: sysdate, --CREATION_DATE
223: fnd_global.user_id, --CREATED_BY
224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
225: PROFILE_OPTION_VALUE,
226: LEVEL_VALUE_APPLICATION_ID
227: FROM fnd_profile_option_values
228: WHERE profile_option_id = (select profile_option_id
259: where profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE'), -- PROFILE_OPTION_ID
260: LEVEL_ID,
261: LEVEL_VALUE,
262: sysdate, --LAST_UPDATE_DATE
263: fnd_global.user_id, --LAST_UPDATED_BY
264: sysdate, --CREATION_DATE
265: fnd_global.user_id, --CREATED_BY
266: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
267: PROFILE_OPTION_VALUE,
261: LEVEL_VALUE,
262: sysdate, --LAST_UPDATE_DATE
263: fnd_global.user_id, --LAST_UPDATED_BY
264: sysdate, --CREATION_DATE
265: fnd_global.user_id, --CREATED_BY
266: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
267: PROFILE_OPTION_VALUE,
268: LEVEL_VALUE_APPLICATION_ID
269: FROM fnd_profile_option_values
262: sysdate, --LAST_UPDATE_DATE
263: fnd_global.user_id, --LAST_UPDATED_BY
264: sysdate, --CREATION_DATE
265: fnd_global.user_id, --CREATED_BY
266: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
267: PROFILE_OPTION_VALUE,
268: LEVEL_VALUE_APPLICATION_ID
269: FROM fnd_profile_option_values
270: WHERE profile_option_id = (select profile_option_id
300: where profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), -- PROFILE_OPTION_ID
301: LEVEL_ID,
302: LEVEL_VALUE,
303: sysdate, --LAST_UPDATE_DATE
304: fnd_global.user_id, --LAST_UPDATED_BY
305: sysdate, --CREATION_DATE
306: fnd_global.user_id, --CREATED_BY
307: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
308: PROFILE_OPTION_VALUE,
302: LEVEL_VALUE,
303: sysdate, --LAST_UPDATE_DATE
304: fnd_global.user_id, --LAST_UPDATED_BY
305: sysdate, --CREATION_DATE
306: fnd_global.user_id, --CREATED_BY
307: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
308: PROFILE_OPTION_VALUE,
309: LEVEL_VALUE_APPLICATION_ID
310: FROM fnd_profile_option_values
303: sysdate, --LAST_UPDATE_DATE
304: fnd_global.user_id, --LAST_UPDATED_BY
305: sysdate, --CREATION_DATE
306: fnd_global.user_id, --CREATED_BY
307: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
308: PROFILE_OPTION_VALUE,
309: LEVEL_VALUE_APPLICATION_ID
310: FROM fnd_profile_option_values
311: WHERE profile_option_id = (select profile_option_id
345: where profile_option_name = 'ZX_TAXVDR_USENEXPRO'), -- PROFILE_OPTION_ID
346: LEVEL_ID,
347: LEVEL_VALUE,
348: sysdate, --LAST_UPDATE_DATE
349: fnd_global.user_id, --LAST_UPDATED_BY
350: sysdate, --CREATION_DATE
351: fnd_global.user_id, --CREATED_BY
352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353: PROFILE_OPTION_VALUE,
347: LEVEL_VALUE,
348: sysdate, --LAST_UPDATE_DATE
349: fnd_global.user_id, --LAST_UPDATED_BY
350: sysdate, --CREATION_DATE
351: fnd_global.user_id, --CREATED_BY
352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353: PROFILE_OPTION_VALUE,
354: LEVEL_VALUE_APPLICATION_ID
355: FROM fnd_profile_option_values valar
348: sysdate, --LAST_UPDATE_DATE
349: fnd_global.user_id, --LAST_UPDATED_BY
350: sysdate, --CREATION_DATE
351: fnd_global.user_id, --CREATED_BY
352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353: PROFILE_OPTION_VALUE,
354: LEVEL_VALUE_APPLICATION_ID
355: FROM fnd_profile_option_values valar
356: , fnd_profile_options fpoar
385: where profile_option_name = 'ZX_TAXVDR_TAXSELPARAM'), -- PROFILE_OPTION_ID
386: LEVEL_ID,
387: LEVEL_VALUE,
388: sysdate, --LAST_UPDATE_DATE
389: fnd_global.user_id, --LAST_UPDATED_BY
390: sysdate, --CREATION_DATE
391: fnd_global.user_id, --CREATED_BY
392: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
393: PROFILE_OPTION_VALUE,
387: LEVEL_VALUE,
388: sysdate, --LAST_UPDATE_DATE
389: fnd_global.user_id, --LAST_UPDATED_BY
390: sysdate, --CREATION_DATE
391: fnd_global.user_id, --CREATED_BY
392: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
393: PROFILE_OPTION_VALUE,
394: LEVEL_VALUE_APPLICATION_ID
395: FROM fnd_profile_option_values valar
388: sysdate, --LAST_UPDATE_DATE
389: fnd_global.user_id, --LAST_UPDATED_BY
390: sysdate, --CREATION_DATE
391: fnd_global.user_id, --CREATED_BY
392: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
393: PROFILE_OPTION_VALUE,
394: LEVEL_VALUE_APPLICATION_ID
395: FROM fnd_profile_option_values valar
396: , fnd_profile_options fpoar
426: where profile_option_name = 'ZX_TAXVDR_TAXTYPE'), -- PROFILE_OPTION_ID
427: LEVEL_ID,
428: LEVEL_VALUE,
429: sysdate, --LAST_UPDATE_DATE
430: fnd_global.user_id, --LAST_UPDATED_BY
431: sysdate, --CREATION_DATE
432: fnd_global.user_id, --CREATED_BY
433: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
434: PROFILE_OPTION_VALUE,
428: LEVEL_VALUE,
429: sysdate, --LAST_UPDATE_DATE
430: fnd_global.user_id, --LAST_UPDATED_BY
431: sysdate, --CREATION_DATE
432: fnd_global.user_id, --CREATED_BY
433: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
434: PROFILE_OPTION_VALUE,
435: LEVEL_VALUE_APPLICATION_ID
436: FROM fnd_profile_option_values valar
429: sysdate, --LAST_UPDATE_DATE
430: fnd_global.user_id, --LAST_UPDATED_BY
431: sysdate, --CREATION_DATE
432: fnd_global.user_id, --CREATED_BY
433: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
434: PROFILE_OPTION_VALUE,
435: LEVEL_VALUE_APPLICATION_ID
436: FROM fnd_profile_option_values valar
437: , fnd_profile_options fpoar
467: where profile_option_name = 'ZX_TAXVDR_SERVICEIND'), -- PROFILE_OPTION_ID
468: LEVEL_ID,
469: LEVEL_VALUE,
470: sysdate, --LAST_UPDATE_DATE
471: fnd_global.user_id, --LAST_UPDATED_BY
472: sysdate, --CREATION_DATE
473: fnd_global.user_id, --CREATED_BY
474: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
475: PROFILE_OPTION_VALUE,
469: LEVEL_VALUE,
470: sysdate, --LAST_UPDATE_DATE
471: fnd_global.user_id, --LAST_UPDATED_BY
472: sysdate, --CREATION_DATE
473: fnd_global.user_id, --CREATED_BY
474: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
475: PROFILE_OPTION_VALUE,
476: LEVEL_VALUE_APPLICATION_ID
477: FROM fnd_profile_option_values valar
470: sysdate, --LAST_UPDATE_DATE
471: fnd_global.user_id, --LAST_UPDATED_BY
472: sysdate, --CREATION_DATE
473: fnd_global.user_id, --CREATED_BY
474: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
475: PROFILE_OPTION_VALUE,
476: LEVEL_VALUE_APPLICATION_ID
477: FROM fnd_profile_option_values valar
478: , fnd_profile_options fpoar
507: where profile_option_name = 'ZX_TAXVDR_CASESENSITIVE'), -- PROFILE_OPTION_ID
508: LEVEL_ID,
509: LEVEL_VALUE,
510: sysdate, --LAST_UPDATE_DATE
511: fnd_global.user_id, --LAST_UPDATED_BY
512: sysdate, --CREATION_DATE
513: fnd_global.user_id, --CREATED_BY
514: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
515: PROFILE_OPTION_VALUE,
509: LEVEL_VALUE,
510: sysdate, --LAST_UPDATE_DATE
511: fnd_global.user_id, --LAST_UPDATED_BY
512: sysdate, --CREATION_DATE
513: fnd_global.user_id, --CREATED_BY
514: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
515: PROFILE_OPTION_VALUE,
516: LEVEL_VALUE_APPLICATION_ID
517: FROM fnd_profile_option_values valar
510: sysdate, --LAST_UPDATE_DATE
511: fnd_global.user_id, --LAST_UPDATED_BY
512: sysdate, --CREATION_DATE
513: fnd_global.user_id, --CREATED_BY
514: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
515: PROFILE_OPTION_VALUE,
516: LEVEL_VALUE_APPLICATION_ID
517: FROM fnd_profile_option_values valar
518: , fnd_profile_options fpoar
566: --
567: UPDATE fnd_profile_options
568: SET END_DATE_ACTIVE = sysdate,
569: LAST_UPDATE_DATE = sysdate,
570: LAST_UPDATED_BY = fnd_global.user_id,
571: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
572: WHERE profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS'
573: AND end_date_active IS NULL;
574:
567: UPDATE fnd_profile_options
568: SET END_DATE_ACTIVE = sysdate,
569: LAST_UPDATE_DATE = sysdate,
570: LAST_UPDATED_BY = fnd_global.user_id,
571: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
572: WHERE profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS'
573: AND end_date_active IS NULL;
574:
575: -- 1.
576:
577: UPDATE fnd_profile_options
578: SET END_DATE_ACTIVE = sysdate,
579: LAST_UPDATE_DATE = sysdate,
580: LAST_UPDATED_BY = fnd_global.user_id,
581: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
582: WHERE profile_option_name = 'AR_ALLOW_TAX_UPDATE'
583: AND end_date_active IS NULL;
584:
577: UPDATE fnd_profile_options
578: SET END_DATE_ACTIVE = sysdate,
579: LAST_UPDATE_DATE = sysdate,
580: LAST_UPDATED_BY = fnd_global.user_id,
581: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
582: WHERE profile_option_name = 'AR_ALLOW_TAX_UPDATE'
583: AND end_date_active IS NULL;
584:
585: -- 2.
586:
587: UPDATE fnd_profile_options
588: SET END_DATE_ACTIVE = sysdate,
589: LAST_UPDATE_DATE = sysdate,
590: LAST_UPDATED_BY = fnd_global.user_id,
591: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
592: WHERE profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES'
593: AND end_date_active IS NULL;
594:
587: UPDATE fnd_profile_options
588: SET END_DATE_ACTIVE = sysdate,
589: LAST_UPDATE_DATE = sysdate,
590: LAST_UPDATED_BY = fnd_global.user_id,
591: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
592: WHERE profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES'
593: AND end_date_active IS NULL;
594:
595: -- 3.
596:
597: UPDATE fnd_profile_options
598: SET END_DATE_ACTIVE = sysdate,
599: LAST_UPDATE_DATE = sysdate,
600: LAST_UPDATED_BY = fnd_global.user_id,
601: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
602: WHERE profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT'
603: AND end_date_active IS NULL;
604:
597: UPDATE fnd_profile_options
598: SET END_DATE_ACTIVE = sysdate,
599: LAST_UPDATE_DATE = sysdate,
600: LAST_UPDATED_BY = fnd_global.user_id,
601: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
602: WHERE profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT'
603: AND end_date_active IS NULL;
604:
605:
607:
608: UPDATE fnd_profile_options
609: SET END_DATE_ACTIVE = sysdate,
610: LAST_UPDATE_DATE = sysdate,
611: LAST_UPDATED_BY = fnd_global.user_id,
612: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
613: WHERE profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE'
614: AND end_date_active IS NULL;
615:
608: UPDATE fnd_profile_options
609: SET END_DATE_ACTIVE = sysdate,
610: LAST_UPDATE_DATE = sysdate,
611: LAST_UPDATED_BY = fnd_global.user_id,
612: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
613: WHERE profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE'
614: AND end_date_active IS NULL;
615:
616: -- 5.
617:
618: UPDATE fnd_profile_options
619: SET END_DATE_ACTIVE = sysdate,
620: LAST_UPDATE_DATE = sysdate,
621: LAST_UPDATED_BY = fnd_global.user_id,
622: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
623: WHERE profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE'
624: AND end_date_active IS NULL;
625:
618: UPDATE fnd_profile_options
619: SET END_DATE_ACTIVE = sysdate,
620: LAST_UPDATE_DATE = sysdate,
621: LAST_UPDATED_BY = fnd_global.user_id,
622: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
623: WHERE profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE'
624: AND end_date_active IS NULL;
625:
626: -- 6.
627:
628: UPDATE fnd_profile_options
629: SET END_DATE_ACTIVE = sysdate,
630: LAST_UPDATE_DATE = sysdate,
631: LAST_UPDATED_BY = fnd_global.user_id,
632: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
633: WHERE profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE'
634: AND end_date_active IS NULL;
635:
628: UPDATE fnd_profile_options
629: SET END_DATE_ACTIVE = sysdate,
630: LAST_UPDATE_DATE = sysdate,
631: LAST_UPDATED_BY = fnd_global.user_id,
632: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
633: WHERE profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE'
634: AND end_date_active IS NULL;
635:
636: -- 7.
639:
640: UPDATE fnd_profile_options
641: SET END_DATE_ACTIVE = sysdate,
642: LAST_UPDATE_DATE = sysdate,
643: LAST_UPDATED_BY = fnd_global.user_id,
644: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
645: WHERE profile_option_name = 'AR_TAXVDR_USENEXPRO'
646: AND end_date_active IS NULL;
647:
640: UPDATE fnd_profile_options
641: SET END_DATE_ACTIVE = sysdate,
642: LAST_UPDATE_DATE = sysdate,
643: LAST_UPDATED_BY = fnd_global.user_id,
644: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
645: WHERE profile_option_name = 'AR_TAXVDR_USENEXPRO'
646: AND end_date_active IS NULL;
647:
648: -- 8.
649:
650: UPDATE fnd_profile_options
651: SET END_DATE_ACTIVE = sysdate,
652: LAST_UPDATE_DATE = sysdate,
653: LAST_UPDATED_BY = fnd_global.user_id,
654: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
655: WHERE profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
656: AND end_date_active IS NULL;
657:
650: UPDATE fnd_profile_options
651: SET END_DATE_ACTIVE = sysdate,
652: LAST_UPDATE_DATE = sysdate,
653: LAST_UPDATED_BY = fnd_global.user_id,
654: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
655: WHERE profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
656: AND end_date_active IS NULL;
657:
658: -- 9.
659:
660: UPDATE fnd_profile_options
661: SET END_DATE_ACTIVE = sysdate,
662: LAST_UPDATE_DATE = sysdate,
663: LAST_UPDATED_BY = fnd_global.user_id,
664: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
665: WHERE profile_option_name = 'AR_TAXVDR_TAXTYPE'
666: AND end_date_active IS NULL;
667:
660: UPDATE fnd_profile_options
661: SET END_DATE_ACTIVE = sysdate,
662: LAST_UPDATE_DATE = sysdate,
663: LAST_UPDATED_BY = fnd_global.user_id,
664: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
665: WHERE profile_option_name = 'AR_TAXVDR_TAXTYPE'
666: AND end_date_active IS NULL;
667:
668: -- 10.
669:
670: UPDATE fnd_profile_options
671: SET END_DATE_ACTIVE = sysdate,
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATED_BY = fnd_global.user_id,
674: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
675: WHERE profile_option_name = 'AR_TAXVDR_SERVICEIND'
676: AND end_date_active IS NULL;
677:
670: UPDATE fnd_profile_options
671: SET END_DATE_ACTIVE = sysdate,
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATED_BY = fnd_global.user_id,
674: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
675: WHERE profile_option_name = 'AR_TAXVDR_SERVICEIND'
676: AND end_date_active IS NULL;
677:
678: -- 11.
679:
680: UPDATE fnd_profile_options
681: SET END_DATE_ACTIVE = sysdate,
682: LAST_UPDATE_DATE = sysdate,
683: LAST_UPDATED_BY = fnd_global.user_id,
684: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
685: WHERE profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
686: AND end_date_active IS NULL;
687:
680: UPDATE fnd_profile_options
681: SET END_DATE_ACTIVE = sysdate,
682: LAST_UPDATE_DATE = sysdate,
683: LAST_UPDATED_BY = fnd_global.user_id,
684: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
685: WHERE profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
686: AND end_date_active IS NULL;
687:
688: -- 12.