mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
cof_getreflistvalue(character varying, character varying, character varying)
Parameters
Name
Type
Mode
table_name
character varying
IN
column_name
character varying
IN
value_list
character varying
IN
Definition
DECLARE reference_id INTEGER; ret_val Varchar; BEGIN BEGIN SELECT AD_Reference_Value_ID INTO reference_id FROM ad_column c LEFT JOIN ad_table t ON (t.ad_table_id = c.ad_table_id) WHERE c.columnname = column_name AND t.tablename = table_name; EXCEPTION WHEN NO_DATA_FOUND THEN ret_val := null; END; BEGIN SELECT COALESCE(rtrl.Name,r.Name) INTO ret_val FROM ad_ref_list r LEFT JOIN ad_ref_list_trl rtrl ON (rtrl.ad_ref_list_id = r.ad_ref_list_id and rtrl.ad_language='pt_BR') WHERE r.AD_Reference_ID = reference_id and r.value = value_list; EXCEPTION WHEN NO_DATA_FOUND THEN ret_val := null; END; RETURN ret_val; END;