VIEW: XTR.XTR_QUICK_INPUT_DEALS#

Source

View Text - Preformatted

select AMOUNT_TYPE AMOUNT_TYPE, BASE_AMOUNT BASE_AMOUNT, CLIENT_CODE CLIENT_CODE, COMPANY_CODE COMPANY_CODE, CPARTY_CODE CPARTY_CODE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY1 CURRENCY1, CURRENCY2 CURRENCY2, DEALER_CODE DEALER_CODE, DEAL_DATE DEAL_DATE, DEAL_NO DEAL_NO, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, FULL_INPUT_COMPLETED FULL_INPUT_COMPLETED, FX_SWAP_RATE FX_SWAP_RATE, ISSUE_CODE ISSUE_CODE, MATURITY_DATE MATURITY_DATE, PORTFOLIO_CODE PORTFOLIO_CODE, PREMIUM_AMOUNT PREMIUM_AMOUNT, PRODUCT_TYPE PRODUCT_TYPE, PUT_CALL PUT_CALL, QUOTE_NO QUOTE_NO, STATUS_CODE STATUS_CODE, TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANSACTION_RATE TRANSACTION_RATE, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, VALUE_DATE VALUE_DATE, YEAR_CALC_TYPE YEAR_CALC_TYPE, ROUNDING_TYPE ROUNDING_TYPE, DAY_COUNT_TYPE DAY_COUNT_TYPE, PREPAID_INTEREST PREPAID_INTEREST from "XTR"."XTR_QUICK_INPUT_DEALS"

View Text - HTML Formatted

SELECT AMOUNT_TYPE AMOUNT_TYPE
, BASE_AMOUNT BASE_AMOUNT
, CLIENT_CODE CLIENT_CODE
, COMPANY_CODE COMPANY_CODE
, CPARTY_CODE CPARTY_CODE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY1 CURRENCY1
, CURRENCY2 CURRENCY2
, DEALER_CODE DEALER_CODE
, DEAL_DATE DEAL_DATE
, DEAL_NO DEAL_NO
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, FULL_INPUT_COMPLETED FULL_INPUT_COMPLETED
, FX_SWAP_RATE FX_SWAP_RATE
, ISSUE_CODE ISSUE_CODE
, MATURITY_DATE MATURITY_DATE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PREMIUM_AMOUNT PREMIUM_AMOUNT
, PRODUCT_TYPE PRODUCT_TYPE
, PUT_CALL PUT_CALL
, QUOTE_NO QUOTE_NO
, STATUS_CODE STATUS_CODE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANSACTION_RATE TRANSACTION_RATE
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, VALUE_DATE VALUE_DATE
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, ROUNDING_TYPE ROUNDING_TYPE
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, PREPAID_INTEREST PREPAID_INTEREST
FROM "XTR"."XTR_QUICK_INPUT_DEALS"