View: transactions.stock_transaction_view

 CREATE OR REPLACE VIEW transactions.stock_transaction_view
 AS
 SELECT transaction_master.transaction_master_id,
    stock_master.stock_master_id,
    stock_details.stock_detail_id,
    transaction_master.book,
    transaction_master.transaction_counter,
    transaction_master.transaction_code,
    transaction_master.value_date,
    transaction_master.transaction_ts,
    transaction_master.login_id,
    transaction_master.user_id,
    transaction_master.sys_user_id,
    transaction_master.office_id,
    transaction_master.cost_center_id,
    transaction_master.reference_number,
    transaction_master.statement_reference,
    transaction_master.last_verified_on,
    transaction_master.verified_by_user_id,
    transaction_master.verification_status_id,
    transaction_master.verification_reason,
    stock_master.party_id,
    parties.country_id,
    parties.state_id,
    stock_master.salesperson_id,
    stock_master.price_type_id,
    stock_master.is_credit,
    stock_master.shipper_id,
    stock_master.shipping_address_id,
    stock_master.shipping_charge,
    stock_master.store_id AS stock_master_store_id,
    stock_master.cash_repository_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.discount,
    stock_details.sales_tax_id,
    stock_details.tax
   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
   JOIN core.parties ON stock_master.party_id = parties.party_id;