Materialized View: transactions.verified_cash_transaction_mat_view

 CREATE MATERIALIZED VIEW transactions.verified_cash_transaction_mat_view
 AS
 SELECT verified_transaction_mat_view.transaction_master_id,
    verified_transaction_mat_view.transaction_counter,
    verified_transaction_mat_view.transaction_code,
    verified_transaction_mat_view.book,
    verified_transaction_mat_view.value_date,
    verified_transaction_mat_view.transaction_ts,
    verified_transaction_mat_view.login_id,
    verified_transaction_mat_view.user_id,
    verified_transaction_mat_view.sys_user_id,
    verified_transaction_mat_view.office_id,
    verified_transaction_mat_view.cost_center_id,
    verified_transaction_mat_view.reference_number,
    verified_transaction_mat_view.master_statement_reference,
    verified_transaction_mat_view.last_verified_on,
    verified_transaction_mat_view.verified_by_user_id,
    verified_transaction_mat_view.verification_status_id,
    verified_transaction_mat_view.verification_reason,
    verified_transaction_mat_view.transaction_detail_id,
    verified_transaction_mat_view.tran_type,
    verified_transaction_mat_view.account_id,
    verified_transaction_mat_view.account_number,
    verified_transaction_mat_view.account_name,
    verified_transaction_mat_view.normally_debit,
    verified_transaction_mat_view.account_master_code,
    verified_transaction_mat_view.account_master_name,
    verified_transaction_mat_view.account_master_id,
    verified_transaction_mat_view.confidential,
    verified_transaction_mat_view.statement_reference,
    verified_transaction_mat_view.cash_repository_id,
    verified_transaction_mat_view.currency_code,
    verified_transaction_mat_view.amount_in_currency,
    verified_transaction_mat_view.local_currency_code,
    verified_transaction_mat_view.amount_in_local_currency
   FROM transactions.verified_transaction_mat_view
  WHERE (verified_transaction_mat_view.transaction_master_id IN ( SELECT verified_transaction_mat_view_1.transaction_master_id
           FROM transactions.verified_transaction_mat_view verified_transaction_mat_view_1
          WHERE verified_transaction_mat_view_1.account_master_id = ANY (ARRAY[10101, 10102])));