how to extract item current version and will be effective version information

Hi,

I want to extract item current version and will be effective version(if have this record) information, includes these column: item#,item description,ite_type,current version,version_description, will be effective version, I try to write below script, but i don't know how to extract the current version and will be effective version, can you help improve the script?

Thanks

Will

select b.segment1,
b.description,
b.item_type,
v. revision,
v.description
from mtl_system_items_b b,
MTL_ITEM_REVISIONS_VL v
where b.organization_id='XXX'
and b.inventory_item_id=v.inventory_item_id