Optimal way to join WSH_DELIVERY_DETAILS and INV_TRANSFER_ORDER_LINES

Summary:

Hi Team,

Is there any other way to join WSH_DELIVERY_DETAILS with INV_TRANSFER_ORDER_LINES which will give optima execution plan.

We are now using the below query to achieve the requirement but it is not taking optimal execution plan. Please suggest any other column can be joined to for optimal execution plan.

Thanks,

Baswanth

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT wdd.source_header_number
FROM INV_TRANSFER_ORDER_HEADERS ith
,INV_TRANSFER_ORDER_LINES itl