2015-06-19 10:15:55 y INFOz SELECT CODE, SHORT_NAME NAME FROM CONTROL WHERE MASTER_CODE_STR = '00020004' AND ORDER_KIND_CODE_STR = '0011' AND CODE >= 11000011 AND CODE <= 11000019 AND CONDITION_FLG = 0 AND LAST_FLG = 1 2015-06-19 10:16:07 y INFOz SELECT CODE, NAME FROM YAKUHIN WHERE MASTER_CODE_STR = '00110001' AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2015-06-19 10:16:39 y INFOz SELECT CODE, NAME FROM YAKUHIN WHERE MASTER_CODE_STR = '00310001' AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY NAME 2015-06-19 10:16:57 y INFOz SELECT CODE, NAME FROM YAKUHIN WHERE MASTER_CODE_STR = '00310001' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND NAME LIKE '%' || :B_NAME || '%' ORDER BY NAME