SQL quering - how to use results of one query in the following one

[unbeliever]

Dear All,

Looking forward to your help regarding issue described below.

I need to:
- query database for specific results
- select value of one of the columns for one particular record
- use this value in the next query.

I am connecting to Oracle 10 DB and example of queries I need to run are below:

=====
1. Get the order ID by execute:
select * from v_order where USERID_REQUESTOR = ‘TESTXXX’
Note the ordered in ‘WKF_ORDER_ID’.

Expected outcome:
The Order ID ‘WKF_ORDER_ID’ is displayed for the order where COMPLETION_TIME is today.

2. With the noted OrderID (‘WKF_ORDER_ID’), execute following statement:
select * from taudit where USERID_USR = ‘TESTYYY’ and AUDITSINGLEID = ‘< orderid>’
Make sure there is a ‘IPS’ entry in the request component.

Expected outcome:
In the audit table is a ‘IPS’ entry in the request component.
=====


Can you please provide me with methods and sample code for such operation?

Thanks in advance