Fix Process Master Data Log Achsada Bae

BEGIN

    SELECT * FROM p_rcv_data_log ORDER BY rcv_data_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 75

    "{"id":554,"tenantId":10,"partnerId":264,"groupPartner":"C","typePartnerId":20,"dueDate":14,"currencyCode":"IDR","amountLimit":5.0E7,"flagCommision":"N","active":"Y","activeDateTime":"20150330120000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150330120000","updateUserId":100,"updateDateTime":"20170613152205","version":1}"

    SELECT * FROM m_partner_type WHERE partner_type_id = 554

    SELECT * FROM m_partner_type ORDER BY partner_type_id DESC LIMIT 10

    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 554

END

BEGIN

    SELECT * FROM p_rcv_data_log ORDER BY rcv_data_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 76

    "{"id":609,"tenantId":10,"partnerId":319,"groupPartner":"C","typePartnerId":20,"dueDate":14,"currencyCode":"IDR","amountLimit":5.0E7,"flagCommision":"N","active":"Y","activeDateTime":"20150330120000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150330120000","updateUserId":100,"updateDateTime":"20170613152635","version":1}"

    SELECT * FROM m_partner_type WHERE partner_type_id = 609

    SELECT * FROM m_partner_type ORDER BY partner_type_id DESC LIMIT 10

    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 609

END

BEGIN

    SELECT * FROM p_rcv_data_log ORDER BY rcv_data_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 77

    "{"id":630,"tenantId":10,"partnerId":340,"groupPartner":"C","typePartnerId":20,"dueDate":14,"currencyCode":"IDR","amountLimit":5.0E7,"flagCommision":"N","active":"Y","activeDateTime":"20150330120000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150330120000","updateUserId":100,"updateDateTime":"20170613152705","version":1}"

    SELECT * FROM m_partner_type WHERE partner_type_id = 630

    SELECT * FROM m_partner_type ORDER BY partner_type_id DESC LIMIT 10

    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 630

END

BEGIN

    SELECT * FROM p_rcv_data_log ORDER BY rcv_data_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 78



    "{"id":530,"tenantId":10,"partnerId":240,"groupPartner":"C","typePartnerId":20,"dueDate":30,"currencyCode":"IDR","amountLimit":5.0E7,"flagCommision":"N","active":"Y","activeDateTime":"20150330120000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150330120000","updateUserId":100,"updateDateTime":"20170613153013","version":1}"

    SELECT * FROM m_partner_type WHERE partner_type_id = 630

    SELECT * FROM m_partner_type ORDER BY partner_type_id DESC LIMIT 10

    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 530

END


BEGIN

    SELECT * FROM p_rcv_data_log ORDER BY rcv_data_log_id DESC LIMIT 10

    SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10



    SELECT * FROM m_partner_type WHERE partner_type_id = 630

    SELECT * FROM m_partner_type ORDER BY partner_type_id DESC LIMIT 10



BEGIN

    SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 93 AND flg_process = 'FAIL'

    "{"id":618,"tenantId":10,"partnerId":328,"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":"20170613163919","version":2}"

    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 530
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 536
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 552
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 558
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 583
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 585
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 590
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 595
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 616
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 628
    --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 624
    --UPDATE m_partner_type SET version=2 WHERE partner_type_id = 618

END