[Home] [Help]
View: XTR_QUICK_INPUT_DEALS_V
Product: | XTR - Treasury |
Description: | This table is designed to store the tolerance setup for the override feature |
Implementation/DBA Data: |
APPS.XTR_QUICK_INPUT_DEALS_V
|
View Text
SELECT QUOTE_NO
, DEAL_NO
, TRANSACTION_NUMBER
, COMPANY_CODE
, CPARTY_CODE
, CLIENT_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
, ISSUE_CODE
, CURRENCY1
, CURRENCY2
, TRANSACTION_RATE
, FX_SWAP_RATE
, AMOUNT_TYPE
, BASE_AMOUNT
, DEAL_DATE
, VALUE_DATE
, MATURITY_DATE
, DEALER_CODE
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, FULL_INPUT_COMPLETED
, STATUS_CODE
, PORTFOLIO_CODE
, PUT_CALL
, PREMIUM_AMOUNT
, YEAR_CALC_TYPE
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PREPAID_INTEREST
FROM XTR_QUICK_INPUT_DEALS
Columns
Name |
QUOTE_NO |
DEAL_NO |
TRANSACTION_NUMBER |
COMPANY_CODE |
CPARTY_CODE |
CLIENT_CODE |
DEAL_TYPE |
DEAL_SUBTYPE |
PRODUCT_TYPE |
ISSUE_CODE |
CURRENCY1 |
CURRENCY2 |
TRANSACTION_RATE |
FX_SWAP_RATE |
AMOUNT_TYPE |
BASE_AMOUNT |
DEAL_DATE |
VALUE_DATE |
MATURITY_DATE |
DEALER_CODE |
CREATED_BY |
CREATED_ON |
UPDATED_BY |
UPDATED_ON |
FULL_INPUT_COMPLETED |
STATUS_CODE |
PORTFOLIO_CODE |
PUT_CALL |
PREMIUM_AMOUNT |
YEAR_CALC_TYPE |
ROUNDING_TYPE |
DAY_COUNT_TYPE |
PREPAID_INTEREST |