REM RMINC_create_locks_tables.sql

REM Copyright 2000, All Rights Reserved, Reed-Matthews, Inc.

drop table RMINC.RMINC_lock_ref;
create table RMINC.RMINC_lock_ref
(LOCK_PROCESS                             NUMBER,
 LOCK_PROCESS_GRANDPA                     NUMBER);

drop table RMINC.RMINC_past_locks;
create table RMINC.RMINC_past_locks
(proc1         varchar2(9),
 user1         varchar2(15),
 proc2         varchar2(9),
 user2         varchar2(15),
 time          date,
 object_id     number);

REM GUESS WHAT!  fnd_concurrent_requests' layout
REM is different in Version 10.7 than it was in Version 10.4.2
drop table RMINC.RMINC_fcr_locktracker;
create table RMINC.RMINC_fcr_locktracker
as select * from applsys.fnd_concurrent_requests;
truncate table RMINC.RMINC_fcr_locktracker;