VIEW: XTR.XTR_COST_OF_FUNDS#

Source

View Text - Preformatted

select ACCOUNT_NO ACCOUNT_NO, AS_AT_DATE AS_AT_DATE, AVG_INTEREST_RATE AVG_INTEREST_RATE, COMMENCE_DATE COMMENCE_DATE, COMPANY_CODE COMPANY_CODE, CONTRA_CCY CONTRA_CCY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, CURRENCY_COMBINATION CURRENCY_COMBINATION, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, GROSS_PRINCIPAL GROSS_PRINCIPAL, HCE_GROSS_PRINCIPAL HCE_GROSS_PRINCIPAL, HCE_INTEREST HCE_INTEREST, INTEREST INTEREST, NO_OF_DAYS NO_OF_DAYS, NO_OF_DEALS NO_OF_DEALS, PARTY_CODE PARTY_CODE, PORTFOLIO_CODE PORTFOLIO_CODE, PRODUCT_TYPE PRODUCT_TYPE, WEIGHTED_AVG_PRINCIPAL WEIGHTED_AVG_PRINCIPAL, AVG_BASE_RATE AVG_BASE_RATE, BASE_WEIGHTED_AVG_PRINCIPAL BASE_WEIGHTED_AVG_PRINCIPAL, GROSS_BASE_AMOUNT GROSS_BASE_AMOUNT, GROSS_CONTRA_TRANS_AMOUNT GROSS_CONTRA_TRANS_AMOUNT, GROSS_CONTRA_SPOT_AMOUNT GROSS_CONTRA_SPOT_AMOUNT from "XTR"."XTR_COST_OF_FUNDS"

View Text - HTML Formatted

SELECT ACCOUNT_NO ACCOUNT_NO
, AS_AT_DATE AS_AT_DATE
, AVG_INTEREST_RATE AVG_INTEREST_RATE
, COMMENCE_DATE COMMENCE_DATE
, COMPANY_CODE COMPANY_CODE
, CONTRA_CCY CONTRA_CCY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, CURRENCY_COMBINATION CURRENCY_COMBINATION
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, GROSS_PRINCIPAL GROSS_PRINCIPAL
, HCE_GROSS_PRINCIPAL HCE_GROSS_PRINCIPAL
, HCE_INTEREST HCE_INTEREST
, INTEREST INTEREST
, NO_OF_DAYS NO_OF_DAYS
, NO_OF_DEALS NO_OF_DEALS
, PARTY_CODE PARTY_CODE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRODUCT_TYPE PRODUCT_TYPE
, WEIGHTED_AVG_PRINCIPAL WEIGHTED_AVG_PRINCIPAL
, AVG_BASE_RATE AVG_BASE_RATE
, BASE_WEIGHTED_AVG_PRINCIPAL BASE_WEIGHTED_AVG_PRINCIPAL
, GROSS_BASE_AMOUNT GROSS_BASE_AMOUNT
, GROSS_CONTRA_TRANS_AMOUNT GROSS_CONTRA_TRANS_AMOUNT
, GROSS_CONTRA_SPOT_AMOUNT GROSS_CONTRA_SPOT_AMOUNT
FROM "XTR"."XTR_COST_OF_FUNDS"