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

Product:	CE - Cash Management
Description:	Banks
Implementation/DBA Data:	APPS.CE_BANKS_MERGE_V

View Text

SELECT BANKPARTY.ROWID ROW_ID
, BANKPARTY.PARTY_ID BANK_PARTY_ID
, BANKPARTY.PARTY_NAME BANK_NAME
, BANKPARTY.ORGANIZATION_NAME_PHONETIC BANK_NAME_ALT
, BANKPARTY.KNOWN_AS SHORT_BANK_NAME
, BANKPARTY.ADDRESS1 ADDRESS_LINE1
, BANKPARTY.ADDRESS2 ADDRESS_LINE2
, BANKPARTY.ADDRESS3 ADDRESS_LINE3
, BANKPARTY.ADDRESS4 ADDRESS_LINE4
, BANKPARTY.CITY CITY
, BANKPARTY.STATE STATE
, BANKPARTY.PROVINCE PROVINCE
, BANKPARTY.POSTAL_CODE ZIP
, BANKPARTY.COUNTRY COUNTRY
, BANKPARTY.MISSION_STATEMENT DESCRIPTION
, BANKUSG.PARTY_USAGE_CODE BANK_INSTITUTION_TYPE
, BANKPARTY.PARTY_ID
FROM HZ_PARTIES BANKPARTY
, HZ_PARTY_USG_ASSIGNMENTS BANKUSG
WHERE BANKUSG.PARTY_USAGE_CODE IN ('BANK'
, 'CLEARINGHOUSE')
AND BANKPARTY.PARTY_ID = BANKUSG.PARTY_ID

Columns

Name
ROW_ID
BANK_PARTY_ID
BANK_NAME
BANK_NAME_ALT
SHORT_BANK_NAME
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
STATE
PROVINCE
ZIP
COUNTRY
BANK_INSTITUTION_TYPE
DESCRIPTION
PK_ID