VIEW: XTR.XTR_DEAL_ORDERS#

Source

View Text - Preformatted

select ABOVE_OR_BELOW_LEVEL ABOVE_OR_BELOW_LEVEL, ADVICE_GROUP ADVICE_GROUP, AUDIT_INDICATOR AUDIT_INDICATOR, CCY_A_AMOUNT CCY_A_AMOUNT, CCY_B_AMOUNT CCY_B_AMOUNT, COMPANY_CODE COMPANY_CODE, CONFIRMED_BY_DEALER CONFIRMED_BY_DEALER, CPARTY_CODE CPARTY_CODE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CROSS_REF CROSS_REF, DEALER_COMPANY DEALER_COMPANY, DEALER_CPARTY DEALER_CPARTY, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, DETAILS_OF_ORDER DETAILS_OF_ORDER, GROUP_ACTION GROUP_ACTION, MARKET_RATE_WHEN_ENTERED MARKET_RATE_WHEN_ENTERED, ORDER_CCY_A ORDER_CCY_A, ORDER_CCY_B ORDER_CCY_B, ORDER_DELIVERY_DATE ORDER_DELIVERY_DATE, ORDER_GROUP ORDER_GROUP, ORDER_RATE ORDER_RATE, ORDER_TYPE ORDER_TYPE, PLACED_ON PLACED_ON, PRODUCT_TYPE PRODUCT_TYPE, RIC_CODE RIC_CODE, SOURCE SOURCE, STATUS_CODE STATUS_CODE, UNIQUE_REF_NUM UNIQUE_REF_NUM, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, VALID_UNTIL VALID_UNTIL from "XTR"."XTR_DEAL_ORDERS"

View Text - HTML Formatted

SELECT ABOVE_OR_BELOW_LEVEL ABOVE_OR_BELOW_LEVEL
, ADVICE_GROUP ADVICE_GROUP
, AUDIT_INDICATOR AUDIT_INDICATOR
, CCY_A_AMOUNT CCY_A_AMOUNT
, CCY_B_AMOUNT CCY_B_AMOUNT
, COMPANY_CODE COMPANY_CODE
, CONFIRMED_BY_DEALER CONFIRMED_BY_DEALER
, CPARTY_CODE CPARTY_CODE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CROSS_REF CROSS_REF
, DEALER_COMPANY DEALER_COMPANY
, DEALER_CPARTY DEALER_CPARTY
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, DETAILS_OF_ORDER DETAILS_OF_ORDER
, GROUP_ACTION GROUP_ACTION
, MARKET_RATE_WHEN_ENTERED MARKET_RATE_WHEN_ENTERED
, ORDER_CCY_A ORDER_CCY_A
, ORDER_CCY_B ORDER_CCY_B
, ORDER_DELIVERY_DATE ORDER_DELIVERY_DATE
, ORDER_GROUP ORDER_GROUP
, ORDER_RATE ORDER_RATE
, ORDER_TYPE ORDER_TYPE
, PLACED_ON PLACED_ON
, PRODUCT_TYPE PRODUCT_TYPE
, RIC_CODE RIC_CODE
, SOURCE SOURCE
, STATUS_CODE STATUS_CODE
, UNIQUE_REF_NUM UNIQUE_REF_NUM
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, VALID_UNTIL VALID_UNTIL
FROM "XTR"."XTR_DEAL_ORDERS"