VIEW: APPS.CE_BANKS_MERGE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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