USER_ALIAS APPROVER_GROUP approverRahman 1 tibokcuie 1 sarmsApp 1 bulkapp 1 approvererni 1 approverAE 1 apporvertest01 1 approvertest02 1 approvertest3 1 Approvertest01 1 approvertest03 1 approverserv01 1 approvertest2 1 approverrevoke 1 apptest01 1 approvertsit 1 rahmanco2 2 rahmanco4 3 appRahman 4 approvererniyin 4 approverernimc 5 sarmsInit1 5 apperni 5 Initiate select top 30 * from SMS_TABLE order by OID desc; 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) 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 USER_ID USER_ALIAS APPROVER_GROUP role 391 approverRahman 1 3 434 tibokcuie 1 3 462 sarmsApp 1 3 485 bulkapp 1 3 492 approvererni 1 3 501 approverAE 1 3 505 apporvertest01 1 3 506 approvertest02 1 3 507 approvertest3 1 3 510 Approvertest01 1 3 511 approvertest03 1 3 514 approverserv01 1 3 515 approvertest2 1 3 519 approverrevoke 1 3 524 apptest01 1 3 525 approvertsit 1 3 After group A approved 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 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 USER_ID USER_ALIAS APPROVER_GROUP role 280 rahmanco2 2 3