APPS.MTL_ITEM_REVISIONS_UTIL dependencies on MTL_ITEM_REVISIONS_TL

Line 149: INSERT INTO MTL_ITEM_REVISIONS_TL (

145: P_Item_Revision_Rec.LAST_UPDATED_BY,
146: P_Item_Revision_Rec.LAST_UPDATE_LOGIN
147: ) RETURNING ROWID INTO X_ROWID;
148:
149: INSERT INTO MTL_ITEM_REVISIONS_TL (
150: INVENTORY_ITEM_ID,
151: ORGANIZATION_ID,
152: REVISION_ID,
153: DESCRIPTION,

Line 175: FROM MTL_ITEM_REVISIONS_TL T

171: USERENV('LANG')
172: FROM FND_LANGUAGES L
173: WHERE L.INSTALLED_FLAG in ('I', 'B')
174: AND NOT EXISTS (SELECT NULL
175: FROM MTL_ITEM_REVISIONS_TL T
176: WHERE T.INVENTORY_ITEM_ID = P_Item_Revision_Rec.INVENTORY_ITEM_ID
177: AND T.ORGANIZATION_ID = P_Item_Revision_Rec.ORGANIZATION_ID
178: AND T.REVISION_ID = P_Item_Revision_Rec.REVISION_ID
179: AND T.LANGUAGE = L.LANGUAGE_CODE);

Line 246: FROM MTL_ITEM_REVISIONS_TL

242: CURSOR c_get_revision_desc IS
243: SELECT
244: DESCRIPTION,
245: DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
246: FROM MTL_ITEM_REVISIONS_TL
247: WHERE INVENTORY_ITEM_ID = P_Item_Revision_Rec.INVENTORY_ITEM_ID
248: AND ORGANIZATION_ID = P_Item_Revision_Rec.ORGANIZATION_ID
249: AND REVISION_ID = P_Item_Revision_Rec.REVISION_ID
250: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)

Line 378: UPDATE MTL_ITEM_REVISIONS_TL set

374: IF (SQL%NOTFOUND) THEN
375: RAISE NO_DATA_FOUND;
376: END IF;
377:
378: UPDATE MTL_ITEM_REVISIONS_TL set
379: DESCRIPTION = P_Item_Revision_Rec.DESCRIPTION,
380: LAST_UPDATE_DATE = P_Item_Revision_Rec.LAST_UPDATE_DATE,
381: LAST_UPDATED_BY = P_Item_Revision_Rec.LAST_UPDATED_BY,
382: LAST_UPDATE_LOGIN = P_Item_Revision_Rec.LAST_UPDATE_LOGIN,

Line 414: /* DELETE FROM MTL_ITEM_REVISIONS_TL T

410: BEGIN
411:
412: -- Comment out as part of SQL Repositry fix. Bug: 4256727
413:
414: /* DELETE FROM MTL_ITEM_REVISIONS_TL T
415: WHERE NOT EXISTS(SELECT NULL
416: FROM MTL_ITEM_REVISIONS_B B
417: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
418: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID

Line 421: UPDATE MTL_ITEM_REVISIONS_TL T

417: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
418: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
419: AND B.REVISION_ID = T.REVISION_ID);
420:
421: UPDATE MTL_ITEM_REVISIONS_TL T
422: SET (DESCRIPTION) = (SELECT B.DESCRIPTION
423: FROM MTL_ITEM_REVISIONS_TL B
424: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
425: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID

Line 423: FROM MTL_ITEM_REVISIONS_TL B

419: AND B.REVISION_ID = T.REVISION_ID);
420:
421: UPDATE MTL_ITEM_REVISIONS_TL T
422: SET (DESCRIPTION) = (SELECT B.DESCRIPTION
423: FROM MTL_ITEM_REVISIONS_TL B
424: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
425: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
426: AND B.REVISION_ID = T.REVISION_ID
427: AND B.LANGUAGE = T.SOURCE_LANG)

Line 435: FROM MTL_ITEM_REVISIONS_TL SUBB,

431: T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
432: SUBT.ORGANIZATION_ID,
433: SUBT.REVISION_ID,
434: SUBT.LANGUAGE
435: FROM MTL_ITEM_REVISIONS_TL SUBB,
436: MTL_ITEM_REVISIONS_TL SUBT
437: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
438: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
439: AND SUBB.REVISION_ID = SUBT.REVISION_ID

Line 436: MTL_ITEM_REVISIONS_TL SUBT

432: SUBT.ORGANIZATION_ID,
433: SUBT.REVISION_ID,
434: SUBT.LANGUAGE
435: FROM MTL_ITEM_REVISIONS_TL SUBB,
436: MTL_ITEM_REVISIONS_TL SUBT
437: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
438: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
439: AND SUBB.REVISION_ID = SUBT.REVISION_ID
440: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 445: INSERT INTO MTL_ITEM_REVISIONS_TL (

441: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
442: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
443: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)));
444: */
445: INSERT INTO MTL_ITEM_REVISIONS_TL (
446: INVENTORY_ITEM_ID,
447: ORGANIZATION_ID,
448: REVISION_ID,
449: DESCRIPTION,

Line 468: FROM MTL_ITEM_REVISIONS_TL B,

464: B.LAST_UPDATED_BY,
465: B.LAST_UPDATE_LOGIN,
466: L.LANGUAGE_CODE,
467: B.SOURCE_LANG
468: FROM MTL_ITEM_REVISIONS_TL B,
469: FND_LANGUAGES L
470: WHERE L.INSTALLED_FLAG IN ('I', 'B')
471: AND B.LANGUAGE = USERENV('LANG')
472: AND NOT EXISTS (SELECT NULL

Line 473: FROM MTL_ITEM_REVISIONS_TL T

469: FND_LANGUAGES L
470: WHERE L.INSTALLED_FLAG IN ('I', 'B')
471: AND B.LANGUAGE = USERENV('LANG')
472: AND NOT EXISTS (SELECT NULL
473: FROM MTL_ITEM_REVISIONS_TL T
474: WHERE T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
475: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
476: AND T.REVISION_ID = B.REVISION_ID
477: AND T.LANGUAGE = L.LANGUAGE_CODE);