AR Unposted Transactions in Oracle Apps

SELECT ract.*
  FROM ra_customer_trx_all ract,
       ra_customer_trx_lines_all ractl,
       ra_cust_trx_line_gl_dist_all ractgl
 WHERE     ract.customer_trx_id = ractl.customer_trx_id
       AND ractl.customer_trx_line_id = ractgl.customer_trx_line_id
       AND TRUNC (ractgl.gl_date) BETWEEN '01-AUG-16' AND '31-AUG-16'
       AND ractgl.gl_posted_date IS NULL
       AND ract.set_of_books_id = 1001