CE_BANK_BRANCHES_MERGE_V

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

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

Query

SQL_Statement

SELECT BranchParty.ROWID ROW_ID, BranchParty.PARTY_ID Branch_Party_Id, BranchParty.PARTY_NAME Bank_Branch_Name, BranchAddName.PARTY_NAME 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 PK_ID From HZ_PARTIES BranchParty, HZ_PARTY_USG_ASSIGNMENTS BranchUsg, HZ_ADDTNL_PARTY_NAMES BranchAddName Where BranchUsg.PARTY_USAGE_CODE in ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH' , 'EMPLOYEE_BANK_BRANCH' , 'CUSTOMER_BANK_BRANCH', 'SUPPLIER_BANK_BRANCH' , 'ADHOC_PAYEE_BANK_BRANCH') And BranchParty.PARTY_ID = BranchUsg.PARTY_ID and BranchParty.PARTY_ID = BranchAddName.PARTY_ID (+) and BranchAddName.PARTY_NAME_TYPE (+) = 'PHONETIC'