How to retrieve Item description, Item Status, LifeCyclePhase of an Item number as per Item Revision

Hi All,
In the Product development screen of Product Management, Item attributes like Item Description, Item Status, Life Cycle Phase, Projects are available according to Revision. Revision 1 has different Item Description, Item Status, Life Cycle Phase, Projects to the Revision 2 and same for Revision3 as well.
In which table does this information is available?? How to retrieve these columns data as per revision?? I have checked all the standard tables but this information is not available. Kindly suggest how can we retrieve this data.