eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.XTR_CE_DEAL_DATE_AMOUNTS_V

Object Details

Object Name:	XTR_CE_DEAL_DATE_AMOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_CE_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
ACCOUNT_NO	VARCHAR2	(20)		Settlement account number
ACCRUAL_FROM	DATE			Not currently used
ACCRUAL_TO	DATE			Not currently used
ACTION_CODE	VARCHAR2	(7)		Code for actions involved in executing deals
ACTION_COMPLETED	VARCHAR2	(1)		Not currently used
ACTUAL_SETTLEMENT_DATE	DATE			Settlement date
AMOUNT	NUMBER		Yes	Transaction amount
AMOUNT_DATE	DATE			Date the deal finishes and is paid off, or date the principal amount of a note, draft, acceptance, bond, short term or other debt instrument becomes due and payable.
AMOUNT_TYPE	VARCHAR2	(7)	Yes	Code that identifies the purpose of the amounts for a deal type
ARCHIVE_BY	VARCHAR2	(30)		Not currently used
ARCHIVE_DATE	DATE			Not currently used
ATTACHMENT_EXISTS	VARCHAR2	(1)		Not currently used
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
AUTHORISED	VARCHAR2	(1)		Not currently used
BALANCE_SHEET_EXPOSURE	VARCHAR2	(1)		Flag indicates if the exposure type is in balance sheet (Y), or not (N)
BENEFICIARY_ACCOUNT_NO	VARCHAR2	(20)		Settlement beneficiary party account number
BENEFICIARY_PARTY	VARCHAR2	(7)		Settlement beneficiary party
CASHFLOW_AMOUNT	NUMBER			Cash flow amount
CHQ_REQD	VARCHAR2	(1)		Flag to indicate if user selects check as method of payment for settlement (Y), or not (N)
CLIENT_BROKER_CLRACCT	VARCHAR2	(1)		Flag to indicate if the client has settled with the counteryparty via the company clearing account (Y), or not (N)
CLIENT_CODE	VARCHAR2	(7)		Client for which the deal is made
COMMENCE_DATE	DATE			Date the deal can start to be exercised
COMMENTS	VARCHAR2	(255)		Settlement comments
COMPANY_CODE	VARCHAR2	(7)		Company code
CONTRACT_CODE	VARCHAR2	(7)		Not currently used
CPARTY_ACCOUNT_NO	VARCHAR2	(20)		Alpha-numeric reference of counterparty financial account
CPARTY_CODE	VARCHAR2	(7)		Counterparty code
CURRENCY	VARCHAR2	(15)	Yes	Currency code
CURRENCY_COMBINATION	VARCHAR2	(31)		Currency quotations which combine a base and a contra currency
DATE_TYPE	VARCHAR2	(7)	Yes	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
DEALER_CODE	VARCHAR2	(10)		Code for Treasury users
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DEAL_ORDERS	VARCHAR2	(255)		Not currently used
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
DIARY_CREATED_BY	VARCHAR2	(30)		Not currently used
DIARY_NOTE	VARCHAR2	(255)		Not currently used
DIRECT_DEBIT	VARCHAR2	(1)		Flag to indicate if user selects direct debit as method of payment for settlement (Y), or not (N)
DUAL_AUTHORISATION_BY	VARCHAR2	(30)		Login name of user who created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
DUAL_AUTHORISATION_ON	DATE			Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
EXPOSURE_REF_DATE	DATE			Not currently used
EXP_SETTLE_REQD	VARCHAR2	(1)		Flag to indicate if Treasury user wants to automatically initiate a payment for the exposure (Y), or not (N)
EXTERNAL_COMMENTS	VARCHAR2	(255)		Not currently used
FIRST_ACCRUAL	DATE			Not currently used
FRA_DESCRIPTION	VARCHAR2	(20)		Not currently used
GENERAL_OR_PRIVATE_ACCESS	VARCHAR2	(7)		Not currently used
CODE_COMBINATION_ID	NUMBER	(15)		Unique key for identifying GL account references
GOOD_VALUE_CLAIM	VARCHAR2	(1)		Not currently used
HCE_AMOUNT	NUMBER			Amount in reporting currency equivalent
JOURNAL_CREATED	VARCHAR2	(1)		No longer used.
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
LIMIT_PARTY	VARCHAR2	(7)		Party against which limits are checked
MULTIPLE_REFERENCE_NUMBER	NUMBER			Original settlement number which indicates where this split settlement comes from
MULTIPLE_SETTLEMENTS	VARCHAR2	(1)		Flag to indicate if the settlement is split into more than one company or one bank account (Y), or not (N)
NETOFF_GROUP_FLAG	VARCHAR2	(1)		Flag to indicate the method of settlement groupings (Netoff (N), Sum (S), None (O), and Not Set (T))
NETOFF_NUMBER	NUMBER			Unique reference number assigned to a netting group
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PRINTED_MATURITY_YN	VARCHAR2	(1)		Not currently used
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
QUICK_INPUT	VARCHAR2	(1)		Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N)
RECONCILED_DAYS_ADJUST	NUMBER			Days adjusted for bank statement reconciliation
RECONCILED_PASS_CODE	VARCHAR2	(3)		Set of selection criteria used for reconciliation
RECONCILED_REFERENCE	NUMBER			Reference number to the statement line against which this transaction is reconciled
SERIAL_REFERENCE	VARCHAR2	(12)		Internal reference
SETTLE	VARCHAR2	(1)		Flag to indicate if the settlement has been authorized (Y), or not (N)
SETTLEMENT_ACTIONED	VARCHAR2	(1)		Flag to indicate if the settlement has been processed (Y), or not (N)
SETTLEMENT_ACTIONED_FILE	VARCHAR2	(255)		Not currently used
SETTLEMENT_AUTHORISED_BY	VARCHAR2	(30)		Treasury user who authorized the settlement
SETTLEMENT_NUMBER	NUMBER			Unique reference number assigned to a settlement
SETTLEMENT_PARTY	VARCHAR2	(7)		Not currently used
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
TRANSACTION_DATE	DATE		Yes	Date the transaction is made
TRANSACTION_NUMBER	NUMBER			Unique reference number assigned to a transaction
TRANSACTION_RATE	NUMBER			Transaction rate
TRANS_MTS	VARCHAR2	(1)		Flag to indicate if user has selected EFT (Electronic Funds Transfer) as method of payment for settlement (Y), or not (N)
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
ORIGINAL_SETTLEMENT_CURRENCY	VARCHAR2	(15)		Not currently used
ORIGINAL_SETTLEMENT_AMOUNT	NUMBER			Not currently used
COMPANY_HCE_AMOUNT	NUMBER			Not currently used
CREATED_BY	VARCHAR2	(30)		User who created this record
CREATED_ON	DATE			Date this record was created
BATCH_ID	NUMBER	(15)		Identifier that groups events into one process flow.
DEAL_DATE_AMOUNT_ID	NUMBER		Yes	Unique reference number assigned to each deal date amount.
COMPANY_ACCT_USE_ID	NUMBER	(15)		Settlement account ID
CPARTY_ACCT_USE_ID	NUMBER	(15)		Counterparty account ID
BENEFECIARY_ACCT_USE_ID	NUMBER	(15)		Settlement beneficiary party account ID
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier

Query Text

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


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

Dependencies

[top of page]

APPS.XTR_CE_DEAL_DATE_AMOUNTS_V references the following:

APPS: XTR_DEAL_DATE_AMOUNTS; XTR_PARTY_INFO

APPS.XTR_CE_DEAL_DATE_AMOUNTS_V is not referenced by any database object