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_RETRO_TESTS_V

Object Details

Object Name:	XTR_DISC_HEDGE_RETRO_TESTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_DISC_HEDGE_RETRO_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 retrospective effectiveness test results and measurement details at the hedge level.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HEDGE_RETRO_TEST_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.
HEDGE_ATTRIBUTE_ID	NUMBER	(15)	Yes	Refer to base table.
RESULT_CODE	VARCHAR2	(30)		Refer to base table.
BATCH_ID	NUMBER	(15)	Yes	Refer to base table.
RESULT_DATE	DATE			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.
PROGRAM_ID	NUMBER	(15)		Refer to base table.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Refer to base table.
REQUEST_ID	NUMBER	(15)		Refer to base table.
COMPLETE_FLAG	VARCHAR2	(1)		Refer to base table.
GAIN_LOSS_CCY	VARCHAR2	(15)		Refer to base table.
AMOUNT_TYPE	VARCHAR2	(30)		Refer to base table.
ITEM_PRD_GAIN_LOSS_AMT	NUMBER			Refer to base table.
INST_PRD_GAIN_LOSS_AMT	NUMBER			Refer to base table.
ITEM_CUM_GAIN_LOSS_AMT	NUMBER			Refer to base table.
INST_CUM_GAIN_LOSS_AMT	NUMBER			Refer to base table.
PCT_EFFECTIVE	NUMBER			Refer to base table.
EFF_PRD_GAIN_LOSS_AMT	NUMBER			Refer to base table.
INEFF_PRD_GAIN_LOSS_AMT	NUMBER			Refer to base table.
EXCLUDED_PRD_GAIN_LOSS_AMT	NUMBER			Refer to base table.
RECLASS_GAIN_LOSS_AMT	NUMBER			Refer to base table.
EFF_CUM_GAIN_LOSS_AMT	NUMBER			Refer to base table.
INEFF_CUM_GAIN_LOSS_AMT	NUMBER			Refer to base table.
EXCLUDED_CUM_GAIN_LOSS_AMT	NUMBER			Refer to base table.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Refer to base table.
ATTRIBUTE1	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE2	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE3	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE4	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE5	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE6	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE7	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE8	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE9	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE10	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE11	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE12	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE13	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE14	VARCHAR2	(150)		Refer to base table.
ATTRIBUTE15	VARCHAR2	(150)		Refer to base table.

Query Text

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


SELECT HEDGE_RETRO_TEST_ID
,      COMPANY_CODE
,      COMPANY_NAME
,      HEDGE_ATTRIBUTE_ID
,      RESULT_CODE
,      BATCH_ID
,      RESULT_DATE
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      COMPLETE_FLAG
,      GAIN_LOSS_CCY
,      AMOUNT_TYPE
,      ITEM_PRD_GAIN_LOSS_AMT
,      INST_PRD_GAIN_LOSS_AMT
,      ITEM_CUM_GAIN_LOSS_AMT
,      INST_CUM_GAIN_LOSS_AMT
,      PCT_EFFECTIVE
,      EFF_PRD_GAIN_LOSS_AMT
,      INEFF_PRD_GAIN_LOSS_AMT
,      EXCLUDED_PRD_GAIN_LOSS_AMT
,      RECLASS_GAIN_LOSS_AMT
,      EFF_CUM_GAIN_LOSS_AMT
,      INEFF_CUM_GAIN_LOSS_AMT
,      EXCLUDED_CUM_GAIN_LOSS_AMT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.XTR_DISC_HEDGE_RETRO_TESTS_V;

Dependencies

[top of page]

APPS.XTR_DISC_HEDGE_RETRO_TESTS_V references the following:

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

APPS.XTR_DISC_HEDGE_RETRO_TESTS_V is not referenced by any database object