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.

VIEW: APPS.CE_BANK_BRANCHES_MERGE_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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