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_MIGR_AR_TAX_GROUP_LOOKUPS dependencies on FND_LOOKUP_TYPES

Line 92: UPDATE FND_LOOKUP_TYPES

88: IF PG_DEBUG = 'Y' THEN
89: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(+)');
90: END IF;
91:
92: UPDATE FND_LOOKUP_TYPES
93: SET CUSTOMIZATION_LEVEL = 'S'
94: WHERE lookup_type in (
95: 'TAX_CONDITION_TYPE',
96: 'TAX_CONDITION_OPERATOR',

Line 154: arp_util_tax.debug('creating FND_LOOKUP_TYPES....');

150: arp_util_tax.debug('Create_Lookups(+)');
151: END IF;
152:
153: IF PG_DEBUG = 'Y' THEN
154: arp_util_tax.debug('creating FND_LOOKUP_TYPES....');
155: END IF;
156:
157: INSERT ALL
158: WHEN (NOT EXISTS

Line 159: (SELECT 1 FROM FND_LOOKUP_TYPES

155: END IF;
156:
157: INSERT ALL
158: WHEN (NOT EXISTS
159: (SELECT 1 FROM FND_LOOKUP_TYPES
160: WHERE LOOKUP_TYPE = 'ZX_CONDITION_TYPE'
161: AND APPLICATION_ID = 235)
162: ) THEN
163: INTO FND_LOOKUP_TYPES

Line 163: INTO FND_LOOKUP_TYPES

159: (SELECT 1 FROM FND_LOOKUP_TYPES
160: WHERE LOOKUP_TYPE = 'ZX_CONDITION_TYPE'
161: AND APPLICATION_ID = 235)
162: ) THEN
163: INTO FND_LOOKUP_TYPES
164: (
165: APPLICATION_ID ,
166: LOOKUP_TYPE ,
167: CUSTOMIZATION_LEVEL ,

Line 190: (SELECT 1 FROM FND_LOOKUP_TYPES

186: fnd_global.user_id ,
187: fnd_global.conc_login_id
188: )
189: WHEN (NOT EXISTS
190: (SELECT 1 FROM FND_LOOKUP_TYPES
191: WHERE LOOKUP_TYPE = 'ZX_CONDITION_OPERATOR'
192: AND APPLICATION_ID = 235)
193: ) THEN
194: INTO FND_LOOKUP_TYPES

Line 194: INTO FND_LOOKUP_TYPES

190: (SELECT 1 FROM FND_LOOKUP_TYPES
191: WHERE LOOKUP_TYPE = 'ZX_CONDITION_OPERATOR'
192: AND APPLICATION_ID = 235)
193: ) THEN
194: INTO FND_LOOKUP_TYPES
195: (
196: APPLICATION_ID ,
197: LOOKUP_TYPE ,
198: CUSTOMIZATION_LEVEL ,

Line 221: (SELECT 1 FROM FND_LOOKUP_TYPES

217: fnd_global.user_id ,
218: fnd_global.conc_login_id
219: )
220: WHEN (NOT EXISTS
221: (SELECT 1 FROM FND_LOOKUP_TYPES
222: WHERE LOOKUP_TYPE = 'ZX_CONDITION_FIELD'
223: AND APPLICATION_ID = 235)
224: ) THEN
225: INTO FND_LOOKUP_TYPES

Line 225: INTO FND_LOOKUP_TYPES

221: (SELECT 1 FROM FND_LOOKUP_TYPES
222: WHERE LOOKUP_TYPE = 'ZX_CONDITION_FIELD'
223: AND APPLICATION_ID = 235)
224: ) THEN
225: INTO FND_LOOKUP_TYPES
226: (
227: APPLICATION_ID ,
228: LOOKUP_TYPE ,
229: CUSTOMIZATION_LEVEL ,

Line 252: (SELECT 1 FROM FND_LOOKUP_TYPES

248: fnd_global.user_id ,
249: fnd_global.conc_login_id
250: )
251: WHEN (NOT EXISTS
252: (SELECT 1 FROM FND_LOOKUP_TYPES
253: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ENTITY'
254: AND APPLICATION_ID = 235)
255: ) THEN
256: INTO FND_LOOKUP_TYPES

Line 256: INTO FND_LOOKUP_TYPES

252: (SELECT 1 FROM FND_LOOKUP_TYPES
253: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ENTITY'
254: AND APPLICATION_ID = 235)
255: ) THEN
256: INTO FND_LOOKUP_TYPES
257: (
258: APPLICATION_ID ,
259: LOOKUP_TYPE ,
260: CUSTOMIZATION_LEVEL ,

Line 283: (SELECT 1 FROM FND_LOOKUP_TYPES

279: fnd_global.user_id ,
280: fnd_global.conc_login_id
281: )
282: WHEN (NOT EXISTS
283: (SELECT 1 FROM FND_LOOKUP_TYPES
284: WHERE LOOKUP_TYPE = 'ZX_CONDITION_CLAUSE'
285: AND APPLICATION_ID = 235)
286: ) THEN
287: INTO FND_LOOKUP_TYPES

Line 287: INTO FND_LOOKUP_TYPES

283: (SELECT 1 FROM FND_LOOKUP_TYPES
284: WHERE LOOKUP_TYPE = 'ZX_CONDITION_CLAUSE'
285: AND APPLICATION_ID = 235)
286: ) THEN
287: INTO FND_LOOKUP_TYPES
288: (
289: APPLICATION_ID ,
290: LOOKUP_TYPE ,
291: CUSTOMIZATION_LEVEL ,

Line 314: (SELECT 1 FROM FND_LOOKUP_TYPES

310: fnd_global.user_id ,
311: fnd_global.conc_login_id
312: )
313: WHEN (NOT EXISTS
314: (SELECT 1 FROM FND_LOOKUP_TYPES
315: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_TYPE'
316: AND APPLICATION_ID = 235)
317: ) THEN
318: INTO FND_LOOKUP_TYPES

Line 318: INTO FND_LOOKUP_TYPES

314: (SELECT 1 FROM FND_LOOKUP_TYPES
315: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_TYPE'
316: AND APPLICATION_ID = 235)
317: ) THEN
318: INTO FND_LOOKUP_TYPES
319: (
320: APPLICATION_ID ,
321: LOOKUP_TYPE ,
322: CUSTOMIZATION_LEVEL ,

Line 345: (SELECT 1 FROM FND_LOOKUP_TYPES

341: fnd_global.user_id ,
342: fnd_global.conc_login_id
343: )
344: WHEN (NOT EXISTS
345: (SELECT 1 FROM FND_LOOKUP_TYPES
346: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_CODE'
347: AND APPLICATION_ID = 235)
348: ) THEN
349: INTO FND_LOOKUP_TYPES

Line 349: INTO FND_LOOKUP_TYPES

345: (SELECT 1 FROM FND_LOOKUP_TYPES
346: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_CODE'
347: AND APPLICATION_ID = 235)
348: ) THEN
349: INTO FND_LOOKUP_TYPES
350: (
351: APPLICATION_ID ,
352: LOOKUP_TYPE ,
353: CUSTOMIZATION_LEVEL ,

Line 376: (SELECT 1 FROM FND_LOOKUP_TYPES

372: fnd_global.user_id ,
373: fnd_global.conc_login_id
374: )
375: WHEN (NOT EXISTS
376: (SELECT 1 FROM FND_LOOKUP_TYPES
377: WHERE LOOKUP_TYPE = 'ZX_CONDITION_VALUE'
378: AND APPLICATION_ID = 235)
379: ) THEN
380: INTO FND_LOOKUP_TYPES

Line 380: INTO FND_LOOKUP_TYPES

376: (SELECT 1 FROM FND_LOOKUP_TYPES
377: WHERE LOOKUP_TYPE = 'ZX_CONDITION_VALUE'
378: AND APPLICATION_ID = 235)
379: ) THEN
380: INTO FND_LOOKUP_TYPES
381: (
382: APPLICATION_ID ,
383: LOOKUP_TYPE ,
384: CUSTOMIZATION_LEVEL ,

Line 407: (SELECT 1 FROM FND_LOOKUP_TYPES

403: fnd_global.user_id ,
404: fnd_global.conc_login_id
405: )
406: WHEN (NOT EXISTS
407: (SELECT 1 FROM FND_LOOKUP_TYPES
408: WHERE LOOKUP_TYPE = 'ZX_TAX_CLASSIFICATION'
409: AND APPLICATION_ID = 235)
410: ) THEN
411: INTO FND_LOOKUP_TYPES

Line 411: INTO FND_LOOKUP_TYPES

407: (SELECT 1 FROM FND_LOOKUP_TYPES
408: WHERE LOOKUP_TYPE = 'ZX_TAX_CLASSIFICATION'
409: AND APPLICATION_ID = 235)
410: ) THEN
411: INTO FND_LOOKUP_TYPES
412: (
413: APPLICATION_ID ,
414: LOOKUP_TYPE ,
415: CUSTOMIZATION_LEVEL ,

Line 441: arp_util_tax.debug('creating records in FND_LOOKUP_TYPES_TL...');

437: SELECT 1 FROM DUAL;
438:
439:
440: IF PG_DEBUG = 'Y' THEN
441: arp_util_tax.debug('creating records in FND_LOOKUP_TYPES_TL...');
442: END IF;
443:
444: INSERT INTO FND_LOOKUP_TYPES_TL
445: (

Line 444: INSERT INTO FND_LOOKUP_TYPES_TL

440: IF PG_DEBUG = 'Y' THEN
441: arp_util_tax.debug('creating records in FND_LOOKUP_TYPES_TL...');
442: END IF;
443:
444: INSERT INTO FND_LOOKUP_TYPES_TL
445: (
446: LOOKUP_TYPE,
447: SECURITY_GROUP_ID,
448: VIEW_APPLICATION_ID,

Line 472: FROM FND_LOOKUP_TYPES types,

468: SYSDATE ,
469: fnd_global.user_id ,
470: SYSDATE ,
471: fnd_global.conc_login_id
472: FROM FND_LOOKUP_TYPES types,
473: FND_LANGUAGES L
474: WHERE L.INSTALLED_FLAG in ('I', 'B')
475: AND types.lookup_type in (
476: 'ZX_CONDITION_TYPE',

Line 487: from fnd_lookup_types_tl sub

483: 'ZX_CONDITION_VALUE',
484: 'ZX_TAX_CLASSIFICATION')
485: AND not exists
486: (select 1
487: from fnd_lookup_types_tl sub
488: where sub.lookup_type = types.lookup_type
489: and sub.security_group_id = 0
490: and sub.view_application_id = 0
491: and sub.language = l.language_code);