ok i finally got a replacement cable from the gearbox to the TCM...well it goes from the transmission to the main engine harness....PART NUMBER = LNF3355AA

so i am hoping after replacing it, i'll be good...if not next step is the ABS module replacement...the cable is very short, and disconnecting it from the main engine harness is going to be tough, as the catalytic converters seem to block access...

 

ok it looks as if it is finally fixed...I just replaced the ABS module...I had replaced it went the solder contact came loose and I resoldered it...but the issue was I used too much glue and it ran all over the circuit board...most likely causing shorts once things heated up in there as the issue normally happened after things were warm, on my commute etc...this was a long one and I almost got rid of my car due to it...

 

and of course I hope this was a helpful thread for all...