- Output for 8.3.0 - 8.3.30, 8.4.1 - 8.4.21, 8.5.0 - 8.5.7
- ```SQL
UPDATE rbs_customer_payment_details cd SET
cd.status_id = (SELECT cds.id FROM rbs_customer_payment_detail_statuses cds WHERE cds.status='rejected'),
cd.updated_at = now()
WHERE cd.id = 900845
INSERT INTO rbs_customer_payment_detail_activities
(customer_payment_detail_id, status_id, username, created_at, updated_at, reason)
VALUES (
900845,
(SELECT cds.id from rbs_customer_payment_detail_statuses cds where cds.status = 'rejected'),
'SYSTEM',
now(),
now(),
'Other: FUNDING-24509'
);
UPDATE rbs_customer_payment_details cd SET
cd.status_id = (SELECT cds.id FROM rbs_customer_payment_detail_statuses cds WHERE cds.status='rejected'),
cd.updated_at = now()
WHERE cd.id = 2381036
INSERT INTO rbs_customer_payment_detail_activities
(customer_payment_detail_id, status_id, username, created_at, updated_at, reason)
VALUES (
2381036,
(SELECT cds.id from rbs_customer_payment_detail_statuses cds where cds.status = 'rejected'),
'SYSTEM',
now(),
now(),
'Other: FUNDING-24509'
);
UPDATE rbs_customer_payment_details cd SET
cd.status_id = (SELECT cds.id FROM rbs_customer_payment_detail_statuses cds WHERE cds.status='rejected'),
cd.updated_at = now()
WHERE cd.id = 2636066
INSERT INTO rbs_customer_payment_detail_activities
(customer_payment_detail_id, status_id, username, created_at, updated_at, reason)
VALUES (
2636066,
(SELECT cds.id from rbs_customer_payment_detail_statuses cds where cds.status = 'rejected'),
'SYSTEM',
now(),
now(),
'Other: FUNDING-24509'
);
UPDATE rbs_customer_payment_details cd SET
cd.status_id = (SELECT cds.id FROM rbs_customer_payment_detail_statuses cds WHERE cds.status='rejected'),
cd.updated_at = now()
WHERE cd.id = 3879196
INSERT INTO rbs_customer_payment_detail_activities
(customer_payment_detail_id, status_id, username, created_at, updated_at, reason)
VALUES (
3879196,
(SELECT cds.id from rbs_customer_payment_detail_statuses cds where cds.status = 'rejected'),
'SYSTEM',
now(),
now(),
'Other: FUNDING-24509'
);
UPDATE rbs_customer_payment_details cd SET
cd.status_id = (SELECT cds.id FROM rbs_customer_payment_detail_statuses cds WHERE cds.status='rejected'),
cd.updated_at = now()
WHERE cd.id = 5031833
INSERT INTO rbs_customer_payment_detail_activities
(customer_payment_detail_id, status_id, username, created_at, updated_at, reason)
VALUES (
5031833,
(SELECT cds.id from rbs_customer_payment_detail_statuses cds where cds.status = 'rejected'),
'SYSTEM',
now(),
now(),
'Other: FUNDING-24509'
);```