To find transactions waiting for INSPECTION

Hi,
Can anyone provide SQL to find the transactions waiting for Inspection.

From R12 Application, we can see the transaction by below navigation :
Purchasing->Receiving Transactions->Select Receipt Routing as Inspection and Transaction Date as today ( in Transaction Details Tab) & Find.

From System Last Query we got below script . . . but when we execute this script it's not exactly matching with the data from front end.

select * from rcv_transactions_v where organization_id=27 and receipt_source_code IN ('INVENTORY','INTERNAL ORDER','VENDOR')
and routing_id=2 and transaction_date like sysdate

Thanks,
Saravanan