ID_, CODE_, NAME_, PARENT_ID_, DESCRIPTON_, SN_, MEMO_, IS_DELE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, VERSION_, LAST_TIME_ select id_ ,code_,name_,parent_id_, memo_ from CMGT_MATERIAL_CLASS where IS_DELE_='0'; select id_ ,code_,name_,parent_id_ ,memo_ from CMGT_MATERIAL_CLASS where id_ = ${PARENT_ID_} and IS_DELE_='0'; select id_ ,code_,name_,parent_id_,memo_ from CMGT_MATERIAL_CLASS where PARENT_ID_ = ${id_} and IS_DELE_='0';