SQL Query to fetch AP Invoice Rejections-Oracle ERP Cloud

SELECT i.LOAD_REQUEST_ID,

i.INVOICE_ID,

i.INVOICE_NUM,

i.INVOICE_DATE,

i.STATUS,

i.SOURCE,

i.REQUEST_ID,

r.LOAD_REQUEST_ID r_LOAD_REQUEST_ID,

r.PARENT_TABLE,

r.PARENT_ID,

r.REJECT_LOOKUP_CODE,

i.INVOICE_AMOUNT

FROM ap_interface_rejections r,

ap_invoices_interface i, ap_invoice_lines_interface c

WHERE ( r.parent_id = c.invoice_line_id

or r.parent_id = i.invoice_id)

and c.invoice_id = i.invoice_id

AND r.load_request_id = i.load_request_id

AND i.status = 'REJECTED'

Hope this Helps!