Advertisement
aadddrr

Fix Update Master Data Log Setiawan Bae

Jul 26th, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN
  2.  
  3.     SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10
  4.  
  5.     SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 42 AND flg_process = 'FAIL'
  6.  
  7.     "{"id":553,"tenantId":10,"partnerId":263,"groupPartner":"C","typePartnerId":20,"dueDate":30,"currencyCode":"IDR","amountLimit":5.0E7,"flagCommision":"N","active":"Y","activeDateTime":"20150330120000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150330120000","updateUserId":103,"updateDateTime":"20170613155442","version":1}"
  8.  
  9.  
  10.  
  11.     --UPDATE m_partner_type SET version=2 WHERE partner_type_id = 613
  12.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 510
  13.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 554
  14.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 553
  15.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 609
  16.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 630
  17.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 530
  18.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 536
  19.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 552
  20.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 558
  21.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 583
  22.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 585
  23.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 590
  24.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 595
  25.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 616
  26.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 628
  27.     --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 624
  28.     --UPDATE m_partner_type SET version=2 WHERE partner_type_id = 618
  29.  
  30. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement