Query to get the Remit to Wire to information for the invoices

SELECT DISTINCT oha.header_id
,rcta.customer_trx_id
,oha.order_number
,rcta.trx_number
,rctla.sales_order
,tt.cust_trx_type_id
,tt.NAME,w_l.address1 w_address1
,w_l.address2 w_address2
,w_l.address3 w_address3
,w_l.city w_city
,w_l.state w_state
,w_l.postal_code w_postal_code
,w_l.country w_country
,r_l.address1 r_address1
,r_l.address2 r_address2
,r_l.address3 r_address3
,r_l.city r_city
,r_l.state r_state
,r_l.postal_code r_postal_code
,r_l.country r_country
FROM ont.oe_order_headers_all oha,ont.oe_order_lines_all ola,ar.ra_customer_trx_lines_all rctla,ar.ra_customer_trx_all rcta,ar.ra_cust_trx_types_all tt,ar.hz_party_sites w_ps,ar.hz_party_sites r_ps,ar.hz_locations r_l,ar.hz_locations w_l
WHERE oha.header_id = ola.header_id
AND oha.order_number = rctla.sales_order
AND rctla.customer_trx_id = rcta.customer_trx_id
AND w_l.location_id = w_ps.location_id(+)AND w_l.location_id(+) = tt.attribute14
AND r_l.location_id = r_ps.location_id(+)AND r_l.location_id(+) = tt.attribute15
AND tt.cust_trx_type_id = rcta.cust_trx_type_id

Please find the navigation for the Remit To and Wire to Addresses below.

Responsibility: Receivables Manager.

Setup: Print : Remit-To-Addresses