| 1 |
- window.repositoryObject = {"parameters_custom_fields":[],"object_id":"f377","name":"FN_GET_GOODS_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_GOODS_NM"},{"field":"Type","value":"Function"}],"script":"BEGIN\r\n\r\n\tDECLARE O_RET_VALUE VARCHAR(500);\r\n\r\n\tSELECT CONCAT(IF(IFNULL(I_GOODS_GB,'') IN ('G073_11','G073_15',''),'',IFNULL(CONCAT('[',FN_GET_CODE_NM('G073',I_GOODS_GB),']'),''))\r\n\t ,IF(I_FOREIGN_BUY_YN = 'Y','[해외구매대행]','')\r\n\t ,IF(I_PARALLEL_IMPORT_YN = 'Y','[병행수입]','')\r\n\t ,IF(I_ORDER_MADE_YN = 'Y','[주문제작]','')\r\n\t ,I_GOODS_NM) AS GOODS_FULL_NM\r\n\tINTO O_RET_VALUE\r\n\tFROM DUAL\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(500)","custom_fields":{}},{"name":"I_GOODS_NM","description":null,"mode":"IN","data_type":"varchar(200)","custom_fields":{}},{"name":"I_GOODS_GB","description":null,"mode":"IN","data_type":"varchar(20)","custom_fields":{}},{"name":"I_FOREIGN_BUY_YN","description":null,"mode":"IN","data_type":"char(1)","custom_fields":{}},{"name":"I_PARALLEL_IMPORT_YN","description":null,"mode":"IN","data_type":"char(1)","custom_fields":{}},{"name":"I_ORDER_MADE_YN","description":null,"mode":"IN","data_type":"char(1)","custom_fields":{}}],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
