query help please

[whtisthat]

I have mtl_system_items
item,user_item_type,item_status
and in the flexfield i have like 10 attribute
In some of the attribute have data in another table like lookup and other table I want to join like 5 tables but the mtl_system_items show's the code like AA and other table has the meaning how to show the meaning of the code like org 1 will be LAX 2 will be NYC

any logic to take care for this kind of query

Thanks