select version_l, version_s from ims_md_life_cycle where ims_md_id = :ims_md_id select status_s, status_v from ims_md_life_cycle where ims_md_id = :ims_md_id select lfc.role_v, lfc.role_s, lfce.entity, lfc.cont_date, lfc.cont_date_l, lfc.cont_date_s from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_enty lfce where lfc.ims_md_lf_cont_id = lfce.ims_md_lf_cont_id and lfc.ims_md_id = :ims_md_id