[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OP_PRCE_MST |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.OP_PRCE_MST
|
| Subobject Name: | |
| Status: | VALID |
This table establishes a price list which can be activated for a customer(s) or group of customers. Price lists are used by the pricing logic in order entry to do "total order" pricing, as well as pricing each order line individually (not as it relates to the entire order). Price lists have a currency.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OP_PRCE_MST_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PRICELIST_ID
|
| OP_PRCE_MST_UK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PRICELIST_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICELIST_ID | NUMBER | (10) | Yes | Surrogate id to uniquely identify each row. |
| PRICELIST_DESC1 | VARCHAR2 | (40) | Yes | Description of price list. |
| PRICESORT_NAME | VARCHAR2 | (20) | Yes | Pricelist sort name. |
| COMMENTS | VARCHAR2 | (80) | Freeform text/comments. | |
| CURRENCY_CODE | VARCHAR2 | (4) | Yes | Currency code for pricelist; FK to gl_curr_mst. |
| CREATION_DATE | DATE | Yes | Standard who column | |
| PRICELIST_CODE | VARCHAR2 | (32) | Yes | Unique identifier for a pricelist. Name or code entered by user. |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
| DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| IN_USE | NUMBER | (10) | Not currently used | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT PRICELIST_ID
, PRICELIST_DESC1
, PRICESORT_NAME
, COMMENTS
, CURRENCY_CODE
, CREATION_DATE
, PRICELIST_CODE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TEXT_CODE
, DELETE_MARK
, IN_USE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
FROM GML.OP_PRCE_MST;
GML.OP_PRCE_MST does not reference any database object
GML.OP_PRCE_MST is referenced by following:
APPS
OP_PRCE_MST
|
|
|
|