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_OPTION_VALUES

Line 31: -- INSERT FND_PROFILE_OPTION_VALUES

27: PROCEDURE migrate_tax_profile_values
28: IS
29: BEGIN
30: --
31: -- INSERT FND_PROFILE_OPTION_VALUES
32: --
33: INSERT INTO FND_PROFILE_OPTION_VALUES
34: (
35: APPLICATION_ID ,

Line 33: INSERT INTO FND_PROFILE_OPTION_VALUES

29: BEGIN
30: --
31: -- INSERT FND_PROFILE_OPTION_VALUES
32: --
33: INSERT INTO FND_PROFILE_OPTION_VALUES
34: (
35: APPLICATION_ID ,
36: PROFILE_OPTION_ID ,
37: LEVEL_ID ,

Line 61: FROM fnd_profile_option_values

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
63: from fnd_profile_options
64: where profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS')
65: AND NOT EXISTS (SELECT 1

Line 66: 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
68: FROM fnd_profile_options
69: WHERE profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS')
70: );

Line 74: INSERT INTO FND_PROFILE_OPTION_VALUES

70: );
71:
72: -- 1.
73:
74: INSERT INTO FND_PROFILE_OPTION_VALUES
75: (
76: APPLICATION_ID ,
77: PROFILE_OPTION_ID ,
78: LEVEL_ID ,

Line 102: FROM fnd_profile_option_values

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
104: from fnd_profile_options
105: where profile_option_name = 'AR_ALLOW_TAX_UPDATE')
106: AND APPLICATION_ID = 222

Line 108: FROM fnd_profile_option_values

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
109: WHERE profile_option_id = (SELECT profile_option_id
110: FROM fnd_profile_options
111: WHERE profile_option_name = 'ZX_ALLOW_TAX_UPDATE')
112: );

Line 116: INSERT INTO FND_PROFILE_OPTION_VALUES

112: );
113:
114: -- 2.
115:
116: INSERT INTO FND_PROFILE_OPTION_VALUES
117: (
118: APPLICATION_ID ,
119: PROFILE_OPTION_ID ,
120: LEVEL_ID ,

Line 144: FROM fnd_profile_option_values

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
146: from fnd_profile_options
147: where profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES')
148: AND NOT EXISTS (SELECT 1

Line 149: 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
151: FROM fnd_profile_options
152: WHERE profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
153: );

Line 157: INSERT INTO FND_PROFILE_OPTION_VALUES

153: );
154:
155: -- 3.
156: /*Bug 5529992
157: INSERT INTO FND_PROFILE_OPTION_VALUES
158: (
159: APPLICATION_ID ,
160: PROFILE_OPTION_ID ,
161: LEVEL_ID ,

Line 185: FROM fnd_profile_option_values

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
187: from fnd_profile_options
188: where profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT')
189: AND NOT EXISTS (SELECT 1

Line 190: 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
192: FROM fnd_profile_options
193: WHERE profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT')
194: );

Line 199: INSERT INTO FND_PROFILE_OPTION_VALUES

195:
196:
197: -- 4.
198:
199: INSERT INTO FND_PROFILE_OPTION_VALUES
200: (
201: APPLICATION_ID ,
202: PROFILE_OPTION_ID ,
203: LEVEL_ID ,

Line 227: FROM fnd_profile_option_values

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
229: from fnd_profile_options
230: where profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE')
231: AND NOT EXISTS (SELECT 1

Line 232: 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
234: FROM fnd_profile_options
235: WHERE profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE')
236: );

Line 241: INSERT INTO FND_PROFILE_OPTION_VALUES

237: */
238:
239: -- 5.
240:
241: INSERT INTO FND_PROFILE_OPTION_VALUES
242: (
243: APPLICATION_ID ,
244: PROFILE_OPTION_ID ,
245: LEVEL_ID ,

Line 269: FROM fnd_profile_option_values

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
271: from fnd_profile_options
272: where profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
273: AND NOT EXISTS (SELECT 1

Line 274: 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
276: FROM fnd_profile_options
277: WHERE profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
278: );

Line 282: INSERT INTO FND_PROFILE_OPTION_VALUES

278: );
279:
280: -- 6.
281:
282: INSERT INTO FND_PROFILE_OPTION_VALUES
283: (
284: APPLICATION_ID ,
285: PROFILE_OPTION_ID ,
286: LEVEL_ID ,

Line 310: FROM fnd_profile_option_values

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
312: from fnd_profile_options
313: where profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
314: --Bug 13371914

Line 317: FROM fnd_profile_option_values

313: where profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
314: --Bug 13371914
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: );

Line 327: INSERT INTO FND_PROFILE_OPTION_VALUES

323: -- 7.
324:
325: /* Vendor Profiles : Bug 4631047 */
326:
327: INSERT INTO FND_PROFILE_OPTION_VALUES
328: (
329: APPLICATION_ID ,
330: PROFILE_OPTION_ID ,
331: LEVEL_ID ,

Line 355: FROM fnd_profile_option_values valar

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
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

Line 360: FROM fnd_profile_option_values valzx

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
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:

Line 367: INSERT INTO FND_PROFILE_OPTION_VALUES

363: AND fpozx.profile_option_name = 'ZX_TAXVDR_USENEXPRO');
364:
365: -- 8.
366:
367: INSERT INTO FND_PROFILE_OPTION_VALUES
368: (
369: APPLICATION_ID ,
370: PROFILE_OPTION_ID ,
371: LEVEL_ID ,

Line 395: FROM fnd_profile_option_values valar

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
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

Line 400: FROM fnd_profile_option_values valzx

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
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:

Line 408: INSERT INTO FND_PROFILE_OPTION_VALUES

404:
405: -- 9.
406:
407: /*
408: INSERT INTO FND_PROFILE_OPTION_VALUES
409: (
410: APPLICATION_ID ,
411: PROFILE_OPTION_ID ,
412: LEVEL_ID ,

Line 436: FROM fnd_profile_option_values valar

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
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

Line 441: FROM fnd_profile_option_values valzx

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
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: */

Line 449: INSERT INTO FND_PROFILE_OPTION_VALUES

445: */
446:
447: -- 10.
448:
449: INSERT INTO FND_PROFILE_OPTION_VALUES
450: (
451: APPLICATION_ID ,
452: PROFILE_OPTION_ID ,
453: LEVEL_ID ,

Line 477: FROM fnd_profile_option_values valar

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
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

Line 482: FROM fnd_profile_option_values valzx

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
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:

Line 489: INSERT INTO FND_PROFILE_OPTION_VALUES

485: AND fpozx.profile_option_name = 'ZX_TAXVDR_SERVICEIND');
486:
487: -- 11.
488:
489: INSERT INTO FND_PROFILE_OPTION_VALUES
490: (
491: APPLICATION_ID ,
492: PROFILE_OPTION_ID ,
493: LEVEL_ID ,

Line 517: FROM fnd_profile_option_values valar

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
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

Line 522: FROM fnd_profile_option_values valzx

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
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: