eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IBY_EXT_BANKS_V

Source

View Text - Preformatted


SELECT CEBank.Bank_Party_Id Bank_Party_Id, CEBank.HOME_COUNTRY Home_Country, CEBank.BANK_NAME Bank_Name, CEBank.Bank_Number Bank_Number, CEBank.Bank_Institution_Type Bank_Institution_Type, CEBank.Bank_Name_Alt Bank_Name_Alt, CEBank.short_bank_name Short_Bank_Name, CEBank.description Description, CEBank.end_date End_Date, CEBank.ADDRESS_line1 Address1, CEBank.ADDRESS_line2 Address2, CEBank.ADDRESS_line3 Address3, CEBank.City City, CEBank.State State, CEBank.zip Zipcode, CEBank.country Country, 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, SITE_LOCATION_ID SITE_LOCATION_ID, CEBANK.TAX_PAYER_ID TAX_PAYER_ID from ce_banks_v cebank

View Text - HTML Formatted

SELECT CEBANK.BANK_PARTY_ID BANK_PARTY_ID
, CEBANK.HOME_COUNTRY HOME_COUNTRY
, CEBANK.BANK_NAME BANK_NAME
, CEBANK.BANK_NUMBER BANK_NUMBER
, CEBANK.BANK_INSTITUTION_TYPE BANK_INSTITUTION_TYPE
, CEBANK.BANK_NAME_ALT BANK_NAME_ALT
, CEBANK.SHORT_BANK_NAME SHORT_BANK_NAME
, CEBANK.DESCRIPTION DESCRIPTION
, CEBANK.END_DATE END_DATE
, CEBANK.ADDRESS_LINE1 ADDRESS1
, CEBANK.ADDRESS_LINE2 ADDRESS2
, CEBANK.ADDRESS_LINE3 ADDRESS3
, CEBANK.CITY CITY
, CEBANK.STATE STATE
, CEBANK.ZIP ZIPCODE
, CEBANK.COUNTRY COUNTRY
, 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
, SITE_LOCATION_ID SITE_LOCATION_ID
, CEBANK.TAX_PAYER_ID TAX_PAYER_ID
FROM CE_BANKS_V CEBANK