How to join inventory_item_detail and inventory_transfer in sql

[Agasit Wongsaya]

Hi
I want to create report in PHP with OCI8. but I don't know relation between 
inventory_item_detail and inventory_transfer. Now, I see relation 
inventory_transfer.last_update_stamp and inventory_item_detail.effective_date. 
I think it has other good condition to join and not choose date field join in 
sql statement.