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.ENG_REVISED_ITEMS_PKG dependencies on MTL_ITEM_REVISIONS

Line 66: delete from MTL_ITEM_REVISIONS_TL

62: x_change_notice VARCHAR2)
63: IS
64: BEGIN
65:
66: delete from MTL_ITEM_REVISIONS_TL
67: where revision_id IN (SELECT revision_id
68: FROM MTL_ITEM_REVISIONS_B
69: WHERE organization_id = x_organization_id
70: and inventory_item_id = x_revised_item_id

Line 68: FROM MTL_ITEM_REVISIONS_B

64: BEGIN
65:
66: delete from MTL_ITEM_REVISIONS_TL
67: where revision_id IN (SELECT revision_id
68: FROM MTL_ITEM_REVISIONS_B
69: WHERE organization_id = x_organization_id
70: and inventory_item_id = x_revised_item_id
71: and revised_item_sequence_Id = x_revised_item_sequence_id
72: and change_notice = x_change_notice

Line 75: delete from MTL_ITEM_REVISIONS_B

71: and revised_item_sequence_Id = x_revised_item_sequence_id
72: and change_notice = x_change_notice
73: and implementation_date is null);
74:
75: delete from MTL_ITEM_REVISIONS_B
76: where organization_id = x_organization_id
77: and inventory_item_id = x_revised_item_id
78: and revised_item_sequence_Id = x_revised_item_sequence_id
79: and change_notice = x_change_notice

Line 306: entity_name = 'MTL_ITEM_REVISIONS' and

302: from eng_engineering_changes
303: where change_notice = x_change_notice
304: and organization_id = x_organization_id) and --change_id is required for index
305: revised_item_sequence_id = x_revised_item_sequence_id and
306: entity_name = 'MTL_ITEM_REVISIONS' and
307: pk3_value IN (select revision_id
308: from MTL_ITEM_REVISIONS_B
309: where organization_id = x_organization_id
310: and inventory_item_id = x_inventory_item_id

Line 308: from MTL_ITEM_REVISIONS_B

304: and organization_id = x_organization_id) and --change_id is required for index
305: revised_item_sequence_id = x_revised_item_sequence_id and
306: entity_name = 'MTL_ITEM_REVISIONS' and
307: pk3_value IN (select revision_id
308: from MTL_ITEM_REVISIONS_B
309: where organization_id = x_organization_id
310: and inventory_item_id = x_inventory_item_id
311: and revised_item_sequence_Id = x_revised_item_sequence_id
312: and change_notice = x_change_notice

Line 317: delete from MTL_ITEM_REVISIONS_TL

313: and implementation_date is null);
314:
315:
316:
317: delete from MTL_ITEM_REVISIONS_TL
318: where revision_id IN (select revision_id
319: from MTL_ITEM_REVISIONS_B
320: where organization_id = x_organization_id
321: and inventory_item_id = x_inventory_item_id

Line 319: from MTL_ITEM_REVISIONS_B

315:
316:
317: delete from MTL_ITEM_REVISIONS_TL
318: where revision_id IN (select revision_id
319: from MTL_ITEM_REVISIONS_B
320: where organization_id = x_organization_id
321: and inventory_item_id = x_inventory_item_id
322: and revised_item_sequence_Id = x_revised_item_sequence_id
323: and change_notice = x_change_notice

Line 326: delete from MTL_ITEM_REVISIONS_B

322: and revised_item_sequence_Id = x_revised_item_sequence_id
323: and change_notice = x_change_notice
324: and implementation_date is null);
325:
326: delete from MTL_ITEM_REVISIONS_B
327: where organization_id = x_organization_id
328: and inventory_item_id =x_inventory_item_id
329: and revised_item_sequence_Id = x_revised_item_sequence_id
330: and change_notice = x_change_notice

Line 391: insert into MTL_ITEM_REVISIONS_B (

387:
388:
389: BEGIN
390: IF (Bom_globals.Get_Caller_Type <> BOM_GLOBALS.G_MASS_CHANGE) THEN -- added for bug 3534567
391: insert into MTL_ITEM_REVISIONS_B (
392: inventory_item_id,
393: organization_id,
394: revision,
395: revision_label,

Line 425: mtl_item_revisions_b_s.NEXTVAL,

421: x_change_notice,
422: sysdate,
423: decode(x_scheduled_date, trunc(sysdate), sysdate, x_scheduled_date),
424: x_revised_item_sequence_id,
425: mtl_item_revisions_b_s.NEXTVAL,
426: 1,
427: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description),
428: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)
429: )RETURNING revision_id INTO l_revision_id;

Line 432: -- description is stored in MTL_ITEM_REVISIONS_TL

428: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)
429: )RETURNING revision_id INTO l_revision_id;
430:
431: SELECT userenv('LANG') INTO l_language_code FROM dual;
432: -- description is stored in MTL_ITEM_REVISIONS_TL
433: insert into MTL_ITEM_REVISIONS_TL (
434: inventory_item_id,
435: organization_id,
436: revision_id,

Line 433: insert into MTL_ITEM_REVISIONS_TL (

429: )RETURNING revision_id INTO l_revision_id;
430:
431: SELECT userenv('LANG') INTO l_language_code FROM dual;
432: -- description is stored in MTL_ITEM_REVISIONS_TL
433: insert into MTL_ITEM_REVISIONS_TL (
434: inventory_item_id,
435: organization_id,
436: revision_id,
437: language,

Line 461: from MTL_ITEM_REVISIONS_TL T

457: FROM FND_LANGUAGES lang
458: where lang.INSTALLED_FLAG in ('I', 'B')
459: and not exists
460: (select NULL
461: from MTL_ITEM_REVISIONS_TL T
462: where T.INVENTORY_ITEM_ID = x_inventory_item_id
463: and T.ORGANIZATION_ID = x_organization_id
464: and T.REVISION_ID = l_revision_id
465: and T.LANGUAGE = lang.LANGUAGE_CODE);

Line 546: update MTL_ITEM_REVISIONS_B

542: l_login_id NUMBER := FND_GLOBAL.Login_Id;
543:
544: BEGIN
545:
546: update MTL_ITEM_REVISIONS_B
547: set revision = x_revision,
548: revision_label = x_revision, -- Bug No:3612330 added by sseraphi to update rev label along with rev code.
549: effectivity_date = decode(x_scheduled_date, trunc(sysdate), sysdate, x_scheduled_date),
550: last_update_date = SYSDATE,

Line 561: update MTL_ITEM_REVISIONS_TL

557: RETURNING revision_id INTO l_revision_id;
558:
559: SELECT userenv('LANG') INTO l_language_code FROM dual;
560:
561: update MTL_ITEM_REVISIONS_TL
562: set
563: last_update_date = SYSDATE, --who column
564: last_update_login = l_login_id, --who column
565: last_updated_by = l_user_id, --who column

Line 650: * mtl_item_revisions_b/_tl table with the value passed as parameter

646: * API Name : UPDATE_REVISION_CHANGE_NOTICE
647: * Parameters IN : p_revision_id, p_change_notice
648: * Parameters OUT: None
649: * Purpose : Updates the value of change_notice in the
650: * mtl_item_revisions_b/_tl table with the value passed as parameter
651: * for the row specified.
652: *********************************************************************/
653: PROCEDURE UPDATE_REVISION_CHANGE_NOTICE ( p_revision_id IN NUMBER
654: , p_change_notice IN VARCHAR2

Line 662: UPDATE MTL_ITEM_REVISIONS_B

658: l_user_id NUMBER := FND_GLOBAL.User_Id;
659: l_login_id NUMBER := FND_GLOBAL.Login_Id;
660: BEGIN
661:
662: UPDATE MTL_ITEM_REVISIONS_B
663: SET change_notice = p_change_notice,
664: last_update_date = SYSDATE,
665: last_update_login = l_login_id,
666: last_updated_by = l_user_id

Line 673: UPDATE MTL_ITEM_REVISIONS_TL

669: SELECT userenv('LANG')
670: INTO l_language_code
671: FROM dual;
672:
673: UPDATE MTL_ITEM_REVISIONS_TL
674: SET last_update_date = SYSDATE, --who column
675: last_update_login = l_login_id, --who column
676: last_updated_by = l_user_id, --who column
677: source_lang = l_language_code

Line 700: FROM mtl_item_revisions

696: )
697: IS
698: CURSOR c_check_revision_id IS
699: SELECT 1
700: FROM mtl_item_revisions
701: WHERE revision_id = p_revision_id
702: AND inventory_item_id = p_revised_item_id
703: AND organization_id = p_organization_id;
704: