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 as role, lfce.entity, lfc.cont_date, lfc.cont_date_l || ' ' || lfc.cont_date_s as cont_date_ls from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_entity lfce where lfc.ims_md_lf_cont_id = lfce.ims_md_lf_cont_id and lfc.ims_md_id = :ims_md_id