CE_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, CBANK.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') AND CBANK.Home_Country_Code = FT.TERRITORY_CODE |