View: core.item_cost_price_scrud_view

 CREATE OR REPLACE VIEW core.item_cost_price_scrud_view
 AS
 SELECT item_cost_prices.item_cost_price_id,
    items.item_code,
    items.item_name,
    parties.party_code,
    parties.party_name,
    ((units.unit_code::text || ' ('::text) || units.unit_name::text) || ')'::text AS unit,
    item_cost_prices.price
   FROM core.item_cost_prices
   JOIN core.items ON item_cost_prices.item_id = items.item_id
   JOIN core.units ON item_cost_prices.unit_id = units.unit_id
   LEFT JOIN core.parties ON item_cost_prices.party_id = parties.party_id;