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_INTERGROUP_TRANSFERS

Object Details

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

XTR_INTERGROUP_TRANSFERS contains the intercompany loans or deposits information. Each row corresponds to a loan or deposit between a company and a subsidiary.
This table corresponds to the Intercompany Funding window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_INTERGROUP_TRANSFERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEAL_NUMBER TRANSACTION_NUMBER
XTR_INTERGROUP_TRANSFERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_CODE TRANSFER_DATE
XTR_INTERGROUP_TRANSFERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPANY_CODE CURRENCY PARTY_CODE
XTR_INTERGROUP_TRANSFERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_NUMBER EXTERNAL_DEAL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_REF	VARCHAR2	(7)		Account reference
ACCUM_INTEREST_BF	NUMBER			Accumulated interest
ACCUM_INTEREST_BF_HCE	NUMBER			Accumulated interest in reporting currency equivalent
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
BALANCE_BF	NUMBER			Previous balance brought forward
BALANCE_BF_HCE	NUMBER			Previous balance brought forward in reporting currency equivalent
BALANCE_OUT	NUMBER			Balance amount
BALANCE_OUT_HCE	NUMBER			Balance amount in reporting currency equivalent
COMMENTS	VARCHAR2	(255)		Comments
COMPANY_ACCOUNT_NO	VARCHAR2	(20)		Company financial account number
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
CREATED_BY	VARCHAR2	(30)		User who created this record
CREATED_ON	DATE			Date this record was created
CURRENCY	VARCHAR2	(15)	Yes	Currency code
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
INTEREST	NUMBER			Interest amount
INTEREST_HCE	NUMBER			Interest amount in reporting currency equivalent
INTEREST_RATE	NUMBER			Interest rate at which a deal or transaction is executed
INTEREST_SETTLED	NUMBER			Interest settlement
INTEREST_SETTLED_HCE	NUMBER			Interest settlement in reporting currency equivalent
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
NO_OF_DAYS	NUMBER			Number of days
PARTY_ACCOUNT_NO	VARCHAR2	(20)		Counterparty financial account number
PARTY_CODE	VARCHAR2	(7)	Yes	Party code
PORTFOLIO	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PRINCIPAL_ACTION	VARCHAR2	(7)		Indicates if a principal is paid (PAY) or received (REC)
PRINCIPAL_ADJUST	NUMBER			Principal adjustment amount
PRINCIPAL_ADJUST_HCE	NUMBER			Principal adjustment amount in reporting currency equivalent
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
SETTLE_DATE	DATE			Date the transfer is settled
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
TRANSFER_DATE	DATE		Yes	Date the transfer occurred
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
ACCRUAL_INTEREST	NUMBER			Running accumulated interest
FIRST_BATCH_ID	NUMBER	(15)		First batch id. Identifier that groups events into one process flow.
LAST_BATCH_ID	NUMBER	(15)		Last batch id. Identifier that groups events into one process flow.
EXCHANGE_RATE	NUMBER			Exchange rate.
AVERAGE_EXCHANGE_RATE	NUMBER			Average exchange rate.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		For Descriptive Flexfield
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
INTEREST_ACTION	VARCHAR2	(1)		This column stores interest action. Possible values are 'C'=compound, 'S'=settle, 'N'=none.
EXTERNAL_DEAL_ID	VARCHAR2	(240)		Stores the unique external primary
REQUEST_ID	NUMBER			The concurrent request that created or updated the row.
PROGRAM_APPLICATION_ID	NUMBER			With PROGRAM_ID, identifies the concurrent program that created or updated the row.
PROGRAM_ID	NUMBER			With PROGRAM_APPLICATION_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.
LIMIT_CODE_INVEST	VARCHAR2	(7)		The user-defined invest limit types assigned to the deal or transaction.
MIRROR_DEAL	VARCHAR2	(1)		Indicates if this is a mirror deal or not.
MIRROR_DEAL_NUMBER	NUMBER	(38)		Indicates the mirror deal number.
MIRROR_TRANSACTION_NUMBER	NUMBER	(38)		Indicates the mirror transaction number.
ROUNDING_TYPE	VARCHAR2	(1)		Not currently used
DAY_COUNT_TYPE	VARCHAR2	(1)		Not currently used
ORIGINAL_AMOUNT	NUMBER			Not currently used
PRICING_MODEL	VARCHAR2	(30)		Intercompany Funding pricing model
COMPANY_ACCT_USE_ID	NUMBER	(15)		Company financial account ID
CPARTY_ACCT_USE_ID	NUMBER	(15)		Counterparty financial account ID
DEAL_LINKING_CODE	VARCHAR2	(8)		Code to identify the group of linked deals
DEALER_CODE	VARCHAR2	(10)	Yes	Code for Treasury users
EXTERNAL_SOURCE	VARCHAR2	(30)		The source of the transactions

Query Text

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


SELECT ACCT_REF
,      ACCUM_INTEREST_BF
,      ACCUM_INTEREST_BF_HCE
,      AUDIT_INDICATOR
,      BALANCE_BF
,      BALANCE_BF_HCE
,      BALANCE_OUT
,      BALANCE_OUT_HCE
,      COMMENTS
,      COMPANY_ACCOUNT_NO
,      COMPANY_CODE
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      DEAL_NUMBER
,      DEAL_TYPE
,      INTEREST
,      INTEREST_HCE
,      INTEREST_RATE
,      INTEREST_SETTLED
,      INTEREST_SETTLED_HCE
,      LIMIT_CODE
,      NO_OF_DAYS
,      PARTY_ACCOUNT_NO
,      PARTY_CODE
,      PORTFOLIO
,      PRINCIPAL_ACTION
,      PRINCIPAL_ADJUST
,      PRINCIPAL_ADJUST_HCE
,      PRODUCT_TYPE
,      SETTLE_DATE
,      TRANSACTION_NUMBER
,      TRANSFER_DATE
,      UPDATED_BY
,      UPDATED_ON
,      ACCRUAL_INTEREST
,      FIRST_BATCH_ID
,      LAST_BATCH_ID
,      EXCHANGE_RATE
,      AVERAGE_EXCHANGE_RATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTEREST_ACTION
,      EXTERNAL_DEAL_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LIMIT_CODE_INVEST
,      MIRROR_DEAL
,      MIRROR_DEAL_NUMBER
,      MIRROR_TRANSACTION_NUMBER
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      ORIGINAL_AMOUNT
,      PRICING_MODEL
,      COMPANY_ACCT_USE_ID
,      CPARTY_ACCT_USE_ID
,      DEAL_LINKING_CODE
,      DEALER_CODE
,      EXTERNAL_SOURCE
FROM XTR.XTR_INTERGROUP_TRANSFERS;

Dependencies

[top of page]

XTR.XTR_INTERGROUP_TRANSFERS does not reference any database object

XTR.XTR_INTERGROUP_TRANSFERS is referenced by following:

APPS: XTR_AID_INTERGROUP_TRANSFERS_T; XTR_AU_INTERGROUP_TRANSFERS_T; XTR_INTERGROUP_TRANSFERS