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: TableXTR.XTR_INTERACCT_TRANSFERS
Subobject Name:
Status: VALID


This table stores information related to Inter-Account Transfers.


Storage Details
Tablespace: TablespaceAPPS_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:

SchemaXTR
ViewXTR_INTERACCT_TRANSFERS#