[Home] [Help] [Dependency Information]
Object Name: | XTR_PRICE_MODELS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_PRICE_MODELS |
Subobject Name: | |
Status: | VALID |
This table will store valid pricing models seeded by Oracle Treasury as well as those defined by the user. These pricing models will be used for revaluating the fair value of specific Treasury deal types in addition to those seeded by Oracle Treasury.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_PRICE_MODELS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
CODE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRICE_MODEL_ID | NUMBER | (15) | Yes | Unique identifier for each row of pricing model data. |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Denotes the deal type associated with this pricing model. |
CODE | VARCHAR2 | (30) | Yes | Code that represents the pricing model. |
COMPONENT_MODEL_FLAG | VARCHAR2 | (1) | Specifies if this is a model for a component or for an entire fair value deal. Y=Component model. N=Deal fairvalue model. | |
AUTHORIZED | VARCHAR2 | (1) | Yes | Specifies if the pricing model is authorized for use by deals with the associated deal types. An unauthorized pricing model cannot be assigned to new deals but will remain as a reference to existing deals. |
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. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_MODEL_ID
, DEAL_TYPE
, CODE
, COMPONENT_MODEL_FLAG
, AUTHORIZED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM XTR.XTR_PRICE_MODELS;
XTR.XTR_PRICE_MODELS does not reference any database object
XTR.XTR_PRICE_MODELS is referenced by following:
|
|
|