mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
bpartnerremitlocation(numeric)
Parameters
Name
Type
Mode
p_c_bpartner_id
numeric
IN
Definition
DECLARE v_C_Location_ID NUMERIC := NULL; l RECORD; BEGIN FOR l IN SELECT IsRemitTo, C_Location_ID FROM C_BPartner_Location WHERE C_BPartner_ID=p_C_BPartner_ID AND IsActive='Y' ORDER BY IsRemitTo DESC LOOP IF (v_C_Location_ID IS NULL) THEN v_C_Location_ID := l.C_Location_ID; END IF; END LOOP; RETURN v_C_Location_ID; END;