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: AND NOT EXISTS (SELECT 1
315: FROM fnd_profile_option_values
316: WHERE profile_option_id = (SELECT profile_option_id

Line 317: FROM fnd_profile_options

313: where profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
314: AND NOT EXISTS (SELECT 1
315: FROM fnd_profile_option_values
316: WHERE profile_option_id = (SELECT profile_option_id
317: FROM fnd_profile_options
318: WHERE profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
319: );
320:
321: -- 7.

Line 342: from fnd_profile_options

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

Line 354: , fnd_profile_options fpoar

350: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
351: PROFILE_OPTION_VALUE,
352: LEVEL_VALUE_APPLICATION_ID
353: FROM fnd_profile_option_values valar
354: , fnd_profile_options fpoar
355: WHERE valar.profile_option_id = fpoar.profile_option_id
356: AND fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
357: AND NOT EXISTS (SELECT 1
358: FROM fnd_profile_option_values valzx

Line 359: , fnd_profile_options fpozx

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

Line 382: from fnd_profile_options

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

Line 394: , fnd_profile_options fpoar

390: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
391: PROFILE_OPTION_VALUE,
392: LEVEL_VALUE_APPLICATION_ID
393: FROM fnd_profile_option_values valar
394: , fnd_profile_options fpoar
395: WHERE valar.profile_option_id = fpoar.profile_option_id
396: AND fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
397: AND NOT EXISTS (SELECT 1
398: FROM fnd_profile_option_values valzx

Line 399: , fnd_profile_options fpozx

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

Line 423: from fnd_profile_options

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

Line 435: , fnd_profile_options fpoar

431: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
432: PROFILE_OPTION_VALUE,
433: LEVEL_VALUE_APPLICATION_ID
434: FROM fnd_profile_option_values valar
435: , fnd_profile_options fpoar
436: WHERE valar.profile_option_id = fpoar.profile_option_id
437: AND fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
438: AND NOT EXISTS (SELECT 1
439: FROM fnd_profile_option_values valzx

Line 440: , fnd_profile_options fpozx

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

Line 464: from fnd_profile_options

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

Line 476: , fnd_profile_options fpoar

472: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
473: PROFILE_OPTION_VALUE,
474: LEVEL_VALUE_APPLICATION_ID
475: FROM fnd_profile_option_values valar
476: , fnd_profile_options fpoar
477: WHERE valar.profile_option_id = fpoar.profile_option_id
478: AND fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
479: AND NOT EXISTS (SELECT 1
480: FROM fnd_profile_option_values valzx

Line 481: , fnd_profile_options fpozx

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

Line 504: from fnd_profile_options

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

Line 516: , fnd_profile_options fpoar

512: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
513: PROFILE_OPTION_VALUE,
514: LEVEL_VALUE_APPLICATION_ID
515: FROM fnd_profile_option_values valar
516: , fnd_profile_options fpoar
517: WHERE valar.profile_option_id = fpoar.profile_option_id
518: AND fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
519: AND NOT EXISTS (SELECT 1
520: FROM fnd_profile_option_values valzx

Line 521: , fnd_profile_options fpozx

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

Line 560: -- DISABLE/END DATE FND_PROFILE_OPTIONS

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

Line 565: UPDATE fnd_profile_options

561: --
562: -- Note: 04/08/2005
563: -- End dating profile should not be executed for pre-migration patch.
564: --
565: UPDATE fnd_profile_options
566: SET END_DATE_ACTIVE = sysdate,
567: LAST_UPDATE_DATE = sysdate,
568: LAST_UPDATED_BY = fnd_global.user_id,
569: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 575: UPDATE fnd_profile_options

571: AND end_date_active IS NULL;
572:
573: -- 1.
574:
575: UPDATE fnd_profile_options
576: SET END_DATE_ACTIVE = sysdate,
577: LAST_UPDATE_DATE = sysdate,
578: LAST_UPDATED_BY = fnd_global.user_id,
579: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 585: UPDATE fnd_profile_options

581: AND end_date_active IS NULL;
582:
583: -- 2.
584:
585: UPDATE fnd_profile_options
586: SET END_DATE_ACTIVE = sysdate,
587: LAST_UPDATE_DATE = sysdate,
588: LAST_UPDATED_BY = fnd_global.user_id,
589: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 595: UPDATE fnd_profile_options

591: AND end_date_active IS NULL;
592:
593: -- 3.
594:
595: UPDATE fnd_profile_options
596: SET END_DATE_ACTIVE = sysdate,
597: LAST_UPDATE_DATE = sysdate,
598: LAST_UPDATED_BY = fnd_global.user_id,
599: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 606: UPDATE fnd_profile_options

602:
603:
604: -- 4.
605:
606: UPDATE fnd_profile_options
607: SET END_DATE_ACTIVE = sysdate,
608: LAST_UPDATE_DATE = sysdate,
609: LAST_UPDATED_BY = fnd_global.user_id,
610: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 616: UPDATE fnd_profile_options

612: AND end_date_active IS NULL;
613:
614: -- 5.
615:
616: UPDATE fnd_profile_options
617: SET END_DATE_ACTIVE = sysdate,
618: LAST_UPDATE_DATE = sysdate,
619: LAST_UPDATED_BY = fnd_global.user_id,
620: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 626: UPDATE fnd_profile_options

622: AND end_date_active IS NULL;
623:
624: -- 6.
625:
626: UPDATE fnd_profile_options
627: SET END_DATE_ACTIVE = sysdate,
628: LAST_UPDATE_DATE = sysdate,
629: LAST_UPDATED_BY = fnd_global.user_id,
630: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 638: UPDATE fnd_profile_options

634: -- 7.
635:
636: /* Tax Vendor Profiles : Bug 4631047 */
637:
638: UPDATE fnd_profile_options
639: SET END_DATE_ACTIVE = sysdate,
640: LAST_UPDATE_DATE = sysdate,
641: LAST_UPDATED_BY = fnd_global.user_id,
642: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 648: UPDATE fnd_profile_options

644: AND end_date_active IS NULL;
645:
646: -- 8.
647:
648: UPDATE fnd_profile_options
649: SET END_DATE_ACTIVE = sysdate,
650: LAST_UPDATE_DATE = sysdate,
651: LAST_UPDATED_BY = fnd_global.user_id,
652: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 658: UPDATE fnd_profile_options

654: AND end_date_active IS NULL;
655:
656: -- 9.
657:
658: UPDATE fnd_profile_options
659: SET END_DATE_ACTIVE = sysdate,
660: LAST_UPDATE_DATE = sysdate,
661: LAST_UPDATED_BY = fnd_global.user_id,
662: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 668: UPDATE fnd_profile_options

664: AND end_date_active IS NULL;
665:
666: -- 10.
667:
668: UPDATE fnd_profile_options
669: SET END_DATE_ACTIVE = sysdate,
670: LAST_UPDATE_DATE = sysdate,
671: LAST_UPDATED_BY = fnd_global.user_id,
672: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 678: UPDATE fnd_profile_options

674: AND end_date_active IS NULL;
675:
676: -- 11.
677:
678: UPDATE fnd_profile_options
679: SET END_DATE_ACTIVE = sysdate,
680: LAST_UPDATE_DATE = sysdate,
681: LAST_UPDATED_BY = fnd_global.user_id,
682: LAST_UPDATE_LOGIN = fnd_global.conc_login_id