APPS.EGO_ITEM_USERATTRS_PUB dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 30: delete from EGO_MTL_SY_ITEMS_EXT_TL T

26: /* Solving Perf. Bug 4191046 */
27: /* The following delete and update statements are commented out */
28: /* as a quick workaround to fix the time-consuming table handler issue */
29: /*
30: delete from EGO_MTL_SY_ITEMS_EXT_TL T
31: where not exists
32: (select NULL
33: from EGO_MTL_SY_ITEMS_EXT_B B
34: where B.EXTENSION_ID = T.EXTENSION_ID

Line 37: update EGO_MTL_SY_ITEMS_EXT_TL T set (

33: from EGO_MTL_SY_ITEMS_EXT_B B
34: where B.EXTENSION_ID = T.EXTENSION_ID
35: );
36:
37: update EGO_MTL_SY_ITEMS_EXT_TL T set (
38: TL_EXT_ATTR1,
39: TL_EXT_ATTR2,
40: TL_EXT_ATTR3,
41: TL_EXT_ATTR4,

Line 120: from EGO_MTL_SY_ITEMS_EXT_TL B

116: B.TL_EXT_ATTR37,
117: B.TL_EXT_ATTR38,
118: B.TL_EXT_ATTR39,
119: B.TL_EXT_ATTR40
120: from EGO_MTL_SY_ITEMS_EXT_TL B
121: where B.EXTENSION_ID = T.EXTENSION_ID
122: and B.LANGUAGE = T.SOURCE_LANG)
123: where (
124: T.EXTENSION_ID,

Line 129: from EGO_MTL_SY_ITEMS_EXT_TL SUBB, EGO_MTL_SY_ITEMS_EXT_TL SUBT

125: T.LANGUAGE
126: ) in (select
127: SUBT.EXTENSION_ID,
128: SUBT.LANGUAGE
129: from EGO_MTL_SY_ITEMS_EXT_TL SUBB, EGO_MTL_SY_ITEMS_EXT_TL SUBT
130: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
131: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
132: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
133: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 264: SELECT Count(1) into l_rec_count FROM ego_mtl_sy_items_ext_tl where language = p_language;

260: FETCH get_installed_languages INTO p_language;
261: EXIT WHEN get_installed_languages%NOTFOUND;
262:
263:
264: SELECT Count(1) into l_rec_count FROM ego_mtl_sy_items_ext_tl where language = p_language;
265:
266: IF (l_rec_count = 0) THEN
267:
268: insert into EGO_MTL_SY_ITEMS_EXT_TL (

Line 268: insert into EGO_MTL_SY_ITEMS_EXT_TL (

264: SELECT Count(1) into l_rec_count FROM ego_mtl_sy_items_ext_tl where language = p_language;
265:
266: IF (l_rec_count = 0) THEN
267:
268: insert into EGO_MTL_SY_ITEMS_EXT_TL (
269: TL_EXT_ATTR23,
270: TL_EXT_ATTR24,
271: TL_EXT_ATTR25,
272: TL_EXT_ATTR26,

Line 378: from EGO_MTL_SY_ITEMS_EXT_TL B

374: B.TL_EXT_ATTR21,
375: B.TL_EXT_ATTR22,
376: p_language,
377: B.SOURCE_LANG
378: from EGO_MTL_SY_ITEMS_EXT_TL B
379: where B.LANGUAGE = userenv('LANG');
380:
381: ELSIF (l_rec_count > 0) THEN
382:

Line 383: insert into EGO_MTL_SY_ITEMS_EXT_TL (

379: where B.LANGUAGE = userenv('LANG');
380:
381: ELSIF (l_rec_count > 0) THEN
382:
383: insert into EGO_MTL_SY_ITEMS_EXT_TL (
384: TL_EXT_ATTR23,
385: TL_EXT_ATTR24,
386: TL_EXT_ATTR25,
387: TL_EXT_ATTR26,

Line 493: from EGO_MTL_SY_ITEMS_EXT_TL B

489: B.TL_EXT_ATTR21,
490: B.TL_EXT_ATTR22,
491: p_language,
492: B.SOURCE_LANG
493: from EGO_MTL_SY_ITEMS_EXT_TL B
494: where B.LANGUAGE = userenv('LANG')
495: and not exists
496: (select NULL
497: from EGO_MTL_SY_ITEMS_EXT_TL T

Line 497: from EGO_MTL_SY_ITEMS_EXT_TL T

493: from EGO_MTL_SY_ITEMS_EXT_TL B
494: where B.LANGUAGE = userenv('LANG')
495: and not exists
496: (select NULL
497: from EGO_MTL_SY_ITEMS_EXT_TL T
498: where T.EXTENSION_ID = B.EXTENSION_ID
499: and T.LANGUAGE = p_language);
500:
501: END IF;