[Home] [Help]
[Dependency Information]
| Object Name: | XTR_DDA_EXPOSURES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XTR.XTR_DDA_EXPOSURES_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 | ||
| TRANSACTION_NUMBER | NUMBER | |||
| AMOUNT_DATE | DATE | |||
| CURRENCY | VARCHAR2 | (15) | Yes | |
| TYPE_OF_AMOUNT | VARCHAR2 | (7) | Yes | |
| USER_AMOUNT_TYPE | VARCHAR2 | (7) | ||
| AMOUNT | NUMBER | Yes | ||
| CASHFLOW_AMOUNT | NUMBER | |||
| COMPANY | VARCHAR2 | (7) | ||
| CPARTY | VARCHAR2 | (7) | ||
| CPARTY_NAME | VARCHAR2 | (20) | ||
| CLIENT | VARCHAR2 | (7) | ||
| CLIENT_NAME | VARCHAR2 | (20) | ||
| DEALER | VARCHAR2 | (10) | ||
| CONTRACT_TYPE | VARCHAR2 | (7) | Yes | |
| USER_DEAL_TYPE | VARCHAR2 | (7) | ||
| SUBTYPE | VARCHAR2 | (7) | ||
| USER_DEAL_SUBTYPE | VARCHAR2 | (7) | ||
| PRODUCT | VARCHAR2 | (10) | ||
| PORTFOLIO | VARCHAR2 | (7) | ||
| CODE_COMBINATION_ID | NUMBER | (15) | ||
| RATE | NUMBER | |||
| COMPANY_ACCOUNT | VARCHAR2 | (20) | ||
| HCE_AMOUNT | NUMBER | |||
| CONTRACT_STATUS | VARCHAR2 | (10) | ||
| USER_STATUS_CODE | VARCHAR2 | (10) | ||
| DIARY_NOTE_DETAILS | VARCHAR2 | (255) | ||
| AUTHORISED_BY | VARCHAR2 | (30) | ||
| AUTHORISED_ON | DATE | |||
| SETTLE | VARCHAR2 | (1) | ||
| CPARTY_ACCOUNT | VARCHAR2 | (20) | ||
| DIRECT_DEBIT | VARCHAR2 | (1) | ||
| CHQ_REQD | VARCHAR2 | (1) | ||
| COMMENTS | VARCHAR2 | (255) | ||
| ACTION_CODE | VARCHAR2 | (7) | ||
| USER_ACTION_CODE | VARCHAR2 | (7) | ||
| ATTACHMENT_EXISTS | VARCHAR2 | (1) | ||
| CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
| BENEFICIARY_PARTY | VARCHAR2 | (7) | ||
| BENEFICIARY_ACCOUNT | VARCHAR2 | (20) | ||
| BALANCE_SHEET_EXPOSURE | VARCHAR2 | (1) | ||
| EXPOSURE_REF_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NUMBER
, TRANSACTION_NUMBER
, AMOUNT_DATE
, CURRENCY
, TYPE_OF_AMOUNT
, USER_AMOUNT_TYPE
, AMOUNT
, CASHFLOW_AMOUNT
, COMPANY
, CPARTY
, CPARTY_NAME
, CLIENT
, CLIENT_NAME
, DEALER
, CONTRACT_TYPE
, USER_DEAL_TYPE
, SUBTYPE
, USER_DEAL_SUBTYPE
, PRODUCT
, PORTFOLIO
, CODE_COMBINATION_ID
, RATE
, COMPANY_ACCOUNT
, HCE_AMOUNT
, CONTRACT_STATUS
, USER_STATUS_CODE
, DIARY_NOTE_DETAILS
, AUTHORISED_BY
, AUTHORISED_ON
, SETTLE
, CPARTY_ACCOUNT
, DIRECT_DEBIT
, CHQ_REQD
, COMMENTS
, ACTION_CODE
, USER_ACTION_CODE
, ATTACHMENT_EXISTS
, CURRENCY_COMBINATION
, BENEFICIARY_PARTY
, BENEFICIARY_ACCOUNT
, BALANCE_SHEET_EXPOSURE
, EXPOSURE_REF_DATE
FROM APPS.XTR_DDA_EXPOSURES_V;
APPS
XTR_AMOUNT_ACTIONS
XTR_AMOUNT_TYPES
XTR_DEAL_DATE_AMOUNTS_V
XTR_DEAL_STATUSES
XTR_DEAL_SUBTYPES
XTR_DEAL_TYPES
XTR_PARTIES_V
XTR_USER_ACCESS
- show dependent code
APPS.XTR_DDA_EXPOSURES_V is not referenced by any database object
|
|
|
|