select purpose_s, purpose_v from ims_md_classification where ims_md_cl_id = :ims_md_cl_id select '(' || ctp.source_l || ') ' || ctp.source_v as source, ctp.ims_md_cl_ta_id, ctp.ims_md_cl_id, cl.ims_md_id from ims_md_classification_taxpath ctp, ims_md_classification cl where ctp.ims_md_cl_id = :ims_md_cl_id and cl.ims_md_cl_id = :ims_md_cl_id select '(' || descrip_l || ') ' || descrip_s as desc from ims_md_classification_descrip where ims_md_cl_id = :ims_md_cl_id select '(' || keyword_l || ') ' || keyword_s as keyword from ims_md_classification_keyword where ims_md_cl_id = :ims_md_cl_id