[Home] [Help] [Dependency Information]
Object Name: | QP_PRICE_BOOK_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PRICE_BOOK_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
This table stores:
1) the pricing attribute for the price list line (one of the detail lines) of each price book line of the Price Book that has been generated. Pricing Context, Attribute and Values are stored to preserve the actual pricing attributes associated with each Item in Price Book at the time of price book generation.
2) the Item Categories (product attributes) that have been sourced for the Item on the price list line. These records are tracked in order to support an Hgrid view where Items are grouped under Item Categories.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PRICE_BOOK_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRICE_BOOK_ATTRIBUTE_ID |
QP_PRICE_BOOK_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PRICE_BOOK_LINE_ID
PRICE_BOOK_LINE_DET_ID |
QP_PRICE_BOOK_ATTRIBUTES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRICE_BOOK_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRICE_BOOK_ATTRIBUTE_ID | NUMBER | Yes | Primary Key | |
PRICE_BOOK_LINE_DET_ID | NUMBER | Yes | Foreign Key from QP_PRICE_BOOK_LINE_DETAILS | |
PRICE_BOOK_LINE_ID | NUMBER | Yes | Foreign Key from QP_PRICE_BOOK_LINES | |
PRICE_BOOK_HEADER_ID | NUMBER | Yes | Foreign Key from QP_PRICE_BOOK_HEADERS_B | |
PRICING_PROD_CONTEXT | VARCHAR2 | (30) | Yes | Pricing or Product Context |
PRICING_PROD_ATTRIBUTE | VARCHAR2 | (30) | Yes | Pricing or Product Attribute |
PRICING_PROD_ATTR_VALUE_FROM | VARCHAR2 | (240) | Pricing Attribute Value From or Product Attribute Value | |
PRICING_ATTR_VALUE_TO | VARCHAR2 | (240) | Pricing Attribute Value To | |
COMPARISON_OPERATOR_CODE | VARCHAR2 | (30) | Yes | '=' or 'BETWEEN' |
PRICING_PROD_ATTR_DATATYPE | VARCHAR2 | (30) | Data Type | |
ATTRIBUTE_TYPE | VARCHAR2 | (30) | Yes | 'PRICING' or 'PRODUCT' |
CREATION_DATE | DATE | Yes | Std Who Column | |
CREATED_BY | NUMBER | Yes | Std Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Std Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Std Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Std Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_BOOK_ATTRIBUTE_ID
, PRICE_BOOK_LINE_DET_ID
, PRICE_BOOK_LINE_ID
, PRICE_BOOK_HEADER_ID
, PRICING_PROD_CONTEXT
, PRICING_PROD_ATTRIBUTE
, PRICING_PROD_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO
, COMPARISON_OPERATOR_CODE
, PRICING_PROD_ATTR_DATATYPE
, ATTRIBUTE_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM QP.QP_PRICE_BOOK_ATTRIBUTES;
QP.QP_PRICE_BOOK_ATTRIBUTES does not reference any database object
QP.QP_PRICE_BOOK_ATTRIBUTES is referenced by following:
|
|
|