DBA Data[Home] [Help] [Dependency Information]

VIEW: XTR.XTR_DEAL_RETRO_TESTS#

Object Details
Object Name: XTR_DEAL_RETRO_TESTS#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEAL_RETRO_TEST_ID NUMBER (15) Yes
BATCH_ID NUMBER (15) Yes
HEDGE_ATTRIBUTE_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_LOGIN_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
REQUEST_ID NUMBER (15)
DEAL_NUMBER NUMBER
Yes
AMOUNT_TYPE VARCHAR2 (30)
EFF_PRD_GAIN_LOSS_AMT NUMBER

INEFF_PRD_GAIN_LOSS_AMT NUMBER

EXCLUDED_PRD_GAIN_LOSS_AMT NUMBER

RECLASS_GAIN_LOSS_AMT NUMBER

EFF_CUM_GAIN_LOSS_AMT NUMBER

INEFF_CUM_GAIN_LOSS_AMT NUMBER

EXCLUDED_CUM_GAIN_LOSS_AMT NUMBER

HEDGE_RETRO_TEST_ID NUMBER (15) Yes
RESULT_DATE DATE

Query Text

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


SELECT DEAL_RETRO_TEST_ID
,      BATCH_ID
,      HEDGE_ATTRIBUTE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      DEAL_NUMBER
,      AMOUNT_TYPE
,      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
,      HEDGE_RETRO_TEST_ID
,      RESULT_DATE
FROM XTR.XTR_DEAL_RETRO_TESTS#;

Dependencies

[top of page]

XTR.XTR_DEAL_RETRO_TESTS# references the following:

SchemaXTR
TableXTR_DEAL_RETRO_TESTS
XTR.XTR_DEAL_RETRO_TESTS# is referenced by following:

SchemaAPPS
SynonymXTR_DEAL_RETRO_TESTS