[Home] [Help] [Dependency Information]
Object Name: | QP_PRICE_FORMULAS_TL |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PRICE_FORMULAS_TL |
Subobject Name: | |
Status: | VALID |
This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PRICE_FORMULAS_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PRICE_FORMULA_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRICE_FORMULA_ID | NUMBER | Yes | References primary key of QP_PRICE_FORMULAS_B | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
NAME | VARCHAR2 | (240) | Yes | Name of the pricing formula |
DESCRIPTION | VARCHAR2 | (2000) | Description of the pricing formula |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_FORMULA_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
, NAME
, DESCRIPTION
FROM QP.QP_PRICE_FORMULAS_TL;
QP.QP_PRICE_FORMULAS_TL does not reference any database object
QP.QP_PRICE_FORMULAS_TL is referenced by following:
|
|
|