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_DEAL_DATE_AMOUNTS_V

Object Details

Object Name:	XTR_DEAL_DATE_AMOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_DEAL_DATE_AMOUNTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
BATCH_ID	NUMBER	(15)		Identifier that groups events into one process flow.
AMOUNT_TYPE	VARCHAR2	(7)	Yes	Code that identifies the purpose of the amounts for a deal type
DATE_TYPE	VARCHAR2	(7)	Yes	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
TRANSACTION_DATE	DATE		Yes	Date the transaction is made
CURRENCY	VARCHAR2	(15)	Yes	Currency code
AMOUNT	NUMBER		Yes	Transaction amount
HCE_AMOUNT	NUMBER			Amount in reporting currency equivalent
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.
TRANSACTION_RATE	NUMBER			Transaction rate
CASHFLOW_AMOUNT	NUMBER			Cash flow amount
COMPANY_CODE	VARCHAR2	(7)		Company code
ACCOUNT_NO	VARCHAR2	(20)		Settlement account number
CPARTY_ACCOUNT_NO	VARCHAR2	(20)		Alpha-numeric reference of counterparty financial account
CHQ_REQD	VARCHAR2	(1)		Flag to indicate if user selects check as method of payment for settlement (Y), or not (N)
ACTION_CODE	VARCHAR2	(7)		Code for actions involved in executing deals
TRANSACTION_NUMBER	NUMBER			Unique reference number assigned to a transaction
DIARY_NOTE	VARCHAR2	(255)		Not currently used
AUTHORISED	VARCHAR2	(1)		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)
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)
SETTLE	VARCHAR2	(1)		Flag to indicate if the settlement has been authorized (Y), or not (N)
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
CLIENT_CODE	VARCHAR2	(7)		Client for which the deal is made
CPARTY_CODE	VARCHAR2	(7)		Counterparty code
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
DIARY_CREATED_BY	VARCHAR2	(30)		Not currently used
DEAL_ORDERS	VARCHAR2	(255)		Not currently used
DEALER_CODE	VARCHAR2	(10)		Code for Treasury users
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
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)
MULTIPLE_REFERENCE_NUMBER	NUMBER			Original settlement number which indicates where this split settlement comes from
SETTLEMENT_NUMBER	NUMBER			Unique reference number assigned to a settlement
SETTLEMENT_AUTHORISED_BY	VARCHAR2	(30)		Treasury user who authorized the settlement
SETTLEMENT_PARTY	VARCHAR2	(7)		Not currently used
COMMENTS	VARCHAR2	(255)		Settlement comments
CODE_COMBINATION_ID	NUMBER	(15)		Unique key for identifying GL account references
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)
EXP_SETTLE_REQD	VARCHAR2	(1)		Flag to indicate if Treasury user wants to automatically initiate a payment for the exposure (Y), or not (N)
LIMIT_PARTY	VARCHAR2	(7)		Party against which limits are checked
DUAL_AUTHORISATION_ON	DATE			Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
ARCHIVE_DATE	DATE			Not currently used
ARCHIVE_BY	VARCHAR2	(30)		Not currently used
CONTRACT_CODE	VARCHAR2	(7)		Not currently used
NETOFF_NUMBER	NUMBER			Unique reference number assigned to a netting group
BENEFICIARY_PARTY	VARCHAR2	(7)		Settlement beneficiary party
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
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
RECONCILED_DAYS_ADJUST	NUMBER			Days adjusted for bank statement reconciliation
SERIAL_REFERENCE	VARCHAR2	(12)		Internal reference
BENEFICIARY_ACCOUNT_NO	VARCHAR2	(20)		Settlement beneficiary party account number
FIRST_ACCRUAL	DATE			Not currently used
ACCRUAL_FROM	DATE			Not currently used
ACCRUAL_TO	DATE			Not currently used
FRA_DESCRIPTION	VARCHAR2	(20)		Not currently used
GENERAL_OR_PRIVATE_ACCESS	VARCHAR2	(7)		Not currently used
CURRENCY_COMBINATION	VARCHAR2	(31)		Currency quotations which combine a base and a contra currency
ACTUAL_SETTLEMENT_DATE	DATE			Settlement date
GOOD_VALUE_CLAIM	VARCHAR2	(1)		Not currently used
NETOFF_GROUP_FLAG	VARCHAR2	(1)		Flag to indicate the method of settlement groupings (Netoff (N), Sum (S), None (O), and Not Set (T))
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
QUICK_INPUT	VARCHAR2	(1)		Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N)
EXTERNAL_COMMENTS	VARCHAR2	(255)		Not currently used
EXPOSURE_REF_DATE	DATE			Not currently used
ATTACHMENT_EXISTS	VARCHAR2	(1)		Not currently used
COMMENCE_DATE	DATE			Date the deal can start to be exercised
PRINTED_MATURITY_YN	VARCHAR2	(1)		Not currently used
BALANCE_SHEET_EXPOSURE	VARCHAR2	(1)		Flag indicates if the exposure type is in balance sheet (Y), or not (N)
ACTION_COMPLETED	VARCHAR2	(1)		Not currently used
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

Query Text

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


SELECT DEAL_TYPE
,      BATCH_ID
,      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
,      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
,      ORIGINAL_SETTLEMENT_CURRENCY
,      ORIGINAL_SETTLEMENT_AMOUNT
,      COMPANY_HCE_AMOUNT
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_DEAL_DATE_AMOUNTS_V;

Dependencies

[top of page]

APPS.XTR_DEAL_DATE_AMOUNTS_V references the following:

APPS: XTR_COMPANY_AUTHORITIES; XTR_DEAL_DATE_AMOUNTS; XTR_USER_ACCESS - show dependent code

APPS.XTR_DEAL_DATE_AMOUNTS_V is referenced by following:

APPS: XTR_ACCOUNT_BAL_MAINT_P - show dependent code; XTR_ACCRUAL_PROCESS_P - show dependent code; XTR_AUTO_RECONCILIATION - show dependent code; XTR_CALC_P - show dependent code; XTR_COMMON_FUNCTIONS - show dependent code; XTR_DDA_EXPOSURES_V; XTR_EFT_CREDITS_V; XTR_EFT_DEBITS_V; XTR_EFT_SCRIPT_P - show dependent code; XTR_EXP_SUMM_P - show dependent code; XTR_EXP_TRANSFERS_PKG - show dependent code; XTR_FPS2_P - show dependent code; XTR_IAC_TRANSFERS_PKG - show dependent code; XTR_IG_TRANSFERS_PKG - show dependent code; XTR_JOURNAL_PROCESS_P - show dependent code; XTR_MAINTAIN_DDA_P - show dependent code; XTR_MATURITIES_V; XTR_MISC_P - show dependent code; XTR_REPLICATE_BANK_BALANCES - show dependent code; XTR_SETTLEMENT - show dependent code; XTR_SETTLEMENTS_V; XTR_SETTLEMENT_LETTERS_V; XTR_TMM_SUMMARY_V; XTR_WRAPPER_API_P - show dependent code; XTR_XTRLTDAP_XMLP_PKG - show dependent code