This excel sheet will help you find the proper link between two tables. The infomation is based on the extract of all views in a Oracle Applications database release 11.5.10. All 104894 links has the referenced view that generated the link. This is a great tool to learn how tables are connected in Oracle Applications.
The link names are not always perfect – here is some of the funny links in the sheet:
CSD_INCIDENTS_NON_SEC_V:
and CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID = HZ_PARTY_SITES.PARTY_SITE_ID
ICX_PO_DISTRIBUTES_DIFF_V:
and ICX_PO_REVISIONS_TEMP.LOCATION_ID = PO_LINE_LOCATIONS_ARCHIVE.SHIPMENT_NUM