2013-06-13 13:57:12 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 AND FLG_01 = 1 ORDER BY DISP_ORDER 2013-06-13 13:57:17 y INFOz SELECT CODE, NAME FROM YAKUHIN WHERE MASTER_CODE_STR = '00310001' AND LAST_FLG = :B_LAST_FLG AND SUBSTR(YAKUZAI_CHECK_FLGTBL, 30, 1) = '1' ORDER BY 2