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

VIEW: QRM.QRM_TB_CALCULATIONS#

Object Details
Object Name: QRM_TB_CALCULATIONS#
Object Type: VIEW
Owner: QRM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEAL_NO NUMBER
Yes
TRANSACTION_NO NUMBER
Yes
MARKET_DATA_SET VARCHAR2 (20) Yes
START_DATE DATE

END_DATE DATE
Yes
INTEREST_BASIS VARCHAR2 (1)
OUTSTANDING_AMOUNT NUMBER

OUTSTANDING_AMOUNT_USD NUMBER

OUTSTANDING_AMOUNT_SOB NUMBER

COUPON_RATE NUMBER

NEXT_COUPON_DATE DATE

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)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

POS_START_DATE DATE

POS_END_DATE DATE

AMT_QTY_OUT NUMBER

AMT_QTY_OUT_USD NUMBER

AMT_QTY_OUT_SOB NUMBER

Query Text

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


SELECT DEAL_NO
,      TRANSACTION_NO
,      MARKET_DATA_SET
,      START_DATE
,      END_DATE
,      INTEREST_BASIS
,      OUTSTANDING_AMOUNT
,      OUTSTANDING_AMOUNT_USD
,      OUTSTANDING_AMOUNT_SOB
,      COUPON_RATE
,      NEXT_COUPON_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      POS_START_DATE
,      POS_END_DATE
,      AMT_QTY_OUT
,      AMT_QTY_OUT_USD
,      AMT_QTY_OUT_SOB
FROM QRM.QRM_TB_CALCULATIONS#;

Dependencies

[top of page]

QRM.QRM_TB_CALCULATIONS# references the following:

SchemaQRM
TableQRM_TB_CALCULATIONS
QRM.QRM_TB_CALCULATIONS# is referenced by following:

SchemaAPPS
SynonymQRM_TB_CALCULATIONS