Supplier Payment Method and Delivery Mail query

select
hou.name "OU_NAME",
aps.segment1 "SUPPLIER_NUMBER",
aps.vendor_name,
assl.vendor_site_code,
--iepa.ext_payee_id,
--assl.party_site_id,
ieppmh.payment_method_code "PAYMENT_METHOD_SITE", 
iepah.remit_advice_delivery_method  "DELIVERY_METHOD_HEAD",
iepah.remit_advice_email "REMIT_ADVICE_EMAIL_HEADER",
ieppm.payment_method_code "PAYMENT_METHOD_SITE", 
iepa.remit_advice_delivery_method  "DELIVERY_METHOD_SITE",
iepa.remit_advice_email "REMIT_ADVICE_EMAIL_SITE"
from
hr_operating_units hou,
AP_SUPPLIERS aps,
AP_SUPPLIER_SITES_ALL assl,
iby_external_payees_all iepah,
iby_ext_party_pmt_mthds ieppmh,
iby_external_payees_all iepa,
iby_ext_party_pmt_mthds ieppm
where
aps.VENDOR_ID = assl.VENDOR_ID
and hou.ORGANIZATION_ID = assl.ORG_ID
and assl.ORG_ID = iepa.ORG_ID
and iepa.payee_party_id    = aps.party_id
AND aps.enabled_flag     = 'Y'
AND iepa.org_id              = assl.org_id
AND iepa.supplier_site_id    = assl.vendor_site_id
AND iepa.ext_payee_id = ieppm.ext_pmt_party_id
and ieppm.PRIMARY_FLAG ='Y'
and ieppm.PAYMENT_METHOD_CODE='WIRE'
and iepa.REMIT_ADVICE_DELIVERY_METHOD='EMAIL'
and iepah.payee_party_id    = aps.party_id
and iepah.PARTY_SITE_ID is null
AND iepah.ext_payee_id = ieppmh.ext_pmt_party_id
and ieppmh.PRIMARY_FLAG ='Y'
--and aps.segment1 ='E52029'
and ieppmh.PAYMENT_METHOD_CODE='WIRE'
and iepah.REMIT_ADVICE_DELIVERY_METHOD='EMAIL'