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_A_INTERGROUP_TRANSFERS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NUMBER	NUMBER		Yes
TRANSACTION_NUMBER	NUMBER		Yes
DEAL_TYPE	VARCHAR2	(7)	Yes
TRANSFER_DATE	DATE		Yes
COMPANY_CODE	VARCHAR2	(7)	Yes
PARTY_CODE	VARCHAR2	(7)	Yes
CURRENCY	VARCHAR2	(15)	Yes
NO_OF_DAYS	NUMBER
BALANCE_OUT	NUMBER
BALANCE_OUT_HCE	NUMBER
BALANCE_BF	NUMBER
BALANCE_BF_HCE	NUMBER
ACCUM_INTEREST_BF	NUMBER
ACCUM_INTEREST_BF_HCE	NUMBER
PRINCIPAL_ADJUST	NUMBER
PRINCIPAL_ADJUST_HCE	NUMBER
PRINCIPAL_ACTION	VARCHAR2	(7)
COMPANY_ACCOUNT_NO	VARCHAR2	(20)
PARTY_ACCOUNT_NO	VARCHAR2	(20)
INTEREST_RATE	NUMBER
INTEREST	NUMBER
INTEREST_HCE	NUMBER
INTEREST_SETTLED	NUMBER
INTEREST_SETTLED_HCE	NUMBER
CREATED_BY	VARCHAR2	(30)
CREATED_ON	DATE
SETTLE_DATE	DATE
UPDATED_BY	VARCHAR2	(30)
UPDATED_ON	DATE
PRODUCT_TYPE	VARCHAR2	(10)
COMMENTS	VARCHAR2	(255)
LIMIT_CODE	VARCHAR2	(7)
PORTFOLIO	VARCHAR2	(7)
ACCT_REF	VARCHAR2	(7)
AUDIT_INDICATOR	VARCHAR2	(1)
AUDIT_DATE_STORED	DATE
ACCRUAL_INTEREST	NUMBER			Running accumulated interest

Query Text

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


SELECT DEAL_NUMBER
,      TRANSACTION_NUMBER
,      DEAL_TYPE
,      TRANSFER_DATE
,      COMPANY_CODE
,      PARTY_CODE
,      CURRENCY
,      NO_OF_DAYS
,      BALANCE_OUT
,      BALANCE_OUT_HCE
,      BALANCE_BF
,      BALANCE_BF_HCE
,      ACCUM_INTEREST_BF
,      ACCUM_INTEREST_BF_HCE
,      PRINCIPAL_ADJUST
,      PRINCIPAL_ADJUST_HCE
,      PRINCIPAL_ACTION
,      COMPANY_ACCOUNT_NO
,      PARTY_ACCOUNT_NO
,      INTEREST_RATE
,      INTEREST
,      INTEREST_HCE
,      INTEREST_SETTLED
,      INTEREST_SETTLED_HCE
,      CREATED_BY
,      CREATED_ON
,      SETTLE_DATE
,      UPDATED_BY
,      UPDATED_ON
,      PRODUCT_TYPE
,      COMMENTS
,      LIMIT_CODE
,      PORTFOLIO
,      ACCT_REF
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
,      ACCRUAL_INTEREST
FROM APPS.XTR_A_INTERGROUP_TRANSFERS_V;

Dependencies

[top of page]

APPS.XTR_A_INTERGROUP_TRANSFERS_V references the following:

APPS: XTR_A_INTERGROUP_TRANSFERS

APPS.XTR_A_INTERGROUP_TRANSFERS_V is not referenced by any database object