[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_DDA_EXPOSURES_V is not referenced by any database object
|
|
|