[Home] [Help] [Dependency Information]
Object Name: | XTR_MIRROR_DDA_LIM_ROW_TMP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_MIRROR_DDA_LIM_ROW_TMP_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_NUMBER | NUMBER | Yes | ||
DEAL_TYPE | VARCHAR2 | (7) | Yes | |
TRANSACTION_NUMBER | NUMBER | Yes | ||
LIMIT_CODE | VARCHAR2 | (7) | ||
AMOUNT | NUMBER | Yes | ||
HCE_AMOUNT | NUMBER | Yes | ||
DATE_LAST_SET | DATE | Yes | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
COMPANY_CODE | VARCHAR2 | (7) | ||
LIMIT_PARTY | VARCHAR2 | (7) | ||
AMOUNT_DATE | DATE | |||
DEALER_CODE | VARCHAR2 | (10) | ||
COUNTRY_CODE | VARCHAR2 | (2) | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
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) | ||
COMMENCE_DATE | DATE | |||
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
, TRANSACTION_NUMBER
, LIMIT_CODE
, AMOUNT
, HCE_AMOUNT
, DATE_LAST_SET
, PRODUCT_TYPE
, COMPANY_CODE
, LIMIT_PARTY
, AMOUNT_DATE
, DEALER_CODE
, COUNTRY_CODE
, DEAL_SUBTYPE
, PORTFOLIO_CODE
, STATUS_CODE
, CURRENCY
, UTILISED_AMOUNT
, HCE_UTILISED_AMOUNT
, CROSS_REF_TO_OTHER_PARTY
, LIMIT_TYPE
, COMMENCE_DATE
, CURRENCY_COMBINATION
, CONTRA_CCY
, TRANSACTION_RATE
, AMOUNT_INDIC
, ACCOUNT_NO
FROM APPS.XTR_MIRROR_DDA_LIM_ROW_TMP_V;
|
|
|