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: IBY_EXT_BANK_BRANCHES_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_EXT_BANK_BRANCHES_V

View Text

SELECT CEBRANCH.BRANCH_PARTY_ID BRANCH_PARTY_ID
, CEBRANCH.COUNTRY HOME_COUNTRY
, CEBRANCH.BANK_BRANCH_NAME BANK_BRANCH_NAME
, CEBRANCH.BANK_BRANCH_NAME_ALT BANK_BRANCH_NAME_ALT
, CEBRANCH.BRANCH_NUMBER BRANCH_NUMBER
, CEBRANCH.START_DATE START_DATE
, CEBRANCH.END_DATE END_DATE
, CEBRANCH.ADDRESS_LINE1 ADDRESS_LINE1
, CEBRANCH.ADDRESS_LINE2 ADDRESS_LINE2
, CEBRANCH.ADDRESS_LINE3 ADDRESS_LINE3
, CEBRANCH.ADDRESS_LINE4 ADDRESS_LINE4
, CEBRANCH.CITY CITY
, CEBRANCH.STATE STATE
, CEBRANCH.PROVINCE PROVINCE
, CEBRANCH.ZIP ZIP
, CEBRANCH.COUNTRY COUNTRY
, CEBRANCH.BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, CEBRANCH.DESCRIPTION DESCRIPTION
, CEBRANCH.EFT_SWIFT_CODE EFT_SWIFT_CODE
, CEBRANCH.EFT_USER_NUMBER EFT_USER_NUMBER
, CEBRANCH.BANK_PARTY_ID BANK_PARTY_ID
, 1 CREATED_BY
, SYSDATE CREATION_DATE
, 1 LAST_UPDATED_BY
, SYSDATE LAST_UPDATE_DATE
, 1 LAST_UPDATE_LOGIN
, 1 OBJECT_VERSION_NUMBER
, 'Y' OPERATION_FLAG
FROM CE_BANK_BRANCHES_V CEBRANCH

Columns

Name
BRANCH_PARTY_ID
HOME_COUNTRY
BANK_BRANCH_NAME
BANK_BRANCH_NAME_ALT
BRANCH_NUMBER
START_DATE
END_DATE
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
STATE
PROVINCE
ZIP
COUNTRY
BANK_BRANCH_TYPE
DESCRIPTION
EFT_SWIFT_CODE
EFT_USER_NUMBER
BANK_PARTY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
OPERATION_FLAG