SELECT a.transmission_code, b.bank_name, b.bank_branch_name FROM ap_transmissions_setup a, ce_bank_branches_v b WHERE a.bank_branch_id = b.branch_party_id order by b.bank_name,b.bank_branch_name
View Text - HTML Formatted
SELECT A.TRANSMISSION_CODE , B.BANK_NAME , B.BANK_BRANCH_NAME FROM AP_TRANSMISSIONS_SETUP A , CE_BANK_BRANCHES_V B WHERE A.BANK_BRANCH_ID = B.BRANCH_PARTY_ID ORDER BY B.BANK_NAME , B.BANK_BRANCH_NAME