---

SELECT
    table_name,
    column_name,
    data_type
FROM information_schema.columns
WHERE table_schema = 'prod_line'
  AND table_name IN (
      SELECT table_name
      FROM information_schema.columns
      WHERE table_schema = 'prod_line'
        AND column_name = 'pens_product_param_pl_id'
  )
  AND (
       column_name = 'pens_product_param_pl_id'
    OR column_name ILIKE '%amount%'
    OR column_name ILIKE '%sum%'
    OR column_name ILIKE '%percent%'
    OR column_name ILIKE '%rate%'
    OR column_name ILIKE '%share%'
    OR column_name ILIKE '%contribution%'
    OR column_name ILIKE '%deduct%'
    OR column_name ILIKE '%reserve%'
    OR column_name ILIKE '%ss%'
    OR column_name ILIKE '%sr%'
  )
ORDER BY table_name, ordinal_position;