How many rows you have in MMT table?
Have you gathered the stats of the INV schema recently?
Did you test with some optimizer hints such as /*+ ordered */ or even /*+ rule */ ?
Thanks for the resonse.
I have 3195933 rows in the mtl_material_transactions_table. Stats are gathered every month. I have used /*+ rule */ but still takes a long time.