Query to fetch Trading partner Details of Bank Branch for EDI Payments

SELECT DISTINCT cba.bank_account_name, 

                cvv.bank_branch_name, 

                bktph.tp_code

           FROM ce_bank_accounts cba,

                ce_bank_branches_v cvv,

                hz_contact_points hcp,

                ece_tp_headers bktph,

                ece_tp_details bktpd

          WHERE hcp.owner_table_id     = cba.bank_branch_id

            AND cvv.branch_party_id    = cba.bank_branch_id

            AND bktph.tp_header_id     = hcp.edi_tp_header_id(+)

            AND bktpd.tp_header_id     = bktph.tp_header_id(+)

            AND bktpd.document_id      = 'PYO'

            AND hcp.owner_table_name   = 'HZ_PARTIES'

            AND hcp.contact_point_type = 'EDI'

            AND bktpd.edi_flag         = 'Y';