VIEW: APPS.AP_TRANSMISSION_CODES_V

Source

View Text - Preformatted

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