1
|
USER_ALIAS APPROVER_GROUP
|
2
|
approverRahman 1
|
3
|
tibokcuie 1
|
4
|
sarmsApp 1
|
5
|
bulkapp 1
|
6
|
approvererni 1
|
7
|
approverAE 1
|
8
|
apporvertest01 1
|
9
|
approvertest02 1
|
10
|
approvertest3 1
|
11
|
Approvertest01 1
|
12
|
approvertest03 1
|
13
|
approverserv01 1
|
14
|
approvertest2 1
|
15
|
approverrevoke 1
|
16
|
apptest01 1
|
17
|
approvertsit 1
|
18
|
rahmanco2 2
|
19
|
rahmanco4 3
|
20
|
appRahman 4
|
21
|
approvererniyin 4
|
22
|
approverernimc 5
|
23
|
sarmsInit1 5
|
24
|
apperni 5
|
25
|
|
26
|
|
27
|
|
28
|
Initiate
|
29
|
|
30
|
select top 30 * from SMS_TABLE order by OID desc;
|
31
|
select USER_ID, USER_ALIAS, APPROVER_GROUP, role from BIB_USER where USER_ALIAS in (select SMS_CUST_NAME from SMS_TABLE where OID > 5348)
|
32
|
|
33
|
OID SMS_CREATESTAMP SMS_IBREF_NO SMS_IC_NO SMS_CUST_NAME SMS_HP_NO SMS_MESSAGE SMS_SERVICE SMS_STATUS CREATION_DATE SMS_GUID SMS_SDDATESTAMP SMS_RCDATESTAMP SMS_CHECK SMS_PRIORITY SMS_TYPE STATUS REFERENCE REMOTE_IP OTHER1 OTHER2 AMOUNT IB_SERVICE SMS_PROVIDER
|
34
|
5364 2017-02-23 15:11:03.667 20170223000000002796 NULL approvertsit 018555555111 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
35
|
5363 2017-02-23 15:11:03.667 20170223000000002795 NULL apptest01 222222222222 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
36
|
5362 2017-02-23 15:11:03.663 20170223000000002794 NULL approverrevoke 000000000000 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
37
|
5361 2017-02-23 15:11:03.660 20170223000000002793 NULL approvertest2 017629926666 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
38
|
5360 2017-02-23 15:11:03.657 20170223000000002792 NULL approverserv01 019828272666 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
39
|
5359 2017-02-23 15:11:03.653 20170223000000002791 NULL approvertest03 021918181919 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
40
|
5358 2017-02-23 15:11:03.650 20170223000000002790 NULL Approvertest01 919191919272 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
41
|
5357 2017-02-23 15:11:03.647 20170223000000002789 NULL approvertest3 000000000000 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
42
|
5356 2017-02-23 15:11:03.647 20170223000000002788 NULL approvertest02 000000000000 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
43
|
5355 2017-02-23 15:11:03.643 20170223000000002787 NULL apporvertest01 999999999999 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
44
|
5354 2017-02-23 15:11:03.640 20170223000000002786 NULL approverAE 111111111111 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
45
|
5353 2017-02-23 15:11:03.637 20170223000000002785 NULL approvererni 012839391923 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
46
|
5352 2017-02-23 15:11:03.633 20170223000000002784 NULL bulkapp 111111111111 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
47
|
5351 2017-02-23 15:11:03.630 20170223000000002783 NULL sarmsApp 111111111111 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
48
|
5350 2017-02-23 15:11:03.627 20170223000000002782 NULL tibokcuie 60169011938 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
49
|
5349 2017-02-23 15:11:03.627 20170223000000002781 NULL approverRahman 60182046490 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:11:03. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
50
|
|
51
|
|
52
|
USER_ID USER_ALIAS APPROVER_GROUP role
|
53
|
391 approverRahman 1 3
|
54
|
434 tibokcuie 1 3
|
55
|
462 sarmsApp 1 3
|
56
|
485 bulkapp 1 3
|
57
|
492 approvererni 1 3
|
58
|
501 approverAE 1 3
|
59
|
505 apporvertest01 1 3
|
60
|
506 approvertest02 1 3
|
61
|
507 approvertest3 1 3
|
62
|
510 Approvertest01 1 3
|
63
|
511 approvertest03 1 3
|
64
|
514 approverserv01 1 3
|
65
|
515 approvertest2 1 3
|
66
|
519 approverrevoke 1 3
|
67
|
524 apptest01 1 3
|
68
|
525 approvertsit 1 3
|
69
|
|
70
|
|
71
|
|
72
|
After group A approved
|
73
|
OID SMS_CREATESTAMP SMS_IBREF_NO SMS_IC_NO SMS_CUST_NAME SMS_HP_NO SMS_MESSAGE SMS_SERVICE SMS_STATUS CREATION_DATE SMS_GUID SMS_SDDATESTAMP SMS_RCDATESTAMP SMS_CHECK SMS_PRIORITY SMS_TYPE STATUS REFERENCE REMOTE_IP OTHER1 OTHER2 AMOUNT IB_SERVICE SMS_PROVIDER
|
74
|
5365 2017-02-23 15:18:23.247 20170223000000002797 NULL rahmanco2 60182046490 AGRONet Biz: Bulk Trf - 1002021000022870 2.00 Pending Approval on 23 Feb 2017 15:18:23. Call 1 300 88 2476 for inquiries. TQ. Notification 1 2017-02-23 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2.000000 NULL NULL
|
75
|
|
76
|
USER_ID USER_ALIAS APPROVER_GROUP role
|
77
|
280 rahmanco2 2 3
|
78
|
|
79
|
|
80
|
|
81
|
|