[Home] [Help]
| Product: | XTR - Treasury |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.XTR_DEAL_ORDERS_V
|
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
, AUDIT_INDICATOR
, 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
FROM XTR_DEAL_ORDERS