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]

TABLE: XTR.XTR_INTERACCT_TRANSFERS

Object Details

Object Name:	XTR_INTERACCT_TRANSFERS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_INTERACCT_TRANSFERS
Subobject Name:
Status:	VALID

This table stores information related to Inter-Account Transfers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_NO_FROM	VARCHAR2	(20)	Yes	Paying account number
ACCOUNT_NO_TO	VARCHAR2	(20)	Yes	Receiving account number
COMMENTS	VARCHAR2	(255)		Comments
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
CURRENCY	VARCHAR2	(15)	Yes	Currency code
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
PORTFOLIO_CODE	VARCHAR2	(7)	Yes	Code for grouping deals uner a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)	Yes	Code for products used in deal type
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
TRANSFER_AMOUNT	NUMBER		Yes	Transfer amount
TRANSFER_DATE	DATE		Yes	Transfer date
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield
CREATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
DEAL_DATE	DATE		Yes	Deal date
DUAL_AUTHORISATION_BY	VARCHAR2	(30)		Dealer who validates the transaction
DUAL_AUTHORISATION_ON	DATE			Transaction validation date
EXTERNAL_SOURCE	VARCHAR2	(30)		The source of the transactions
DEALER_CODE	VARCHAR2	(10)	Yes	Dealer Code
REQUEST_ID	NUMBER	(15)		The concurrent request that created or updated the row
PROGRAM_APPLICATION_ID	NUMBER	(15)		With PROGRAM_APPLICATION_ID, identifies the concurrent program that created or updated the row
PROGRAM_ID	NUMBER	(15)		With PROGRAM_ID, identifies the concurrent program that created or updated the row.
PROGRAM_UPDATE_DATE	DATE			The date when the concurrent program created or updated the row

Query Text

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


SELECT ACCOUNT_NO_FROM
,      ACCOUNT_NO_TO
,      COMMENTS
,      COMPANY_CODE
,      CURRENCY
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      STATUS_CODE
,      TRANSFER_AMOUNT
,      TRANSFER_DATE
,      TRANSACTION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEAL_DATE
,      DUAL_AUTHORISATION_BY
,      DUAL_AUTHORISATION_ON
,      EXTERNAL_SOURCE
,      DEALER_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM XTR.XTR_INTERACCT_TRANSFERS;

Dependencies

[top of page]

XTR.XTR_INTERACCT_TRANSFERS does not reference any database object

XTR.XTR_INTERACCT_TRANSFERS is referenced by following:

APPS: XTR_AD_INTERACCT_TRANSFERS_T; XTR_AI_INTERACCT_TRANSFERS_T; XTR_BU_INTERACCT_TRANSFERS_T; XTR_INTERACCT_TRANSFERS