[Home] [Help] [Dependency Information]
Object Name: | XTR_DISC_DEALS_TRANSACTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_DISC_DEALS_TRANSACTIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The XTR_DISC_DEALS_TRANSACTIONS_V view contains information about the deals in the Oracle Treasury database and is similar to the QRM_CURRENT_DEALS_V view. The XTR_DISC_DEALS_TRANSACTIONS_V view contains current deals as well as deals with status other than cancelled.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_NO | NUMBER | Unique number assigned to each deal | ||
TRANSACTION_NO | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
MARKET_DATA_SET | VARCHAR2 | (30) | Refer to QRM_CURRENT_DEALS_V. | |
CALL_OR_PUT | VARCHAR2 | (5) | Refer to QRM_CURRENT_DEALS_V. | |
OPTION_STYLE | VARCHAR2 | (8) | Refer to QRM_CURRENT_DEALS_V. | |
ISSUER_CODE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
COMPANY_CODE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
DEALER_CODE | VARCHAR2 | (10) | Refer to QRM_CURRENT_DEALS_V. | |
CLIENT_CODE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
CPARTY_CODE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
LINK_CODE | VARCHAR2 | (8) | Refer to QRM_CURRENT_DEALS_V. | |
PRICING_MODEL | VARCHAR2 | (13) | Refer to QRM_CURRENT_DEALS_V. | |
DEAL_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
BUY_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
SELL_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
FOREIGN_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
DOMESTIC_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
BASE_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
CONTRA_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
SENSITIVITY_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
PREMIUM_CCY | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
BUY_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
SELL_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
FOREIGN_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
DOMESTIC_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
BASE_CCY_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
CONTRA_CCY_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
START_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
FACE_VALUE | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
INTEREST | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
ACCUM_INTEREST_BF | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
ACCUM_INT_ACTION | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
ACCRUED_INTEREST | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
INTEREST_SETTLED | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
DEAL_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
END_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
GAP_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
DEAL_TYPE | VARCHAR2 | (7) | Refer to QRM_CURRENT_DEALS_V. | |
DISCOUNT_YIELD | VARCHAR2 | (1) | Refer to QRM_CURRENT_DEALS_V. | |
EXPIRATION_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
MATURITY_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
NO_OF_DAYS | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
VALUE_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
SETTLE_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
PREMIUM_AMOUNT | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
PRODUCT_TYPE | VARCHAR2 | (10) | Refer to QRM_CURRENT_DEALS_V. | |
START_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
PHY_START_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
KNOCK_TYPE | VARCHAR2 | (10) | Refer to QRM_CURRENT_DEALS_V. | |
KNOCK_LEVEL | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
KNOCK_EXECUTE_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
INITIAL_BASIS | VARCHAR2 | (5) | Refer to QRM_CURRENT_DEALS_V. | |
INT_SWAP_REF | VARCHAR2 | (10) | Refer to QRM_CURRENT_DEALS_V. | |
INT_REF | VARCHAR2 | (20) | Refer to QRM_CURRENT_DEALS_V. | |
BOND_ISSUE_CODE | VARCHAR2 | (30) | Refer to QRM_CURRENT_DEALS_V. | |
SECURITY_ID | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
REF_SPOT_RATE | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
COUPON_ACTION | VARCHAR2 | (3) | Refer to QRM_CURRENT_DEALS_V. | |
COUPON_RATE | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
MARGIN | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
TRANSACTION_RATE | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
INTEREST_FREQUENCY | VARCHAR2 | (1) | Refer to QRM_CURRENT_DEALS_V. | |
COUPON_FREQUENCY | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
NEXT_COUPON_DATE | DATE | Refer to QRM_CURRENT_DEALS_V. | ||
DAY_COUNT_BASIS | VARCHAR2 | (15) | Refer to QRM_CURRENT_DEALS_V. | |
QUANTITY_REMAINING | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
QUANTITY_REMAINING_USD | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
QUANTITY_REMAINING_SOB | NUMBER | Refer to QRM_CURRENT_DEALS_V. | ||
ROUNDING_TYPE | VARCHAR2 | (1) | Code for interest rounding | |
DAY_COUNT_TYPE | VARCHAR2 | (1) | Code for interest includes | |
PREPAID_INTEREST | VARCHAR2 | (1) | Flag to indicate if the deal's interest was prepaid. | |
STATUS_CODE | VARCHAR2 | (10) | Refer to QRM_CURRENT_DEALS_V. | |
DEAL_TYPE_DESC | VARCHAR2 | (80) | Refer to QRM_CURRENT_DEALS_V. | |
DEAL_SUBTYPE_DESC | VARCHAR2 | (80) | Refer to QRM_CURRENT_DEALS_V. | |
PRODUCT_TYPE_DESC | VARCHAR2 | (80) | Refer to QRM_CURRENT_DEALS_V. | |
COMPANY_FULL_NAME | VARCHAR2 | (50) | Refer to QRM_CURRENT_DEALS_V. | |
CPARTY_FULL_NAME | VARCHAR2 | (50) | Refer to QRM_CURRENT_DEALS_V. |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NO
, TRANSACTION_NO
, MARKET_DATA_SET
, CALL_OR_PUT
, OPTION_STYLE
, ISSUER_CODE
, COMPANY_CODE
, DEALER_CODE
, CLIENT_CODE
, CPARTY_CODE
, PORTFOLIO_CODE
, LINK_CODE
, PRICING_MODEL
, DEAL_CCY
, BUY_CCY
, SELL_CCY
, FOREIGN_CCY
, DOMESTIC_CCY
, BASE_CCY
, CONTRA_CCY
, SENSITIVITY_CCY
, PREMIUM_CCY
, BUY_AMOUNT
, SELL_AMOUNT
, FOREIGN_AMOUNT
, DOMESTIC_AMOUNT
, BASE_CCY_AMOUNT
, CONTRA_CCY_AMOUNT
, START_AMOUNT
, FACE_VALUE
, INTEREST
, ACCUM_INTEREST_BF
, ACCUM_INT_ACTION
, ACCRUED_INTEREST
, INTEREST_SETTLED
, DEAL_DATE
, END_DATE
, GAP_DATE
, DEAL_SUBTYPE
, DEAL_TYPE
, DISCOUNT_YIELD
, EXPIRATION_DATE
, MATURITY_DATE
, NO_OF_DAYS
, VALUE_DATE
, SETTLE_DATE
, PREMIUM_AMOUNT
, PRODUCT_TYPE
, START_DATE
, PHY_START_DATE
, KNOCK_TYPE
, KNOCK_LEVEL
, KNOCK_EXECUTE_DATE
, INITIAL_BASIS
, INT_SWAP_REF
, INT_REF
, BOND_ISSUE_CODE
, SECURITY_ID
, REF_SPOT_RATE
, COUPON_ACTION
, COUPON_RATE
, MARGIN
, TRANSACTION_RATE
, INTEREST_FREQUENCY
, COUPON_FREQUENCY
, NEXT_COUPON_DATE
, DAY_COUNT_BASIS
, QUANTITY_REMAINING
, QUANTITY_REMAINING_USD
, QUANTITY_REMAINING_SOB
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PREPAID_INTEREST
, STATUS_CODE
, DEAL_TYPE_DESC
, DEAL_SUBTYPE_DESC
, PRODUCT_TYPE_DESC
, COMPANY_FULL_NAME
, CPARTY_FULL_NAME
FROM APPS.XTR_DISC_DEALS_TRANSACTIONS_V;
APPS.XTR_DISC_DEALS_TRANSACTIONS_V is not referenced by any database object
|
|
|