window.repositoryObject = {"parameters_custom_fields":[],"object_id":"f371","name":"FN_GET_BRAND_GROUP_NM","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"FN_GET_BRAND_GROUP_NM"},{"field":"Type","value":"Function"}],"script":"BEGIN\r\n\r\n\tDECLARE O_RET_VALUE VARCHAR(50);\r\n\r\n\tSELECT CASE WHEN BRAND_GROUP_ENM = '' OR BRAND_GROUP_ENM IS NULL THEN BRAND_GROUP_KNM\r\n\t\tELSE BRAND_GROUP_ENM END AS BRAND_GROUP_NM\r\n\tINTO   O_RET_VALUE\r\n\tFROM   TB_BRAND_GROUP\r\n\tWHERE  BRAND_GROUP_NO = I_BRAND_GROUP_NO\r\n\t;\r\n\r\n\tRETURN O_RET_VALUE;\r\n\r\nEND","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"varchar(50)","custom_fields":{}},{"name":"I_BRAND_GROUP_NO","description":null,"mode":"IN","data_type":"int(10, 0)","custom_fields":{}}],"dependencies":null,"imported_at":"2021-11-11 16:37"};