eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CEFV_BANK_BRANCHES

Product:	CE - Cash Management
Description:	Business view
Implementation/DBA Data:	APPS.CEFV_BANK_BRANCHES

View Text

SELECT BB.BRANCH_PARTY_ID
, BB.BANK_NAME
, BB.BANK_NAME_ALT
, BB.BANK_NUMBER
, BB.BANK_BRANCH_NAME
, BB.BANK_BRANCH_NAME_ALT
, BB.BRANCH_NUMBER
, BB.BANK_BRANCH_TYPE
, BB.DESCRIPTION
, BB.START_DATE
, BB.END_DATE
, BB.ADDRESS_LINE1
, BB.ADDRESS_LINE2
, BB.ADDRESS_LINE3
, BB.ADDRESS_LINE4
, TO_CHAR(NULL)
, BB.CITY
, BB.PROVINCE
, BB.STATE
, BB.ZIP
, BB.COUNTRY
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, BB.EFT_USER_NUMBER
, BB.EFT_SWIFT_CODE
, BB.EDI_ID_NUMBER
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, '_LA:BB.BANK_INSTITUTION_TYPE:CE_LOOKUPS:INSTITUTION_TYPE:MEANING'
FROM CE_BANK_BRANCHES_V BB WITH READ ONLY

Columns

Name
BANK_BRANCH_ID
BANK_NAME
ALTERNATE_BANK_NAME
BANK_NUMBER
BANK_BRANCH_NAME
ALTERNATE_BANK_BRANCH_NAME
BANK_BRANCH_NUMBER
BANK_BRANCH_TYPE
DESCRIPTION
START_EFFECTIVE_DATE
END_EFFECTIVE_DATE
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
ALTERNATE_ADDRESS_LINES
CITY
COUNTY
STATE
ZIP_CODE
COUNTRY
AREA_CODE
PHONE
CONTACT_FIRST_NAME
CONTACT_MIDDLE_NAME
CONTACT_LAST_NAME
CONTACT_PREFIX
CONTACT_TITLE
EFT_USER_NUMBER
EFT_SWIFT_CODE
EDI_ID_NUMBER
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
"_LA:INSTITUTION_TYPE"