FND Design Data [Home] [Help]

View: XTR_A_DEAL_ORDERS_V

Product: XTR - Treasury
Description:
Implementation/DBA Data: ViewAPPS.XTR_A_DEAL_ORDERS_V
View Text

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

Columns

Name
UNIQUE_REF_NUM
DEAL_TYPE
ORDER_TYPE
COMPANY_CODE
CPARTY_CODE
STATUS_CODE
PLACED_ON
VALID_UNTIL
CREATED_BY
CREATED_ON
DETAILS_OF_ORDER
CONFIRMED_BY_DEALER
DEAL_SUBTYPE
PRODUCT_TYPE
DEALER_COMPANY
DEALER_CPARTY
UPDATED_BY
UPDATED_ON
ORDER_RATE
ORDER_CCY_A
CCY_A_AMOUNT
ORDER_CCY_B
CCY_B_AMOUNT
ORDER_DELIVERY_DATE
SOURCE
RIC_CODE
ADVICE_GROUP
ORDER_GROUP
GROUP_ACTION
ABOVE_OR_BELOW_LEVEL
MARKET_RATE_WHEN_ENTERED
CROSS_REF
AUDIT_INDICATOR
AUDIT_DATE_STORED