View: core.shipper_scrud_view

 CREATE OR REPLACE VIEW core.shipper_scrud_view
 AS
 SELECT shippers.shipper_id,
    shippers.shipper_code,
    shippers.company_name,
    shippers.shipper_name,
    shippers.po_box,
    shippers.address_line_1,
    shippers.address_line_2,
    shippers.street,
    shippers.city,
    shippers.state,
    shippers.country,
    shippers.phone,
    shippers.fax,
    shippers.cell,
    shippers.email,
    shippers.url,
    shippers.contact_person,
    shippers.contact_po_box,
    shippers.contact_address_line_1,
    shippers.contact_address_line_2,
    shippers.contact_street,
    shippers.contact_city,
    shippers.contact_state,
    shippers.contact_country,
    shippers.contact_email,
    shippers.contact_phone,
    shippers.contact_cell,
    shippers.factory_address,
    shippers.pan_number,
    shippers.sst_number,
    shippers.cst_number,
    ((accounts.account_number::text || ' ('::text) || accounts.account_name::text) || ')'::text AS account
   FROM core.shippers
   JOIN core.accounts ON shippers.account_id = accounts.account_id;