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_CANCEL_ECO dependencies on MTL_ITEM_REVISIONS_TL

Line 656: delete from MTL_ITEM_REVISIONS_TL

652: ** delete item revisions created by revised items on ECO
653: */
654: stmt_num := 60;
655:
656: delete from MTL_ITEM_REVISIONS_TL
657: where revision_id IN (select revision_id
658: from MTL_ITEM_REVISIONS_B I
659: WHERE CHANGE_NOTICE = change_order
660: AND ORGANIZATION_ID = org_id

Line 1028: delete from MTL_ITEM_REVISIONS_TL

1024: ** delete item revisions created by revised items on ECO
1025: */
1026: stmt_num := 50;
1027: -- Modified where clause for performance bug 4251776
1028: delete from MTL_ITEM_REVISIONS_TL
1029: WHERE revision_id IN (select new_item_revision_id
1030: from eng_revised_items I
1031: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1032: