[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_A_DEAL_DATE_AMOUNTS_V

Object Details

Object Name:	XTR_A_DEAL_DATE_AMOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_A_DEAL_DATE_AMOUNTS_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

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT DEAL_TYPE
,      AMOUNT_TYPE
,      DATE_TYPE
,      DEAL_NUMBER
,      TRANSACTION_DATE
,      CURRENCY
,      AMOUNT
,      HCE_AMOUNT
,      AMOUNT_DATE
,      TRANSACTION_RATE
,      CASHFLOW_AMOUNT
,      COMPANY_CODE
,      ACCOUNT_NO
,      CPARTY_ACCOUNT_NO
,      CHQ_REQD
,      ACTION_CODE
,      TRANSACTION_NUMBER
,      JOURNAL_CREATED
,      DIARY_NOTE
,      AUTHORISED
,      DIRECT_DEBIT
,      TRANS_MTS
,      SETTLE
,      DEAL_SUBTYPE
,      PRODUCT_TYPE
,      LIMIT_CODE
,      STATUS_CODE
,      CLIENT_CODE
,      CPARTY_CODE
,      PORTFOLIO_CODE
,      DIARY_CREATED_BY
,      DEAL_ORDERS
,      DEALER_CODE
,      DUAL_AUTHORISATION_BY
,      MULTIPLE_SETTLEMENTS
,      MULTIPLE_REFERENCE_NUMBER
,      SETTLEMENT_NUMBER
,      SETTLEMENT_AUTHORISED_BY
,      SETTLEMENT_PARTY
,      COMMENTS
,      CODE_COMBINATION_ID
,      CLIENT_BROKER_CLRACCT
,      EXP_SETTLE_REQD
,      LIMIT_PARTY
,      DUAL_AUTHORISATION_ON
,      ARCHIVE_DATE
,      ARCHIVE_BY
,      CONTRACT_CODE
,      NETOFF_NUMBER
,      BENEFICIARY_PARTY
,      UPDATED_BY
,      UPDATED_ON
,      RECONCILED_PASS_CODE
,      RECONCILED_REFERENCE
,      RECONCILED_DAYS_ADJUST
,      SERIAL_REFERENCE
,      BENEFICIARY_ACCOUNT_NO
,      FIRST_ACCRUAL
,      ACCRUAL_FROM
,      ACCRUAL_TO
,      FRA_DESCRIPTION
,      GENERAL_OR_PRIVATE_ACCESS
,      CURRENCY_COMBINATION
,      ACTUAL_SETTLEMENT_DATE
,      GOOD_VALUE_CLAIM
,      NETOFF_GROUP_FLAG
,      SETTLEMENT_ACTIONED
,      SETTLEMENT_ACTIONED_FILE
,      QUICK_INPUT
,      EXTERNAL_COMMENTS
,      EXPOSURE_REF_DATE
,      ATTACHMENT_EXISTS
,      COMMENCE_DATE
,      PRINTED_MATURITY_YN
,      BALANCE_SHEET_EXPOSURE
,      ACTION_COMPLETED
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
,      ORIGINAL_SETTLEMENT_CURRENCY
,      ORIGINAL_SETTLEMENT_AMOUNT
,      COMPANY_HCE_AMOUNT
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_A_DEAL_DATE_AMOUNTS_V;

Dependencies

[top of page]

APPS

XTR_A_DEAL_DATE_AMOUNTS

APPS.XTR_A_DEAL_DATE_AMOUNTS_V is not referenced by any database object