-
Notifications
You must be signed in to change notification settings - Fork 0
/
dmn_TASK_STATUS.sql
41 lines (39 loc) · 4.12 KB
/
dmn_TASK_STATUS.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
--prompt PL/SQL Developer Export Tables for user IGE@MTB_LITSUP
--prompt Created by slee5 on June 5, 2019
--set feedback off
--set define off
--prompt Truncating DMN_TASK_STATUS...
truncate table DMN_TASK_STATUS;
--prompt Loading DMN_TASK_STATUS...
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('COMPLETE FAILED', 'Complete failed', 12, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('HOLD', 'Hold', 11, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('READY', 'Ready', 1, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('TAKEN', 'Taken', 2, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('WORK STARTED', 'Work started', 3, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('WORK STOPPED', 'Work stopped', 4, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
values ('WORK STOPPED', 'Work stopped', 4, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('POSTING', 'Posting', 5, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('POST FAILED', 'Post failed', 6, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('POSTED', 'Posted', 7, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('COMPLETED', 'Completed', 8, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('CREATED', 'Created', 9, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('ABORTED', 'Aborted', 10, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_TASK_STATUS (task_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('POST SYSERR', 'System error. Admin group has been notified', 13, to_timestamp('24-06-2008 14:00:13', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
--commit;
--prompt 13 records loaded
--set feedback on
--set define on
--prompt Done