Advertisement
aadddrr

UPDATE_AWE_FUCAS/00001/KPS/201706

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