select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select 1 from ims_cp_files where file_id = :object and res_id = :ims_res_id select href as res_href, identifier as identiferref from ims_cp_resources where res_id = :ims_res_id select distinct pathtofile, filename from ims_cp_files where file_id = :object select identifier, item_title, parent_item, org_id, sort_order, identifierref from ims_cp_items where ims_item_id = :ims_item_id select distinct filename from ims_cp_files where file_id = :new_file_id select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select parent_item from ims_cp_items where ims_item_id = :ims_item_id