2013-02-06 14:07:20 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 2013-02-06 14:07:28 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 2013-02-06 14:15:56 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 2013-02-06 14:18:43 y INFOz SELECT CODE, NAME FROM COMMON WHERE MASTER_CODE_STR = '00010001' AND CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER 2013-02-06 14:19:23 y INFOz SELECT SET_NO CODE, NAME FROM CHEMO_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY NAME 2013-02-06 14:19:27 y INFOz SELECT SET_NO CODE, NAME FROM CHEMO_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY NAME 2013-02-06 14:19:42 y INFOz SELECT SET_NO CODE, NAME FROM CHEMO_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY NAME 2013-02-06 14:19:53 y INFOz SELECT CODE, NAME FROM COMMON WHERE MASTER_CODE_STR = '00010001' AND CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER