2011-11-17 11:31:24 y INFOz SELECT CODE, NAME FROM COMMON_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND MASTER_CODE_STR = :B_MASTER_CODE_STR ORDER BY DISP_ORDER 2011-11-17 11:31:32 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER 2011-11-17 11:31:34 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER 2011-11-17 11:31:35 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER 2011-11-17 12:40:32 y INFOz SELECT CODE, NAME FROM COMMON_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND MASTER_CODE_STR = :B_MASTER_CODE_STR ORDER BY DISP_ORDER 2011-11-17 12:40:49 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG ORDER BY DISP_ORDER 2011-11-17 12:43:27 y INFOz SELECT CODE, NAME FROM COMMON_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND MASTER_CODE_STR = :B_MASTER_CODE_STR ORDER BY DISP_ORDER 2011-11-17 12:43:37 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 2011-11-17 12:43:39 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 2011-11-17 13:25:33 y INFOz SELECT CODE, NAME FROM COMMON_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND MASTER_CODE_STR = :B_MASTER_CODE_STR ORDER BY DISP_ORDER 2011-11-17 13:25:44 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 2011-11-17 13:25:47 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 2011-11-17 13:25:48 y INFOz SELECT CODE, NAME FROM IRAI_KENTAI WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = :B_LAST_FLG AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER