View: core.compound_item_detail_scrud_view

Schema	core
Materialized View Name	compound_item_detail_scrud_view
Owner	postgres
Tablespace	DEFAULT
Description

 CREATE OR REPLACE VIEW core.compound_item_detail_scrud_view
 AS
 SELECT compound_item_details.compound_item_detail_id,
    compound_item_details.compound_item_id,
    compound_items.compound_item_code,
    compound_items.compound_item_name,
    compound_item_details.item_id,
    core.get_item_name_by_item_id(compound_item_details.item_id) AS item,
    core.get_unit_name_by_unit_id(compound_item_details.unit_id) AS unit,
    compound_item_details.quantity
   FROM core.compound_item_details
   JOIN core.compound_items ON compound_item_details.compound_item_id = compound_items.compound_item_id;