VIEW: XTR.XTR_MIRROR_DDA_LIM_ROW_TMP#

Source

View Text - Preformatted

select ACCOUNT_NO ACCOUNT_NO, AMOUNT AMOUNT, AMOUNT_DATE AMOUNT_DATE, AMOUNT_INDIC AMOUNT_INDIC, COMMENCE_DATE COMMENCE_DATE, COMPANY_CODE COMPANY_CODE, CONTRA_CCY CONTRA_CCY, COUNTRY_CODE COUNTRY_CODE, CROSS_REF_TO_OTHER_PARTY CROSS_REF_TO_OTHER_PARTY, CURRENCY CURRENCY, CURRENCY_COMBINATION CURRENCY_COMBINATION, DATE_LAST_SET DATE_LAST_SET, DEALER_CODE DEALER_CODE, DEAL_NUMBER DEAL_NUMBER, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, HCE_AMOUNT HCE_AMOUNT, HCE_UTILISED_AMOUNT HCE_UTILISED_AMOUNT, LIMIT_CODE LIMIT_CODE, LIMIT_PARTY LIMIT_PARTY, LIMIT_TYPE LIMIT_TYPE, PORTFOLIO_CODE PORTFOLIO_CODE, PRODUCT_TYPE PRODUCT_TYPE, STATUS_CODE STATUS_CODE, TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANSACTION_RATE TRANSACTION_RATE, UTILISED_AMOUNT UTILISED_AMOUNT, BANK_ACCT_USE_ID BANK_ACCT_USE_ID from "XTR"."XTR_MIRROR_DDA_LIM_ROW_TMP"

View Text - HTML Formatted

SELECT ACCOUNT_NO ACCOUNT_NO
, AMOUNT AMOUNT
, AMOUNT_DATE AMOUNT_DATE
, AMOUNT_INDIC AMOUNT_INDIC
, COMMENCE_DATE COMMENCE_DATE
, COMPANY_CODE COMPANY_CODE
, CONTRA_CCY CONTRA_CCY
, COUNTRY_CODE COUNTRY_CODE
, CROSS_REF_TO_OTHER_PARTY CROSS_REF_TO_OTHER_PARTY
, CURRENCY CURRENCY
, CURRENCY_COMBINATION CURRENCY_COMBINATION
, DATE_LAST_SET DATE_LAST_SET
, DEALER_CODE DEALER_CODE
, DEAL_NUMBER DEAL_NUMBER
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, HCE_AMOUNT HCE_AMOUNT
, HCE_UTILISED_AMOUNT HCE_UTILISED_AMOUNT
, LIMIT_CODE LIMIT_CODE
, LIMIT_PARTY LIMIT_PARTY
, LIMIT_TYPE LIMIT_TYPE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRODUCT_TYPE PRODUCT_TYPE
, STATUS_CODE STATUS_CODE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANSACTION_RATE TRANSACTION_RATE
, UTILISED_AMOUNT UTILISED_AMOUNT
, BANK_ACCT_USE_ID BANK_ACCT_USE_ID
FROM "XTR"."XTR_MIRROR_DDA_LIM_ROW_TMP"