1. Tables and Views for Financials
  2. CE_BANKS_V

CE_BANKS_V

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: VIEW

Columns

Name

ROW_ID

HOME_COUNTRY

BANK_PARTY_ID

BANK_NAME

BANK_PARTY_NUMBER

BANK_NAME_ALT

SHORT_BANK_NAME

BANK_NUMBER

START_DATE

END_DATE

ADDRESS_LINE1

ADDRESS_LINE2

ADDRESS_LINE3

ADDRESS_LINE4

CITY

STATE

PROVINCE

ZIP

COUNTRY

BANK_INSTITUTION_TYPE

DESCRIPTION

PK_ID

SITE_ADDRESS_LINE1

SITE_ADDRESS_LINE2

SITE_ADDRESS_LINE3

SITE_ADDRESS_LINE4

SITE_CITY

SITE_STATE

SITE_COUNTY

SITE_ZIP

SITE_COUNTRY

SITE_PROVINCE

SITE_LOCATION_ID

TAXPAYER_ID

TAX_REGISTRATION_NUMBER

BANK_ADMIN_EMAIL

COUNTRY_NAME

REQUEST_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

CBANK.ROWID ROW_ID,

CBANK.Home_Country_Code Home_Country,

CBANK.Bank_Party_Id,

CBANK.Bank_Name,

CBANK.BANK_PARTY_NUMBER,

CBANK.Bank_Name_Alt,

NULL Short_Bank_Name,

CBANK.Bank_Number,

CBANK.Start_Date,

CBANK.End_Date,

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,

CBANK.Bank_Institution_Type,

BankParty.mission_statement Description,

CBANK.Bank_Party_Id PK_ID,

BankParty.ADDRESS1 SITE_ADDRESS_LINE1,

BankParty.ADDRESS2 SITE_ADDRESS_LINE2,

BankParty.ADDRESS3 SITE_ADDRESS_LINE3,

BankParty.ADDRESS4 SITE_ADDRESS_LINE4,

BankParty.CITY SITE_CITY,

BankParty.STATE SITE_STATE,

BankParty.COUNTY SITE_COUNTY,

BankParty.POSTAL_CODE SITE_ZIP,

BankParty.COUNTRY SITE_COUNTRY,

BankParty.PROVINCE SITE_PROVINCE,

BankParty.IDEN_ADDR_LOCATION_ID SITE_LOCATION_ID,

BankParty.jgzz_fiscal_code taxpayer_id,

PTP.REP_REGISTRATION_NUMBER tax_registration_number,

BankParty.email_address bank_admin_email,

FT.TERRITORY_SHORT_NAME COUNTRY_NAME,

CBANK.REQUEST_ID REQUEST_ID,

BankParty.LAST_UPDATE_DATE,

BankParty.LAST_UPDATED_BY,

BankParty.LAST_UPDATE_LOGIN,

BankParty.CREATED_BY,

BankParty.CREATION_DATE,

BankParty.OBJECT_VERSION_NUMBER

From CE_INDEX_BANKS CBANK,

HZ_PARTIES BankParty,

ZX_PARTY_TAX_PROFILE PTP,

FND_TERRITORIES_VL FT

Where CBANK.BANK_PARTY_ID = BankParty.PARTY_ID

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

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

And CBANK.Bank_Institution_Type in ('BANK', 'CLEARINGHOUSE')

and BankParty.PARTY_TYPE = 'ORGANIZATION'

AND PTP.PARTY_ID(+) = BANKPARTY.PARTY_ID

AND PTP.PARTY_TYPE_CODE(+) = 'THIRD_PARTY'

AND CBANK.Home_Country_Code = FT.TERRITORY_CODE