1. Tables and Views for Financials
  2. CE_ALL_BANKS_SIMPLE_V

CE_ALL_BANKS_SIMPLE_V

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: VIEW

Columns

Name

ROW_ID

HOME_COUNTRY

BANK_PARTY_ID

BANK_NAME

BANK_NAME_ALT

BANK_NUMBER

BANK_PARTY_NUMBER

START_DATE

END_DATE

BANK_INSTITUTION_TYPE

TAXPAYER_ID

COUNTRY_NAME

Query

SQL_Statement

SELECT

CBANK.ROWID ROW_ID,

CBANK.Home_Country_code Home_Country,

CBANK.Bank_Party_Id,

decode(CBANK.Bank_Institution_Type, 'BANK', CBANK.Bank_Name,

decode(CBANK.Bank_Name, 'CE_EMP_UNSPECIFIED_BANK', null, CBANK.Bank_Name) ) Bank_Name,

CBANK.Bank_Name_Alt,

CBANK.Bank_Number,

CBANK.BANK_PARTY_NUMBER,

CBANK.Start_Date,

CBANK.End_Date,

CBANK.Bank_Institution_Type,

CBANK.TAXPAYER_ID_NUMBER taxpayer_id,

FT.TERRITORY_SHORT_NAME COUNTRY_NAME

FROM

CE_INDEX_BANKS CBANK,

FND_TERRITORIES_VL FT

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

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

And CBANK.Bank_Institution_Type in ('BANK', 'CLEARINGHOUSE', 'EMPLOYEE_BANK' , 'CUSTOMER_BANK', 'SUPPLIER_BANK', 'ADHOC_PAYEE_BANK' )

AND CBANK.Home_Country_code = FT.TERRITORY_CODE