1. Tables and Views for Financials
  2. CE_BANK_BRANCHES_SIMPLE_V

CE_BANK_BRANCHES_SIMPLE_V

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: VIEW

Columns

Name

ROW_ID

BANK_HOME_COUNTRY

BANK_PARTY_ID

BANK_PARTY_NUMBER

BANK_NAME

BANK_NUMBER

BRANCH_PARTY_ID

BANK_BRANCH_NAME

BRANCH_NUMBER

BRANCH_PARTY_NUMBER

COUNTRY

PK_ID

COUNTRY_NAME

EFT_SWIFT_CODE

Query

SQL_Statement

SELECT

CBRANCH.ROWID ROW_ID,

CBRANCH.HOME_COUNTRY_CODE Bank_Home_Country,

CBANK.BANK_PARTY_ID Bank_Party_Id,

CBANK.BANK_PARTY_NUMBER,

CBANK.BANK_NAME Bank_Name,

CBANK.Bank_Number,

CBRANCH.BRANCH_PARTY_ID Branch_Party_Id,

CBRANCH.BANK_BRANCH_NAME Bank_Branch_Name,

CBRANCH.BRANCH_NUMBER,

CBRANCH.BRANCH_PARTY_NUMBER,

CBRANCH.HOME_COUNTRY_CODE Country,

CBRANCH.BRANCH_PARTY_ID PK_ID,

FT.TERRITORY_SHORT_NAME COUNTRY_NAME,

CBRANCH.EFT_Swift_Code

FROM CE_INDEX_BANK_BRANCHES CBRANCH,

CE_INDEX_BANKS CBANK,

FND_TERRITORIES_VL FT

WHERE

CBRANCH.BRANCH_INSTITUTION_TYPE ='BANK_BRANCH'

And trunc(SYSDATE) between TRUNC(CBRANCH.start_date)

and NVL(TRUNC(CBRANCH.end_date), SYSDATE+1)

AND CBRANCH.BANK_PARTY_ID = CBANK.BANK_PARTY_ID

And trunc(SYSDATE) between TRUNC(CBANK.start_date)

and NVL(TRUNC(CBANK.end_date), SYSDATE+1)

And CBANK.Bank_Institution_Type = 'BANK'

AND CBRANCH.HOME_COUNTRY_CODE = FT.TERRITORY_CODE