-- ABS-29177

---TRANSACTIONTYPE table---
insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1000,'Check-in new items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1001,'Check-in used items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1005,'Correct checked-in new items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1006,'Correct checked-in used items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1010,'Make checked-in new items unique',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1011,'Make checked-in used items unique',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1015,'Undo make checked-in new items unique',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1016,'Undo make checked-in used items unique',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1020,'Put away checked-in new items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1021,'Put away checked-in used items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1025,'Issue WO from checked-in new items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype (transactiontype_id, factorydescription, systemuser_id, timestamp, legacytransactioncode)
values (1026,'Issue WO from checked-in used items',getminsystemuser(),sysdate,null);
commit;

insert into transactiontype_desc
  (transactiontype_id, language_id, description, systemuser_id, timestamp)
  select transactiontype_id,
         getminlanguage(),
         factorydescription,
         systemuser_id,
         timestamp
    from transactiontype
   where transactiontype.transactiontype_id in (1000, 1001, 1005, 1006, 1010, 1011, 1015, 1016, 1020, 1021, 1025, 1026);
commit;