VIEW: APPS.IBY_EXT_BANK_BRANCHES_V

Source

View Text - Preformatted

SELECT cebranch.Branch_Party_Id Branch_Party_Id, cebranch.Country Home_Country, cebranch.Bank_Branch_Name Bank_Branch_Name, cebranch.Bank_Branch_Name_Alt Bank_Branch_Name_Alt, cebranch.Branch_Number Branch_Number, cebranch.Start_Date Start_Date, cebranch.End_Date End_Date, cebranch.Address_Line1 Address_Line1, cebranch.Address_Line2 Address_Line2, cebranch.Address_Line3 Address_Line3, cebranch.Address_Line4 Address_Line4, cebranch.city City, cebranch.state State, cebranch.province Province, cebranch.Zip Zip, cebranch.country Country, cebranch.Bank_Branch_Type Bank_Branch_Type, cebranch.Description Description, cebranch.EFT_Swift_Code eft_swift_code, cebranch.EFT_User_Number EFT_User_Number, cebranch.Bank_Party_Id bank_party_id, 1 CREATED_BY, sysdate CREATION_DATE, 1 LAST_UPDATED_BY, sysdate LAST_UPDATE_DATE, 1 LAST_UPDATE_LOGIN, 1 OBJECT_VERSION_NUMBER, 'Y' OPERATION_FLAG From ce_bank_branches_v cebranch

View Text - HTML Formatted

SELECT CEBRANCH.BRANCH_PARTY_ID BRANCH_PARTY_ID
, CEBRANCH.COUNTRY HOME_COUNTRY
, CEBRANCH.BANK_BRANCH_NAME BANK_BRANCH_NAME
, CEBRANCH.BANK_BRANCH_NAME_ALT BANK_BRANCH_NAME_ALT
, CEBRANCH.BRANCH_NUMBER BRANCH_NUMBER
, CEBRANCH.START_DATE START_DATE
, CEBRANCH.END_DATE END_DATE
, CEBRANCH.ADDRESS_LINE1 ADDRESS_LINE1
, CEBRANCH.ADDRESS_LINE2 ADDRESS_LINE2
, CEBRANCH.ADDRESS_LINE3 ADDRESS_LINE3
, CEBRANCH.ADDRESS_LINE4 ADDRESS_LINE4
, CEBRANCH.CITY CITY
, CEBRANCH.STATE STATE
, CEBRANCH.PROVINCE PROVINCE
, CEBRANCH.ZIP ZIP
, CEBRANCH.COUNTRY COUNTRY
, CEBRANCH.BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, CEBRANCH.DESCRIPTION DESCRIPTION
, CEBRANCH.EFT_SWIFT_CODE EFT_SWIFT_CODE
, CEBRANCH.EFT_USER_NUMBER EFT_USER_NUMBER
, CEBRANCH.BANK_PARTY_ID BANK_PARTY_ID
, 1 CREATED_BY
, SYSDATE CREATION_DATE
, 1 LAST_UPDATED_BY
, SYSDATE LAST_UPDATE_DATE
, 1 LAST_UPDATE_LOGIN
, 1 OBJECT_VERSION_NUMBER
, 'Y' OPERATION_FLAG
FROM CE_BANK_BRANCHES_V CEBRANCH