FND Design Data [Home] [Help]

View: AP_TRANSMISSION_CODES_V

Product: AP - Payables
Description: This view displays the transmission codes,bank names and associated branch names.
Implementation/DBA Data: ViewAPPS.AP_TRANSMISSION_CODES_V
View Text

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

Columns

Name
TRANSMISSION_CODE
BANK_NAME
BANK_BRANCH_NAME