DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.XTR_DDA_EXPOSURES_V

Object Details
Object Name: XTR_DDA_EXPOSURES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_DDA_EXPOSURES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.XTR_DDA_EXPOSURES_V references the following:

SchemaAPPS
SynonymXTR_AMOUNT_ACTIONS
SynonymXTR_AMOUNT_TYPES
ViewXTR_DEAL_DATE_AMOUNTS_V
SynonymXTR_DEAL_STATUSES
SynonymXTR_DEAL_SUBTYPES
SynonymXTR_DEAL_TYPES
ViewXTR_PARTIES_V
PL/SQL PackageXTR_USER_ACCESS - show dependent code

APPS.XTR_DDA_EXPOSURES_V is not referenced by any database object