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.

[Home] [Help]

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: AND NOT EXISTS (SELECT 1

Line 315: 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
317: FROM fnd_profile_options
318: WHERE profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
319: );

Line 325: INSERT INTO FND_PROFILE_OPTION_VALUES

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

Line 353: FROM fnd_profile_option_values valar

349: fnd_global.user_id, --CREATED_BY
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

Line 358: FROM fnd_profile_option_values valzx

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

Line 365: INSERT INTO FND_PROFILE_OPTION_VALUES

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

Line 393: FROM fnd_profile_option_values valar

389: fnd_global.user_id, --CREATED_BY
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

Line 398: FROM fnd_profile_option_values valzx

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

Line 406: INSERT INTO FND_PROFILE_OPTION_VALUES

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

Line 434: FROM fnd_profile_option_values valar

430: fnd_global.user_id, --CREATED_BY
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

Line 439: FROM fnd_profile_option_values valzx

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

Line 447: INSERT INTO FND_PROFILE_OPTION_VALUES

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

Line 475: FROM fnd_profile_option_values valar

471: fnd_global.user_id, --CREATED_BY
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

Line 480: FROM fnd_profile_option_values valzx

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

Line 487: INSERT INTO FND_PROFILE_OPTION_VALUES

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

Line 515: FROM fnd_profile_option_values valar

511: fnd_global.user_id, --CREATED_BY
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

Line 520: FROM fnd_profile_option_values valzx

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