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_BANKS_V

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

View Text

SELECT CEBANK.BANK_PARTY_ID BANK_PARTY_ID
, CEBANK.HOME_COUNTRY HOME_COUNTRY
, CEBANK.BANK_NAME BANK_NAME
, CEBANK.BANK_NUMBER BANK_NUMBER
, CEBANK.BANK_INSTITUTION_TYPE BANK_INSTITUTION_TYPE
, CEBANK.BANK_NAME_ALT BANK_NAME_ALT
, CEBANK.SHORT_BANK_NAME SHORT_BANK_NAME
, CEBANK.DESCRIPTION DESCRIPTION
, CEBANK.END_DATE END_DATE
, CEBANK.ADDRESS_LINE1 ADDRESS1
, CEBANK.ADDRESS_LINE2 ADDRESS2
, CEBANK.ADDRESS_LINE3 ADDRESS3
, CEBANK.CITY CITY
, CEBANK.STATE STATE
, CEBANK.ZIP ZIPCODE
, CEBANK.COUNTRY COUNTRY
, 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_BANKS_V CEBANK

Columns

Name
BANK_PARTY_ID
HOME_COUNTRY
BANK_NAME
BANK_NUMBER
BANK_INSTITUTION_TYPE
BANK_NAME_ALT
SHORT_BANK_NAME
DESCRIPTION
END_DATE
ADDRESS1
ADDRESS2
ADDRESS3
CITY
STATE
POSTAL_CODE
COUNTRY
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
OPERATION_FLAG