CE_BANKS_MERGE_V

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

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 DESCRIPTION BANK_INSTITUTION_TYPE PK_ID

Query

SQL_Statement

SELECT BankParty.ROWID ROW_ID, BankParty.PARTY_ID Bank_Party_Id, BankParty.PARTY_NAME Bank_Name, BankAddNamePhonetic.PARTY_NAME Bank_Name_Alt, BankAddNameAlias.PARTY_NAME 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 PK_ID From HZ_PARTIES BankParty, HZ_PARTY_USG_ASSIGNMENTS BankUsg, HZ_ADDTNL_PARTY_NAMES BankAddNamePhonetic, HZ_ADDTNL_PARTY_NAMES BankAddNameAlias Where BankUsg.PARTY_USAGE_CODE in ('BANK', 'CLEARINGHOUSE' , 'EMPLOYEE_BANK' , 'CUSTOMER_BANK', 'SUPPLIER_BANK', 'ADHOC_PAYEE_BANK' ) And BankParty.PARTY_ID = BankUsg.PARTY_ID and BankParty.PARTY_ID = BankAddNamePhonetic.PARTY_ID (+) and BankAddNamePhonetic.PARTY_NAME_TYPE (+) = 'PHONETIC' and BankParty.PARTY_ID = BankAddNameAlias.PARTY_ID (+) and BankAddNameAlias.PARTY_NAME_TYPE (+) = 'ALIAS'