Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE awe_worklist SET flg_to_do = 'N' WHERE doc_id = 4462 AND scheme = 'GD01' AND doc_no = 'FUCAS/00001/KPS/201706'
- UPDATE awe_currdoc_status SET current_state = 'DELETED' WHERE doc_id = 4462 AND scheme = 'GD01' AND doc_no = 'FUCAS/00001/KPS/201706'
- INSERT INTO awe_historydoc (
- tenant_id, req_id, doc_id,
- scheme, user_id, role_id,
- activity, previous_state, next_state,
- remark, next_user_id, next_role_id,
- flg_user_role, activity_datetime, version)
- VALUES (10, '75b900bc-4234-4415-b7c6-bb99177ada6d', 4462,
- 'GD01', 113, 17,
- 'DELETE', 'DRAFT', 'DELETED',
- 'HAPUS ATAS PERMINTAAN USER (KPS-484, KPS-559)', -99, -99,
- 'U', '20171113140359', 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement