The elapse time of the sql run in PROD is 10 times in PREP

PREP has the same data as PROD

In PREP

SELECT X.*

FROM

 (SELECT INVOICE_ID,INVOICE_DATE, A.ATTRIBUTE2 FROM AP_INVOICES_ALL A,

 AR_RECEIVABLE_APPLICATIONS_ALL B WHERE VENDOR_SITE_ID = :B1 AND

 INVOICE_TYPE_LOOKUP_CODE = 'STANDARD' AND PAYMENT_STATUS_FLAG ='Y' AND

 A.ATTRIBUTE11 IS NULL AND A.ATTRIBUTE2 NOT IN (SELECT CASH_RECEIPT_ID FROM

 AR_CASH_RECEIPTS_ALL WHERE STATUS IN ('REV','NSF','CC_CHARGEBACK_REV' ,

 'STOP')) AND A.ATTRIBUTE1 = B.RECEIVABLE_APPLICATION_ID AND

 B.APPLICATION_TYPE ='CASH' ORDER BY INVOICE_DATE DESC) X WHERE ROWNUM = 1

call   count    cpu  elapsed    disk   query  current    rows