[Home] [Help] [Dependency Information]
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 |
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_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 | |||
RECONCILED_PASS_CODE | VARCHAR2 | (3) | ||
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) | ||
AUDIT_INDICATOR | VARCHAR2 | (1) | ||
AUDIT_DATE_STORED | DATE | |||
ORIGINAL_SETTLEMENT_CURRENCY | VARCHAR2 | (15) | ||
ORIGINAL_SETTLEMENT_AMOUNT | NUMBER | |||
COMPANY_HCE_AMOUNT | NUMBER | |||
CREATED_BY | VARCHAR2 | (30) | ||
CREATED_ON | DATE |
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;
APPS.XTR_A_DEAL_DATE_AMOUNTS_V is not referenced by any database object
|
|
|