Here's what I got.
Check engine light on, went to Autozone to use OBB11 and coded P0037
I understand that is Bank 1 Sensor 2
I have asked a couple different places and recieved some conflicting info on the part number.

Also, I am having trouble with the location of the sensor.

I was under the impression that B1S2 was after the cat and the connector is located below the drivers seat. When i got the sensor from the dealer it was the one with the short cable 6". That was not the one I expected to get. The one I expected to get connects under the driverside and has a cable approx. 18"

I could really use some help with the proper part number (Denso or Lexus) and a better explanation of where the sensor is located on an RX330

Welcome to Club Lexus, ctravis17. Like many topics you might have questions about, this one as been discussed previously and on multiple occasions. You just need to spend some time using the search tools of the forums. Such as:

RX330inFL - Thank you for getting back to me and for providing the the links above.
I did try to do my homework and i saw the post linked above but, it left me a little confused.
The member with the issue was originally mistaken about which sensor he was addressing and than he decided to go with a universal. So, no specific location and no specific part number. I have seen the diagram and i can take a good guess at which part is the sensor i need but, I can't be certain.

I was hoping to get confirmation that Bank 1 Sensor 2 = part number xxxx-xxxx
If not using, Denso's terminology Bank 1 Sensor 2 = Downstream Right or Left

None of the dealers or autopart stores in my area have the part in stock and, I don't want to order it and figure out a week later that it is the wrong part.

I found the Denso cutomer service line Customer Service: 1-877-675-5463
Very helpful

2004 RX330
B1S1 = A/F sensor Upstream Right
B1S2 = O2 sensor Downstream Right (this is located below the Cat on the drivers side with the connector on the undercarriage appox. below driver's seat.) Denso part number 234-4509 (locally $130)

I found the Denso cutomer service line Customer Service: 1-877-675-5463
Very helpful

2004 RX330
B1S1 = A/F sensor Upstream Right
B1S2 = O2 sensor Downstream Right (this is located below the Cat on the drivers side with the connector on the undercarriage appox. below driver's seat.) Denso part number 234-4509 (locally $130)