vw_ovmrecon_product

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

serialnumber

text

2147483647

√

null

custname

varchar

256

√

null

prod_cc

text

2147483647

√

null

prod_ns

varchar

50

√

null

idproduct_ns

int4

10

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH q AS (
         SELECT u.serialnumber,
            u.custname,
            u.producto AS prod_cc,
            n.productonom AS prod_ns,
            p.idproduct AS idproduct_ns
           FROM ((vw_units u
             JOIN staging.vw_qcsntoday_cc n ON (((n.serialnumber)::text = u.serialnumber)))
             LEFT JOIN product p ON (((p.erpname)::text = (n.productonom)::text)))
          WHERE ((u.serialnumber !~~ 'MX%'::text) AND (u.status = 'Active'::text))
        )
 SELECT q.serialnumber,
    q.custname,
    q.prod_cc,
    q.prod_ns,
    q.idproduct_ns
   FROM q
  WHERE (((q.prod_ns)::text <> q.prod_cc) AND ((q.prod_ns)::text = ANY ((ARRAY['FSE'::character varying, 'FSC'::character varying, 'FSCV2'::character varying, 'FSEV2'::character varying])::text[])) AND (q.prod_cc <> ALL (ARRAY['FSE'::text, 'FSC'::text, 'FSCV2'::text, 'FSEV2'::text])) AND ((q.custname)::text <> ALL ((ARRAY['COTIZACIONES'::character varying, 'COTIZACIONES COLOMBIA'::character varying, '1 CNR OPERACIONES - shield'::character varying])::text[])));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views