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: XTR.XTR_DEAL_DATE_AMOUNTS#

Object Details

Object Name:	XTR_DEAL_DATE_AMOUNTS#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCOUNT_NO	VARCHAR2	(20)
ACCRUAL_FROM	DATE
ACCRUAL_TO	DATE
ACTION_CODE	VARCHAR2	(7)
ACTION_COMPLETED	VARCHAR2	(1)
ACTUAL_SETTLEMENT_DATE	DATE
AMOUNT	NUMBER		Yes
AMOUNT_DATE	DATE
AMOUNT_TYPE	VARCHAR2	(7)	Yes
ARCHIVE_BY	VARCHAR2	(30)
ARCHIVE_DATE	DATE
ATTACHMENT_EXISTS	VARCHAR2	(1)
AUDIT_INDICATOR	VARCHAR2	(1)
AUTHORISED	VARCHAR2	(1)
BALANCE_SHEET_EXPOSURE	VARCHAR2	(1)
BENEFICIARY_ACCOUNT_NO	VARCHAR2	(20)
BENEFICIARY_PARTY	VARCHAR2	(7)
CASHFLOW_AMOUNT	NUMBER
CHQ_REQD	VARCHAR2	(1)
CLIENT_BROKER_CLRACCT	VARCHAR2	(1)
CLIENT_CODE	VARCHAR2	(7)
COMMENCE_DATE	DATE
COMMENTS	VARCHAR2	(255)
COMPANY_CODE	VARCHAR2	(7)
CONTRACT_CODE	VARCHAR2	(7)
CPARTY_ACCOUNT_NO	VARCHAR2	(20)
CPARTY_CODE	VARCHAR2	(7)
CURRENCY	VARCHAR2	(15)	Yes
CURRENCY_COMBINATION	VARCHAR2	(31)
DATE_TYPE	VARCHAR2	(7)	Yes
DEALER_CODE	VARCHAR2	(10)
DEAL_NUMBER	NUMBER		Yes
DEAL_ORDERS	VARCHAR2	(255)
DEAL_SUBTYPE	VARCHAR2	(7)
DEAL_TYPE	VARCHAR2	(7)	Yes
DIARY_CREATED_BY	VARCHAR2	(30)
DIARY_NOTE	VARCHAR2	(255)
DIRECT_DEBIT	VARCHAR2	(1)
DUAL_AUTHORISATION_BY	VARCHAR2	(30)
DUAL_AUTHORISATION_ON	DATE
EXPOSURE_REF_DATE	DATE
EXP_SETTLE_REQD	VARCHAR2	(1)
EXTERNAL_COMMENTS	VARCHAR2	(255)
FIRST_ACCRUAL	DATE
FRA_DESCRIPTION	VARCHAR2	(20)
GENERAL_OR_PRIVATE_ACCESS	VARCHAR2	(7)
CODE_COMBINATION_ID	NUMBER	(15)
GOOD_VALUE_CLAIM	VARCHAR2	(1)
HCE_AMOUNT	NUMBER
JOURNAL_CREATED	VARCHAR2	(1)
LIMIT_CODE	VARCHAR2	(7)
LIMIT_PARTY	VARCHAR2	(7)
MULTIPLE_REFERENCE_NUMBER	NUMBER
MULTIPLE_SETTLEMENTS	VARCHAR2	(1)
NETOFF_GROUP_FLAG	VARCHAR2	(1)
NETOFF_NUMBER	NUMBER
PORTFOLIO_CODE	VARCHAR2	(7)
PRINTED_MATURITY_YN	VARCHAR2	(1)
PRODUCT_TYPE	VARCHAR2	(10)
QUICK_INPUT	VARCHAR2	(1)
RECONCILED_DAYS_ADJUST	NUMBER
RECONCILED_PASS_CODE	VARCHAR2	(3)
RECONCILED_REFERENCE	NUMBER
SERIAL_REFERENCE	VARCHAR2	(12)
SETTLE	VARCHAR2	(1)
SETTLEMENT_ACTIONED	VARCHAR2	(1)
SETTLEMENT_ACTIONED_FILE	VARCHAR2	(255)
SETTLEMENT_AUTHORISED_BY	VARCHAR2	(30)
SETTLEMENT_NUMBER	NUMBER
SETTLEMENT_PARTY	VARCHAR2	(7)
STATUS_CODE	VARCHAR2	(10)
TRANSACTION_DATE	DATE		Yes
TRANSACTION_NUMBER	NUMBER
TRANSACTION_RATE	NUMBER
TRANS_MTS	VARCHAR2	(1)
UPDATED_BY	VARCHAR2	(30)
UPDATED_ON	DATE
ORIGINAL_SETTLEMENT_CURRENCY	VARCHAR2	(15)
ORIGINAL_SETTLEMENT_AMOUNT	NUMBER
COMPANY_HCE_AMOUNT	NUMBER
CREATED_BY	VARCHAR2	(30)
CREATED_ON	DATE
BATCH_ID	NUMBER	(15)
DEAL_DATE_AMOUNT_ID	NUMBER		Yes
COMPANY_ACCT_USE_ID	NUMBER	(15)
CPARTY_ACCT_USE_ID	NUMBER	(15)
BENEFECIARY_ACCT_USE_ID	NUMBER	(15)

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
FROM XTR.XTR_DEAL_DATE_AMOUNTS#;

Dependencies

[top of page]

XTR.XTR_DEAL_DATE_AMOUNTS# references the following:

XTR: XTR_DEAL_DATE_AMOUNTS

XTR.XTR_DEAL_DATE_AMOUNTS# is referenced by following:

APPS: XTR_AID_DEAL_DATE_AMOUNTS_T; XTR_AU_DEAL_DATE_AMOUNTS_T; XTR_BI_DEAL_DATE_AMOUNTS_T; XTR_DEAL_DATE_AMOUNTS