[Home] [Help] [Dependency Information]
Object Name: | XTR_QUICK_INPUT_DEALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_QUICK_INPUT_DEALS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUOTE_NO | NUMBER | Yes | Number identifier of the quote received from a counterparty for the quick input deal | |
DEAL_NO | NUMBER | Unique number assigned to each deal | ||
TRANSACTION_NUMBER | NUMBER | Unique reference number assigned to a transaction | ||
COMPANY_CODE | VARCHAR2 | (7) | Company code | |
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
CLIENT_CODE | VARCHAR2 | (7) | Client for which the deal is made | |
DEAL_TYPE | VARCHAR2 | (7) | Code for high level deals | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
ISSUE_CODE | VARCHAR2 | (7) | Not currently used | |
CURRENCY1 | VARCHAR2 | (15) | Buy currency for foreign exchange deals | |
CURRENCY2 | VARCHAR2 | (15) | Sell currency for foreign exchange deals | |
TRANSACTION_RATE | NUMBER | Transaction rate for the quick deal | ||
FX_SWAP_RATE | NUMBER | Foreign exchange swap rate | ||
AMOUNT_TYPE | VARCHAR2 | (7) | Code that identifies the purpose of the amounts for a deal type | |
BASE_AMOUNT | NUMBER | Amount of deal | ||
DEAL_DATE | DATE | Date the deal is made | ||
VALUE_DATE | DATE | Date quick deal takes place | ||
MATURITY_DATE | DATE | Date the deal matures or an action is required | ||
DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users | |
CREATED_BY | VARCHAR2 | (30) | User who created this record | |
CREATED_ON | DATE | Date this record was created | ||
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
FULL_INPUT_COMPLETED | VARCHAR2 | (1) | Flag to determine if all details have been entered in a quick input deal (Y), or not (N) | |
STATUS_CODE | VARCHAR2 | (10) | Code for the execution status of deals and transactions | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
PUT_CALL | VARCHAR2 | (1) | Not currently used | |
PREMIUM_AMOUNT | NUMBER | Not currently used | ||
YEAR_CALC_TYPE | VARCHAR2 | (15) | Not currently used | |
ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
DAY_COUNT_TYPE | VARCHAR2 | (1) | Not currently used | |
PREPAID_INTEREST | VARCHAR2 | (1) | Identify whether it is a prepaid interest deal |
Cut, paste (and edit) the following text to query this object:
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 APPS.XTR_QUICK_INPUT_DEALS_V;
APPS.XTR_QUICK_INPUT_DEALS_V is not referenced by any database object
|
|
|