Appreciate if someone can kindly help with the attached: sample data set (I have enclosed the expected result)
I am trying to list in the result:
-> All part codes
-> all vendor numbers related to the part (if it is purchased, since a part can be manufactured or purchased)
-> the last purchase date (for the related vendor and part)
-> the last received order (based on the Max value of the order number on the last purchase date)
-> Order line corresponding to the order number
thanks in advance , and I hope I have explained the reuirement without confusion.
Spent considerable time on this and was not able achieve the desired results, had used firstsortedvalue aggr functions, set value etc.
but without success.
Again, thanks in advance, if someone can help me out on this, will be greatly appreciated.
