mrp_exception_details join with po_line_locations_all. possible?

WE have a third party tool that run a SELECT statement against our Oracle EBS 11.4.10.2

The SELECT statement is to select * from mrp_exception_details to locate any exception data from standard PO.  But the mrp_exception_details or mrp_exception_details_v has PO header and PO lines information.  But We need to get information from

PO shipment level ( PO_line_locations_all ).  Is there a join ( or joins multiplute tables ) so we can tell the exception data from mrp_exception_details tables is from shipment Num 3 of PO1234?

any feedback is welcome.