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_DISC_HEDGE_PRO_TESTS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

View definition for the hedge prospective effectiveness test results.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HEDGE_PRO_TEST_ID	NUMBER	(15)	Yes	Refer to base table.
HEDGE_ATTRIBUTE_ID	NUMBER	(15)	Yes	Refer to base table.
COMPANY_CODE	VARCHAR2	(7)	Yes	Refer to base table.
COMPANY_NAME	VARCHAR2	(50)	Yes	Refer to base table.
RESULT_CODE	VARCHAR2	(30)		Refer to base table.
RESULT_DATE	DATE			Refer to base table.
LAST_TEST_DATE	DATE			Refer to base table.
PERFORMED_BY	VARCHAR2	(10)	Yes	Refer to base table.
COMMENTS	VARCHAR2	(240)		Refer to base table.
CREATED_BY	VARCHAR2	(10)	Yes	Refer to base table.
CREATION_DATE	DATE		Yes	Refer to base table.
LAST_UPDATED_BY	VARCHAR2	(10)	Yes	Refer to base table.
LAST_UPDATE_DATE	DATE		Yes	Refer to base table.
LAST_UPDATE_LOGIN	VARCHAR2	(10)	Yes	Refer to base table.
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

Query Text

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


SELECT HEDGE_PRO_TEST_ID
,      HEDGE_ATTRIBUTE_ID
,      COMPANY_CODE
,      COMPANY_NAME
,      RESULT_CODE
,      RESULT_DATE
,      LAST_TEST_DATE
,      PERFORMED_BY
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.XTR_DISC_HEDGE_PRO_TESTS_V;

Dependencies

[top of page]

APPS.XTR_DISC_HEDGE_PRO_TESTS_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_COMPANY_AUTHORITIES; XTR_DEALER_CODES; XTR_HEDGE_PRO_TESTS; XTR_PARTY_INFO

APPS.XTR_DISC_HEDGE_PRO_TESTS_V is not referenced by any database object