Replicating from one DB to another, using query in destination DB

[jcontesse]

I have to replicate certain rows of a table in ORACLE (source) to a table in SQL Server (destination).
The list of rows to replicate look like this:

ORACLE

ProductId RawMaterialId Cuantity
1 1 30
1 2 30
1 3 40
2 2 20
2 6 80
3 2 20
3 3 10
3 6 50
3 8 20
...

The destination table looks exactly the same.
The problem is that I want to replicate only certain rows (certain productId's).
The list of the productId's I want can be retrieved with an SQL statement on the SQL Server.

How can I do this with a DTS Package? I've tried with a data controllesd query but that would do if I could get the list of ProductId's with an SQL Statement in the ORACLE Server, but that is not possible.
Can anybody help me, please?
Thank you.