DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_ITEM_REVISIONS_B

Line 7070: FROM mtl_item_revisions_b

7066:
7067: DECLARE
7068: CURSOR c_lock_rev_record IS
7069: SELECT ROWID,current_phase_id
7070: FROM mtl_item_revisions_b
7071: WHERE revision_id = rev_rec.revision_id
7072: FOR UPDATE of revision_id;
7073:
7074: resource_busy EXCEPTION;

Line 7124: UPDATE MTL_ITEM_REVISIONS_B

7120:
7121:
7122: -- bug 10373720, set last_update_date to sysdate instead of picking
7123: -- from interface
7124: UPDATE MTL_ITEM_REVISIONS_B
7125: SET
7126: DESCRIPTION = decode(l_INSTALLED_FLAG, 'B', rev_rec.DESCRIPTION, DESCRIPTION),
7127: CHANGE_NOTICE = rev_rec.CHANGE_NOTICE,
7128: ECN_INITIATION_DATE = rev_rec.ECN_INITIATION_DATE,