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_BANK_BRANCHES_MERGE_V

Product:	CE - Cash Management
Description:	Bank branches
Implementation/DBA Data:	APPS.CE_BANK_BRANCHES_MERGE_V

View Text

SELECT BRANCHPARTY.ROWID ROW_ID
, BRANCHPARTY.PARTY_ID BRANCH_PARTY_ID
, BRANCHPARTY.PARTY_NAME BANK_BRANCH_NAME
, BRANCHPARTY.ORGANIZATION_NAME_PHONETIC BANK_BRANCH_NAME_ALT
, BRANCHPARTY.ADDRESS1 ADDRESS_LINE1
, BRANCHPARTY.ADDRESS2 ADDRESS_LINE2
, BRANCHPARTY.ADDRESS3 ADDRESS_LINE3
, BRANCHPARTY.ADDRESS4 ADDRESS_LINE4
, BRANCHPARTY.CITY CITY
, BRANCHPARTY.STATE STATE
, BRANCHPARTY.PROVINCE PROVINCE
, BRANCHPARTY.POSTAL_CODE ZIP
, BRANCHPARTY.COUNTRY COUNTRY
, BRANCHPARTY.MISSION_STATEMENT DESCRIPTION
, BRANCHUSG.PARTY_USAGE_CODE BANK_BRANCH_TYPE
, BRANCHPARTY.PARTY_ID
FROM HZ_PARTIES BRANCHPARTY
, HZ_PARTY_USG_ASSIGNMENTS BRANCHUSG
WHERE BRANCHUSG.PARTY_USAGE_CODE IN ('BANK_BRANCH'
, 'CLEARINGHOUSE_BRANCH')
AND BRANCHPARTY.PARTY_ID = BRANCHUSG.PARTY_ID

Columns

Name
ROW_ID
BRANCH_PARTY_ID
BANK_BRANCH_NAME
BANK_BRANCH_NAME_ALT
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
STATE
PROVINCE
ZIP
COUNTRY
DESCRIPTION
BANK_BRANCH_TYPE
PK_ID