[Home] [Help] [Dependency Information]
Object Name: | XTR_BIS_MIRROR_DDA_LIMIT_ROW_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view contains detailed deal information. It is used when you drill down from the Net Positions inquiry to see the details of the deals that make up the net position information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_NUMBER | NUMBER | Yes | Unique number assigned to each deal | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
USER_DEAL_TYPE | VARCHAR2 | (7) | Yes | User-defined deal type code |
TRANSACTION_NUMBER | NUMBER | Yes | Unique reference number assigned to a transaction | |
LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
AMOUNT | NUMBER | Yes | Transaction amount | |
HCE_AMOUNT | NUMBER | Yes | Amount in reporting currency equivalent | |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
COMPANY_CODE | VARCHAR2 | (7) | Company code | |
SHORT_NAME | VARCHAR2 | (20) | Yes | |
LIMIT_PARTY | VARCHAR2 | (7) | ||
AMOUNT_DATE | DATE | |||
DEALER_CODE | VARCHAR2 | (10) | ||
COUNTRY_CODE | VARCHAR2 | (2) | ||
TERRITORY_SHORT_NAME | VARCHAR2 | (80) | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
USER_DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | |
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
STATUS_CODE | VARCHAR2 | (10) | ||
CURRENCY | VARCHAR2 | (15) | ||
UTILISED_AMOUNT | NUMBER | |||
HCE_UTILISED_AMOUNT | NUMBER | |||
CROSS_REF_TO_OTHER_PARTY | VARCHAR2 | (7) | ||
LIMIT_TYPE | VARCHAR2 | (2) | ||
CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
CONTRA_CCY | VARCHAR2 | (15) | ||
TRANSACTION_RATE | NUMBER | |||
AMOUNT_INDIC | NUMBER | |||
ACCOUNT_NO | VARCHAR2 | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NUMBER
, DEAL_TYPE
, USER_DEAL_TYPE
, TRANSACTION_NUMBER
, LIMIT_CODE
, AMOUNT
, HCE_AMOUNT
, PRODUCT_TYPE
, COMPANY_CODE
, SHORT_NAME
, LIMIT_PARTY
, AMOUNT_DATE
, DEALER_CODE
, COUNTRY_CODE
, TERRITORY_SHORT_NAME
, DEAL_SUBTYPE
, USER_DEAL_SUBTYPE
, PORTFOLIO_CODE
, STATUS_CODE
, CURRENCY
, UTILISED_AMOUNT
, HCE_UTILISED_AMOUNT
, CROSS_REF_TO_OTHER_PARTY
, LIMIT_TYPE
, CURRENCY_COMBINATION
, CONTRA_CCY
, TRANSACTION_RATE
, AMOUNT_INDIC
, ACCOUNT_NO
FROM APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V;
APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V is not referenced by any database object
|
|
|