Net pricing calculation is slow

Hi:

We are using EBS 12.2.4

I have a sql query that is performing slow and need some tuning. In this query, it has hard coded one customer. But assuming if we have more customer, the query would take multiple long time.

I have tried sql tuning advisor for this and it gives recommendation to remove the disconnected view or table and user join instead and to avoid cartisan product. I am a little bit confused as to what this means as I am not a developer. Please advise. Thank you.

SELECT Y.*, CATALOG_ELEMENTS.* FROM (

SELECT

1. X.*,

ROW_NUMBER() OVER (PARTITION BY X.ACCOUNT_NUMBER, X.ITEM_NUMBER ORDER BY X.NET_PRICE ASC) BESTDISC