mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
cof_qtyfiscal(numeric, numeric)
Parameters
Name
Type
Mode
product_id
numeric
IN
warehouse_id
numeric
IN
Definition
DECLARE Quantity NUMERIC := 0; begin SELECT sum(det_prod_qcom) AS QtyOnHand INTO Quantity from COF_TransacoesFiscais where m_product_id = product_id and ad_org_id = (select w.ad_org_id from m_warehouse w where w.m_warehouse_id = warehouse_id); IF (Quantity IS NULL) THEN Quantity := 0; END IF; RETURN Quantity; END