View: office.office_view

Schema	office
Materialized View Name	office_view
Owner	postgres
Tablespace	DEFAULT
Description

 CREATE OR REPLACE VIEW office.office_view
 AS
 SELECT offices.office_id,
    offices.office_code,
    offices.office_name,
    offices.nick_name,
    offices.registration_date,
    offices.currency_code,
    offices.po_box,
    offices.address_line_1,
    offices.address_line_2,
    offices.street,
    offices.city,
    offices.state,
    offices.zip_code,
    offices.country,
    offices.phone,
    offices.fax,
    offices.email,
    offices.url,
    offices.registration_number,
    offices.pan_number,
    offices.allow_transaction_posting,
    offices.parent_office_id,
    offices.audit_user_id,
    offices.audit_ts
   FROM office.offices;