View: core.supplier_view

 CREATE OR REPLACE VIEW core.supplier_view
 AS
 SELECT parties.party_id,
    parties.party_type_id,
    parties.party_code,
    parties.first_name,
    parties.middle_name,
    parties.last_name,
    parties.party_name,
    parties.date_of_birth,
    parties.entity_id,
    parties.industry_id,
    parties.country_id,
    parties.state_id,
    parties.zip_code,
    parties.address_line_1,
    parties.address_line_2,
    parties.street,
    parties.city,
    parties.phone,
    parties.fax,
    parties.cell,
    parties.email,
    parties.url,
    parties.pan_number,
    parties.sst_number,
    parties.cst_number,
    parties.currency_code,
    parties.allow_credit,
    parties.maximum_credit_period,
    parties.maximum_credit_amount,
    parties.account_id,
    parties.audit_user_id,
    parties.audit_ts
   FROM core.parties
  WHERE (parties.party_type_id IN ( SELECT party_types.party_type_id
           FROM core.party_types
          WHERE party_types.is_supplier = true));