mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
bomqtyonhandreposicao(numeric, numeric, numeric)
Parameters
Name
Type
Mode
product_id
numeric
IN
warehouse_id
numeric
IN
locator_id
numeric
IN
Definition
DECLARE Qty NUMERIC := 0; begin SELECT sum(bomqtyonhand(product_id, sw.COF_Warehouse_ID, locator_id)) AS qty INTO Qty from COF_SpareWarehouse sw where sw.M_Warehouse_ID = warehouse_id; IF (Qty IS NULL) THEN Qty := 0; END IF; RETURN Qty; END