SELECT customer_transport_account details for leaving customer

This query is specific to Lahden Aluetaksi

 SELECT customer_transport_account.index,
    customer_transport_account.uuid,
    customer_transport_account.user_index,
    customer_transport_account.account_type,
    customer_transport_account.name,
    customer_transport_account.amount,
    customer_transport_account.amount_type,
    customer_transport_account.validity_type,
    customer_transport_account.valid_from,
    customer_transport_account.valid_until,
    customer_transport_account.exempt_from_copayment,
    customer_transport_account.created,
    customer_transport_account.updated,
    customer_transport_account.deleted_state,
    customer_transport_account.cost_center_index,
    CASE customer_transport_account.cost_center_index
        WHEN 0 THEN 'ei valittu matkaoikeudella, fallback org confissa perustuen asiakkaan asiakasstyyppi VPL, SHL'
        WHEN 1788 THEN 'VPL booking cost center 6424 / 4422'
        WHEN 1789 THEN 'EHL bookingin cost center 6423 / 4422'
        WHEN 107 THEN 'EHL Päpiväaikainen Iitti 6423'
        WHEN 108 THEN 'Päiväaikainen Orimattila 6423'
        WHEN 106 THEN 'EHL asiakastyyppi'
        WHEN 1801 THEN 'Päiväaikainen heinola'
        ELSE customer_transport_account.cost_center_index::text -- Keep original value as text if no alias matches
    END AS cost_center_alias,
    customer_transport_account.additional_info,
    customer_transport_account.external_id,
    customer_transport_account.quick_ride_amount,
    customer_transport_account.combinability_type,
    customer_transport_account.copayment_max_invoiced_amount,
    customer_transport_account.fixed_copayment,
    customer_transport_account.copayment_type,
    customer_transport_account.amount_reference_period,
    customer.org_index AS customer_org_index,
    customer.uuid AS customer_uuid
   FROM customer_transport_account
     JOIN customer ON customer_transport_account.user_index = customer.index
  -- LAT / Päijät-sote
  WHERE customer.org_index = '9'::bigint
  ORDER BY index ASC;

Different version of this:

-- tms_booking
-- get all CTA data

SELECT
    customer_transport_account.index AS cta_index,
    customer_transport_account.uuid AS cta_uuid,
    customer_transport_account.name AS cta_name,
    customer_transport_account.account_type AS cta_account_type,
    customer_transport_account.additional_info AS cta_additional_info,
    customer_transport_account.amount AS cta_amount,
    customer_transport_account.amount_reference_period AS cta_amount_reference_period,
    customer_transport_account.amount_type AS cta_amount_type,
    customer_transport_account.combinability_type AS cta_combinability,
    customer_transport_account.copayment_max_invoiced_amount AS cta_copayment_max_invoiced_amount,
    customer_transport_account.copayment_type AS cta_copayment_type,
    customer_transport_account.cost_center_index AS cta_cost_center_index,
    customer_transport_account.exempt_from_copayment AS cta_exempt_from_copayment,
    customer_transport_account.external_id AS external_id,
    customer_transport_account.fixed_copayment AS cta_fixed_copayment,
    customer_transport_account.quick_ride_amount AS cta_quick_ride_amount,
    customer_transport_account.user_index AS cta_user_index,
    customer_transport_account.valid_from AS cta_valid_from,
    customer_transport_account.valid_until AS cta_valid_until,
    customer_transport_account.validity_type AS cta_validity_type,
    customer_transport_account.created AS cta_created,
    customer_transport_account.updated AS cta_updated,
    customer_transport_account.deleted_state AS cta_deleted_state,
    customer.org_index AS customer_org_index
FROM
    customer_transport_account
JOIN
    customer ON customer_transport_account.user_index = customer.index
  -- HelsinginMPK
WHERE
    customer.org_index = '11'::bigint
AND
    customer.uuid = '8ecb235d-f144-48b8-8f0b-d7a59b2374b7'::uuid
ORDER BY
    account_type;