Query for AP Interface Errors Details

 Query for AP Interface Errors Details:

SELECT aii.invoice_num, 

aii.gl_date,

aii.invoice_date, 

air.Reject_Lookup_Code, 

aii.Request_Id, 

air.*

FROM apps.ap_interface_rejections air,

      apps.ap_invoice_lines_interface aili,

      apps.ap_invoices_interface aii

WHERE aii.invoice_id     = aili.invoice_id

AND aili.invoice_line_id = air.parent_id

AND aii.invoice_num      = &p_Invoice_Num;