[Home] [Help] [Dependency Information]
Object Name: | QRM_TB_CALCULATIONS |
---|---|
Object Type: | TABLE |
Owner: | QRM |
FND Design Data: | QRM.QRM_TB_CALCULATIONS |
Subobject Name: | |
Status: | VALID |
QRM_TB_CALCULATIONS contain calculated deal attributes for current deals that change over time. These attributes include values such as outstanding amount, coupon rate, next coupon date, and so on. Each row corresponds to deal attribute values within a fixed time period.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QRM_TB_CALCULATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DEAL_NO
TRANSACTION_NO MARKET_DATA_SET START_DATE END_DATE |
QRM_TB_CALCULATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | START_DATE |
QRM_TB_CALCULATIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | END_DATE |
QRM_TB_CALCULATIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POS_START_DATE |
QRM_TB_CALCULATIONS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POS_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_NO | NUMBER | Yes | Deal number. | |
TRANSACTION_NO | NUMBER | Yes | Transaction number. | |
MARKET_DATA_SET | VARCHAR2 | (20) | Yes | Market data set used for calculation. |
START_DATE | DATE | Start date of time bucket | ||
END_DATE | DATE | Yes | End date of time bucket | |
INTEREST_BASIS | VARCHAR2 | (1) | Interest basis | |
OUTSTANDING_AMOUNT | NUMBER | Amount outstanding for time bucket period. | ||
OUTSTANDING_AMOUNT_USD | NUMBER | Amount outstanding in USD currency. | ||
OUTSTANDING_AMOUNT_SOB | NUMBER | Amount outstanding in set of books currency. | ||
COUPON_RATE | NUMBER | Coupon rate for time bucket period. | ||
NEXT_COUPON_DATE | DATE | Next coupon date | ||
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
REQUEST_ID | NUMBER | (15) | Concurrency request id | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Program application_id | |
PROGRAM_ID | NUMBER | (15) | Program id | |
PROGRAM_UPDATE_DATE | DATE | Program update date | ||
POS_START_DATE | DATE | Position start date | ||
POS_END_DATE | DATE | Position end date | ||
AMT_QTY_OUT | NUMBER | Amount or Quantity Outstanding | ||
AMT_QTY_OUT_USD | NUMBER | Amount or Quantity Outstanding USD | ||
AMT_QTY_OUT_SOB | NUMBER | Amount or Quantity Outstanding SOB |
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;
QRM.QRM_TB_CALCULATIONS does not reference any database object
QRM.QRM_TB_CALCULATIONS is referenced by following:
|
|
|