I routinely setup by PT to pull from Oracle tables. Using the "Back" button in the wizrad I can modify the SQL in MSQuery.

note: When I first create PTs I use connect to "External Data Source" and select the required ODBC driver.