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


VIEW: APPS.XTR_R_DEAL_DATE_AMOUNTS_V

Object Details
Object Name: XTR_R_DEAL_DATE_AMOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_R_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
Name Datatype Length Mandatory Comments
DEAL_TYPE VARCHAR2 (7) Yes
AMOUNT_TYPE VARCHAR2 (7) Yes
DATE_TYPE VARCHAR2 (7) Yes
DEAL_NUMBER NUMBER
Yes
TRANSACTION_DATE DATE
Yes
CURRENCY VARCHAR2 (15) Yes
AMOUNT NUMBER
Yes
HCE_AMOUNT NUMBER

AMOUNT_DATE DATE

TRANSACTION_RATE NUMBER

CASHFLOW_AMOUNT NUMBER

COMPANY_CODE VARCHAR2 (7)
ACCOUNT_NO VARCHAR2 (20)
CPARTY_ACCOUNT_NO VARCHAR2 (20)
CHQ_REQD VARCHAR2 (1)
ACTION_CODE VARCHAR2 (7)
TRANSACTION_NUMBER NUMBER

JOURNAL_CREATED VARCHAR2 (1)
DIARY_NOTE VARCHAR2 (255)
AUTHORISED VARCHAR2 (1)
DIRECT_DEBIT VARCHAR2 (1)
TRANS_MTS VARCHAR2 (1)
SETTLE VARCHAR2 (1)
DEAL_SUBTYPE VARCHAR2 (7)
PRODUCT_TYPE VARCHAR2 (10)
LIMIT_CODE VARCHAR2 (7)
STATUS_CODE VARCHAR2 (10)
CLIENT_CODE VARCHAR2 (7)
CPARTY_CODE VARCHAR2 (7)
PORTFOLIO_CODE VARCHAR2 (7)
DIARY_CREATED_BY VARCHAR2 (30)
DEAL_ORDERS VARCHAR2 (255)
DEALER_CODE VARCHAR2 (10)
DUAL_AUTHORISATION_BY VARCHAR2 (30)
MULTIPLE_SETTLEMENTS VARCHAR2 (1)
MULTIPLE_REFERENCE_NUMBER NUMBER

SETTLEMENT_NUMBER NUMBER

SETTLEMENT_AUTHORISED_BY VARCHAR2 (30)
SETTLEMENT_PARTY VARCHAR2 (7)
COMMENTS VARCHAR2 (255)
CODE_COMBINATION_ID NUMBER (15)
CLIENT_BROKER_CLRACCT VARCHAR2 (1)
EXP_SETTLE_REQD VARCHAR2 (1)
LIMIT_PARTY VARCHAR2 (7)
DUAL_AUTHORISATION_ON DATE

ARCHIVE_DATE DATE

ARCHIVE_BY VARCHAR2 (30)
CONTRACT_CODE VARCHAR2 (7)
NETOFF_NUMBER NUMBER

BENEFICIARY_PARTY VARCHAR2 (7)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

AUDIT_INDICATOR VARCHAR2 (1)
RECONCILED_PASS_CODE VARCHAR2 (2)
RECONCILED_REFERENCE NUMBER

RECONCILED_DAYS_ADJUST NUMBER

SERIAL_REFERENCE VARCHAR2 (12)
BENEFICIARY_ACCOUNT_NO VARCHAR2 (20)
FIRST_ACCRUAL DATE

ACCRUAL_FROM DATE

ACCRUAL_TO DATE

FRA_DESCRIPTION VARCHAR2 (20)
GENERAL_OR_PRIVATE_ACCESS VARCHAR2 (7)
CURRENCY_COMBINATION VARCHAR2 (31)
ACTUAL_SETTLEMENT_DATE DATE

GOOD_VALUE_CLAIM VARCHAR2 (1)
NETOFF_GROUP_FLAG VARCHAR2 (1)
SETTLEMENT_ACTIONED VARCHAR2 (1)
SETTLEMENT_ACTIONED_FILE VARCHAR2 (50)
QUICK_INPUT VARCHAR2 (1)
EXTERNAL_COMMENTS VARCHAR2 (255)
EXPOSURE_REF_DATE DATE

ATTACHMENT_EXISTS VARCHAR2 (1)
COMMENCE_DATE DATE

PRINTED_MATURITY_YN VARCHAR2 (1)
BALANCE_SHEET_EXPOSURE VARCHAR2 (1)
ACTION_COMPLETED VARCHAR2 (1)
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
,      AUDIT_INDICATOR
,      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
FROM APPS.XTR_R_DEAL_DATE_AMOUNTS_V;

Dependencies

[top of page]

APPS.XTR_R_DEAL_DATE_AMOUNTS_V references the following:

SchemaAPPS
SynonymXTR_R_DEAL_DATE_AMOUNTS

APPS.XTR_R_DEAL_DATE_AMOUNTS_V is not referenced by any database object