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_PROFILES dependencies on FND_PROFILE_OPTIONS

Line 50: from fnd_profile_options

46: )
47: SELECT
48: 235, -- APPLICATION_ID
49: (select profile_option_id
50: from fnd_profile_options
51: where profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS'), -- PROFILE_OPTION_ID
52: LEVEL_ID,
53: LEVEL_VALUE,
54: sysdate, --LAST_UPDATE_DATE

Line 63: from fnd_profile_options

59: PROFILE_OPTION_VALUE,
60: LEVEL_VALUE_APPLICATION_ID
61: FROM fnd_profile_option_values
62: WHERE profile_option_id = (select profile_option_id
63: from fnd_profile_options
64: where profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS')
65: AND NOT EXISTS (SELECT 1
66: FROM fnd_profile_option_values
67: WHERE profile_option_id = (SELECT profile_option_id

Line 68: FROM fnd_profile_options

64: where profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS')
65: AND NOT EXISTS (SELECT 1
66: FROM fnd_profile_option_values
67: WHERE profile_option_id = (SELECT profile_option_id
68: FROM fnd_profile_options
69: WHERE profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS')
70: );
71:
72: -- 1.

Line 91: from fnd_profile_options

87: )
88: SELECT
89: 235, -- APPLICATION_ID
90: (select profile_option_id
91: from fnd_profile_options
92: where profile_option_name = 'ZX_ALLOW_TAX_UPDATE'), -- PROFILE_OPTION_ID
93: LEVEL_ID,
94: LEVEL_VALUE,
95: sysdate, --LAST_UPDATE_DATE

Line 104: from fnd_profile_options

100: PROFILE_OPTION_VALUE,
101: LEVEL_VALUE_APPLICATION_ID
102: FROM fnd_profile_option_values
103: WHERE profile_option_id = (select profile_option_id
104: from fnd_profile_options
105: where profile_option_name = 'AR_ALLOW_TAX_UPDATE')
106: AND APPLICATION_ID = 222
107: AND NOT EXISTS (SELECT 1
108: FROM fnd_profile_option_values

Line 110: FROM fnd_profile_options

106: AND APPLICATION_ID = 222
107: AND NOT EXISTS (SELECT 1
108: FROM fnd_profile_option_values
109: WHERE profile_option_id = (SELECT profile_option_id
110: FROM fnd_profile_options
111: WHERE profile_option_name = 'ZX_ALLOW_TAX_UPDATE')
112: );
113:
114: -- 2.

Line 133: from fnd_profile_options

129: )
130: SELECT
131: 235, -- APPLICATION_ID
132: (select profile_option_id
133: from fnd_profile_options
134: where profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES'), -- PROFILE_OPTION_ID
135: LEVEL_ID,
136: LEVEL_VALUE,
137: sysdate, --LAST_UPDATE_DATE

Line 146: from fnd_profile_options

142: PROFILE_OPTION_VALUE,
143: LEVEL_VALUE_APPLICATION_ID
144: FROM fnd_profile_option_values
145: WHERE profile_option_id = (select profile_option_id
146: from fnd_profile_options
147: where profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES')
148: AND NOT EXISTS (SELECT 1
149: FROM fnd_profile_option_values
150: WHERE profile_option_id = (SELECT profile_option_id

Line 151: FROM fnd_profile_options

147: where profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES')
148: AND NOT EXISTS (SELECT 1
149: FROM fnd_profile_option_values
150: WHERE profile_option_id = (SELECT profile_option_id
151: FROM fnd_profile_options
152: WHERE profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
153: );
154:
155: -- 3.

Line 174: from fnd_profile_options

170: )
171: SELECT
172: 235, -- APPLICATION_ID
173: (select profile_option_id
174: from fnd_profile_options
175: where profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT'), -- PROFILE_OPTION_ID
176: LEVEL_ID,
177: LEVEL_VALUE,
178: sysdate, --LAST_UPDATE_DATE

Line 187: from fnd_profile_options

183: PROFILE_OPTION_VALUE,
184: LEVEL_VALUE_APPLICATION_ID
185: FROM fnd_profile_option_values
186: WHERE profile_option_id = (select profile_option_id
187: from fnd_profile_options
188: where profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT')
189: AND NOT EXISTS (SELECT 1
190: FROM fnd_profile_option_values
191: WHERE profile_option_id = (SELECT profile_option_id

Line 192: FROM fnd_profile_options

188: where profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT')
189: AND NOT EXISTS (SELECT 1
190: FROM fnd_profile_option_values
191: WHERE profile_option_id = (SELECT profile_option_id
192: FROM fnd_profile_options
193: WHERE profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT')
194: );
195:
196:

Line 216: from fnd_profile_options

212: )
213: SELECT
214: 235, -- APPLICATION_ID
215: (select profile_option_id
216: from fnd_profile_options
217: where profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE'), -- PROFILE_OPTION_ID
218: LEVEL_ID,
219: LEVEL_VALUE,
220: sysdate, --LAST_UPDATE_DATE

Line 229: from fnd_profile_options

225: PROFILE_OPTION_VALUE,
226: LEVEL_VALUE_APPLICATION_ID
227: FROM fnd_profile_option_values
228: WHERE profile_option_id = (select profile_option_id
229: from fnd_profile_options
230: where profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE')
231: AND NOT EXISTS (SELECT 1
232: FROM fnd_profile_option_values
233: WHERE profile_option_id = (SELECT profile_option_id

Line 234: FROM fnd_profile_options

230: where profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE')
231: AND NOT EXISTS (SELECT 1
232: FROM fnd_profile_option_values
233: WHERE profile_option_id = (SELECT profile_option_id
234: FROM fnd_profile_options
235: WHERE profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE')
236: );
237: */
238:

Line 258: from fnd_profile_options

254: )
255: SELECT
256: 235, -- APPLICATION_ID
257: (select profile_option_id
258: from fnd_profile_options
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

Line 271: from fnd_profile_options

267: PROFILE_OPTION_VALUE,
268: LEVEL_VALUE_APPLICATION_ID
269: FROM fnd_profile_option_values
270: WHERE profile_option_id = (select profile_option_id
271: from fnd_profile_options
272: where profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
273: AND NOT EXISTS (SELECT 1
274: FROM fnd_profile_option_values
275: WHERE profile_option_id = (SELECT profile_option_id

Line 276: FROM fnd_profile_options

272: where profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
273: AND NOT EXISTS (SELECT 1
274: FROM fnd_profile_option_values
275: WHERE profile_option_id = (SELECT profile_option_id
276: FROM fnd_profile_options
277: WHERE profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
278: );
279:
280: -- 6.

Line 299: from fnd_profile_options

295: )
296: SELECT
297: 235, -- APPLICATION_ID
298: (select profile_option_id
299: from fnd_profile_options
300: where profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), -- PROFILE_OPTION_ID
301: LEVEL_ID,
302: LEVEL_VALUE,
303: sysdate, --LAST_UPDATE_DATE

Line 312: from fnd_profile_options

308: PROFILE_OPTION_VALUE,
309: LEVEL_VALUE_APPLICATION_ID
310: FROM fnd_profile_option_values
311: WHERE profile_option_id = (select profile_option_id
312: from fnd_profile_options
313: where profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
314: --Bug 13371914
315: AND application_id = 222
316: AND NOT EXISTS (SELECT 1

Line 319: FROM fnd_profile_options

315: AND application_id = 222
316: AND NOT EXISTS (SELECT 1
317: FROM fnd_profile_option_values
318: WHERE profile_option_id = (SELECT profile_option_id
319: FROM fnd_profile_options
320: WHERE profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
321: );
322:
323: -- 7.

Line 344: from fnd_profile_options

340: )
341: SELECT
342: 235, -- APPLICATION_ID
343: (select profile_option_id
344: from fnd_profile_options
345: where profile_option_name = 'ZX_TAXVDR_USENEXPRO'), -- PROFILE_OPTION_ID
346: LEVEL_ID,
347: LEVEL_VALUE,
348: sysdate, --LAST_UPDATE_DATE

Line 356: , fnd_profile_options fpoar

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
357: WHERE valar.profile_option_id = fpoar.profile_option_id
358: AND fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
359: AND NOT EXISTS (SELECT 1
360: FROM fnd_profile_option_values valzx

Line 361: , fnd_profile_options fpozx

357: WHERE valar.profile_option_id = fpoar.profile_option_id
358: AND fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
359: AND NOT EXISTS (SELECT 1
360: FROM fnd_profile_option_values valzx
361: , fnd_profile_options fpozx
362: WHERE valzx.profile_option_id = fpozx.profile_option_id
363: AND fpozx.profile_option_name = 'ZX_TAXVDR_USENEXPRO');
364:
365: -- 8.

Line 384: from fnd_profile_options

380: )
381: SELECT
382: 235, -- APPLICATION_ID
383: (select profile_option_id
384: from fnd_profile_options
385: where profile_option_name = 'ZX_TAXVDR_TAXSELPARAM'), -- PROFILE_OPTION_ID
386: LEVEL_ID,
387: LEVEL_VALUE,
388: sysdate, --LAST_UPDATE_DATE

Line 396: , fnd_profile_options fpoar

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
397: WHERE valar.profile_option_id = fpoar.profile_option_id
398: AND fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
399: AND NOT EXISTS (SELECT 1
400: FROM fnd_profile_option_values valzx

Line 401: , fnd_profile_options fpozx

397: WHERE valar.profile_option_id = fpoar.profile_option_id
398: AND fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
399: AND NOT EXISTS (SELECT 1
400: FROM fnd_profile_option_values valzx
401: , fnd_profile_options fpozx
402: WHERE valzx.profile_option_id = fpozx.profile_option_id
403: AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXSELPARAM');
404:
405: -- 9.

Line 425: from fnd_profile_options

421: )
422: SELECT
423: 235, -- APPLICATION_ID
424: (select profile_option_id
425: from fnd_profile_options
426: where profile_option_name = 'ZX_TAXVDR_TAXTYPE'), -- PROFILE_OPTION_ID
427: LEVEL_ID,
428: LEVEL_VALUE,
429: sysdate, --LAST_UPDATE_DATE

Line 437: , fnd_profile_options fpoar

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
438: WHERE valar.profile_option_id = fpoar.profile_option_id
439: AND fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
440: AND NOT EXISTS (SELECT 1
441: FROM fnd_profile_option_values valzx

Line 442: , fnd_profile_options fpozx

438: WHERE valar.profile_option_id = fpoar.profile_option_id
439: AND fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
440: AND NOT EXISTS (SELECT 1
441: FROM fnd_profile_option_values valzx
442: , fnd_profile_options fpozx
443: WHERE valzx.profile_option_id = fpozx.profile_option_id
444: AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXTYPE');
445: */
446:

Line 466: from fnd_profile_options

462: )
463: SELECT
464: 235, -- APPLICATION_ID
465: (select profile_option_id
466: from fnd_profile_options
467: where profile_option_name = 'ZX_TAXVDR_SERVICEIND'), -- PROFILE_OPTION_ID
468: LEVEL_ID,
469: LEVEL_VALUE,
470: sysdate, --LAST_UPDATE_DATE

Line 478: , fnd_profile_options fpoar

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
479: WHERE valar.profile_option_id = fpoar.profile_option_id
480: AND fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
481: AND NOT EXISTS (SELECT 1
482: FROM fnd_profile_option_values valzx

Line 483: , fnd_profile_options fpozx

479: WHERE valar.profile_option_id = fpoar.profile_option_id
480: AND fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
481: AND NOT EXISTS (SELECT 1
482: FROM fnd_profile_option_values valzx
483: , fnd_profile_options fpozx
484: WHERE valzx.profile_option_id = fpozx.profile_option_id
485: AND fpozx.profile_option_name = 'ZX_TAXVDR_SERVICEIND');
486:
487: -- 11.

Line 506: from fnd_profile_options

502: )
503: SELECT
504: 235, -- APPLICATION_ID
505: (select profile_option_id
506: from fnd_profile_options
507: where profile_option_name = 'ZX_TAXVDR_CASESENSITIVE'), -- PROFILE_OPTION_ID
508: LEVEL_ID,
509: LEVEL_VALUE,
510: sysdate, --LAST_UPDATE_DATE

Line 518: , fnd_profile_options fpoar

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
519: WHERE valar.profile_option_id = fpoar.profile_option_id
520: AND fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
521: AND NOT EXISTS (SELECT 1
522: FROM fnd_profile_option_values valzx

Line 523: , fnd_profile_options fpozx

519: WHERE valar.profile_option_id = fpoar.profile_option_id
520: AND fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
521: AND NOT EXISTS (SELECT 1
522: FROM fnd_profile_option_values valzx
523: , fnd_profile_options fpozx
524: WHERE valzx.profile_option_id = fpozx.profile_option_id
525: AND fpozx.profile_option_name = 'ZX_TAXVDR_CASESENSITIVE');
526:
527: -- 12.

Line 562: -- DISABLE/END DATE FND_PROFILE_OPTIONS

558: IS
559: BEGIN
560: IF p_mig_phase <> 'PRE-MIG' THEN
561: --
562: -- DISABLE/END DATE FND_PROFILE_OPTIONS
563: --
564: -- Note: 04/08/2005
565: -- End dating profile should not be executed for pre-migration patch.
566: --

Line 567: UPDATE fnd_profile_options

563: --
564: -- Note: 04/08/2005
565: -- End dating profile should not be executed for pre-migration patch.
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

Line 577: UPDATE fnd_profile_options

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

Line 587: UPDATE fnd_profile_options

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

Line 597: UPDATE fnd_profile_options

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

Line 608: UPDATE fnd_profile_options

604:
605:
606: -- 4.
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

Line 618: UPDATE fnd_profile_options

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

Line 628: UPDATE fnd_profile_options

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

Line 640: UPDATE fnd_profile_options

636: -- 7.
637:
638: /* Tax Vendor Profiles : Bug 4631047 */
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

Line 650: UPDATE fnd_profile_options

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

Line 660: UPDATE fnd_profile_options

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

Line 670: UPDATE fnd_profile_options

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

Line 680: UPDATE fnd_profile_options

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