DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_ITEM_REVISIONS_B

Line 6636: FROM mtl_item_revisions_b

6632:
6633: DECLARE
6634: CURSOR c_lock_rev_record IS
6635: SELECT ROWID
6636: FROM mtl_item_revisions_b
6637: WHERE revision_id = rev_rec.revision_id
6638: FOR UPDATE of revision_id;
6639:
6640: resource_busy EXCEPTION;

Line 6651: UPDATE MTL_ITEM_REVISIONS_B

6647:
6648: FOR update_rec IN c_lock_rev_record LOOP
6649:
6650:
6651: UPDATE MTL_ITEM_REVISIONS_B
6652: SET
6653: DESCRIPTION = decode(l_INSTALLED_FLAG, 'B', rev_rec.DESCRIPTION, DESCRIPTION),
6654: CHANGE_NOTICE = rev_rec.CHANGE_NOTICE,
6655: ECN_INITIATION_DATE = rev_rec.ECN_INITIATION_DATE,