Materialized View: transactions.verified_stock_transaction_view

 CREATE MATERIALIZED VIEW transactions.verified_stock_transaction_view
 AS
 SELECT stock_transaction_view.transaction_master_id,
    stock_transaction_view.stock_master_id,
    stock_transaction_view.stock_detail_id,
    stock_transaction_view.book,
    stock_transaction_view.transaction_counter,
    stock_transaction_view.transaction_code,
    stock_transaction_view.value_date,
    stock_transaction_view.transaction_ts,
    stock_transaction_view.login_id,
    stock_transaction_view.user_id,
    stock_transaction_view.sys_user_id,
    stock_transaction_view.office_id,
    stock_transaction_view.cost_center_id,
    stock_transaction_view.reference_number,
    stock_transaction_view.statement_reference,
    stock_transaction_view.last_verified_on,
    stock_transaction_view.verified_by_user_id,
    stock_transaction_view.verification_status_id,
    stock_transaction_view.verification_reason,
    stock_transaction_view.party_id,
    stock_transaction_view.country_id,
    stock_transaction_view.state_id,
    stock_transaction_view.salesperson_id,
    stock_transaction_view.price_type_id,
    stock_transaction_view.is_credit,
    stock_transaction_view.shipper_id,
    stock_transaction_view.shipping_address_id,
    stock_transaction_view.shipping_charge,
    stock_transaction_view.stock_master_store_id,
    stock_transaction_view.cash_repository_id,
    stock_transaction_view.tran_type,
    stock_transaction_view.store_id,
    stock_transaction_view.item_id,
    stock_transaction_view.quantity,
    stock_transaction_view.unit_id,
    stock_transaction_view.base_quantity,
    stock_transaction_view.base_unit_id,
    stock_transaction_view.price,
    stock_transaction_view.discount,
    stock_transaction_view.sales_tax_id,
    stock_transaction_view.tax
   FROM transactions.stock_transaction_view
  WHERE stock_transaction_view.verification_status_id > 0;