[Home] [Help]
View: 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 |