2015-06-11 10:12:45 y INFOz SELECT CODE, NAME FROM YAKUHIN WHERE MASTER_CODE_STR = '00110001' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 2015-06-11 12:33:32 y INFOz SELECT CODE, NAME FROM ZAIRYO_SHOCHI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER 2015-06-11 12:35:37 y INFOz SELECT CODE, NAME FROM ZAIRYO_SHOCHI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 2015-06-11 12:37:02 y INFOz SELECT CODE, NAME FROM ZAIRYO_SHOCHI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER