View: transactions.verified_stock_details_view

 CREATE OR REPLACE VIEW transactions.verified_stock_details_view
 AS
 SELECT stock_details.stock_detail_id,
    stock_details.value_date,
    stock_details.stock_master_id,
    stock_details.tran_type,
    stock_details.store_id,
    stock_details.item_id,
    stock_details.quantity,
    stock_details.unit_id,
    stock_details.base_quantity,
    stock_details.base_unit_id,
    stock_details.price,
    stock_details.cost_of_goods_sold,
    stock_details.discount,
    stock_details.shipping_charge,
    stock_details.sales_tax_id,
    stock_details.tax,
    stock_details.audit_user_id,
    stock_details.audit_ts
   FROM transactions.stock_details
   JOIN transactions.stock_master ON stock_master.stock_master_id = stock_details.stock_master_id
   JOIN transactions.transaction_master ON transaction_master.transaction_master_id = stock_master.transaction_master_id AND transaction_master.verification_status_id > 0;