cof_rv_etiquetaxestoque

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_org_id

numeric

10

√

null

ad_client_id

numeric

10

√

null

m_product_id

numeric

10

√

null

m_product.m_product_id

Implied Constraint

R

value

varchar

510

√

null

description

varchar

255

√

null

cof_producttype_id

numeric

10

√

null

cof_producttype.cof_producttype_id

Implied Constraint

R

cof_productclass_id

numeric

10

√

null

cof_productclass.cof_productclass_id

Implied Constraint

R

cof_productgroup_id

numeric

10

√

null

cof_productgroup.cof_productgroup_id

Implied Constraint

R

c_uom_id

numeric

10

√

null

c_uom.c_uom_id

Implied Constraint

R

cof_conversionfactor1

numeric

0

√

null

Showing 1 to 10 of 23 entries

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT p.ad_org_id,
    p.ad_client_id,
    p.m_product_id,
    p.value,
    p.description,
    p.cof_producttype_id,
    p.cof_productclass_id,
    p.cof_productgroup_id,
    p.c_uom_id,
    p.cof_conversionfactor1,
    p.cof_conversionfactor2,
    st.m_warehouse_id,
    sum(st.qtyonhand) AS qtyonhand,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EI'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyapentrada,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EI'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyape,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EO'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyapsaida,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EO'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyaps,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'IN'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyentrada,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'IN'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtye,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'OU'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtysaida,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'OU'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtys,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'PR'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyprinted,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'PR'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyp
   FROM (m_product p
     LEFT JOIN rv_storage st ON ((st.m_product_id = p.m_product_id)))
  GROUP BY p.m_product_id, p.value, p.description, p.cof_producttype_id, p.cof_productclass_id, p.cof_productgroup_id, p.c_uom_id, p.cof_conversionfactor1, p.cof_conversionfactor2, st.m_warehouse_id;

 
SELECT p.ad_org_id,
    p.ad_client_id,
    p.m_product_id,
    p.value,
    p.description,
    p.cof_producttype_id,
    p.cof_productclass_id,
    p.cof_productgroup_id,
    p.c_uom_id,
    p.cof_conversionfactor1,
    p.cof_conversionfactor2,
    st.m_warehouse_id,
    sum(st.qtyonhand) AS qtyonhand,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EI'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyapentrada,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EI'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyape,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EO'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyapsaida,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'EO'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyaps,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'IN'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyentrada,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'IN'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtye,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'OU'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtysaida,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'OU'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtys,
    ( SELECT sum(lb.qty) AS sum
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'PR'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyprinted,
    ( SELECT count(lb.cof_label_id) AS count
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((lb.m_locator_id = l.m_locator_id)))
          WHERE ((p.m_product_id = lb.m_product_id) AND ((lb.status)::text = 'PR'::text) AND (l.m_warehouse_id = st.m_warehouse_id))) AS cof_qtyp
   FROM (m_product p
     LEFT JOIN rv_storage st ON ((st.m_product_id = p.m_product_id)))
  GROUP BY p.m_product_id, p.value, p.description, p.cof_producttype_id, p.cof_productclass_id, p.cof_productgroup_id, p.c_uom_id, p.cof_conversionfactor1, p.cof_conversionfactor2, st.m_warehouse_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views