DBA Data[Home] [Help] [Dependency Information]

TABLE: QP.QP_PRICING_ATTRIBUTES

Object Details
Object Name: QP_PRICING_ATTRIBUTES
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_PRICING_ATTRIBUTES
Subobject Name:
Status: VALID


QP_PRICING_ATTRIBUTES stores product information and pricing attributes. The PRODUCT_ATTRIBUTE and PRODUCT_ATTRIBUTE_VALUE columns identify the product or level in the item hierarchy, i.e item context at which the price or modifier is set. The PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE and PRICING_ATTR_VALUE_FROM columns store the pricing attributes which further define what is being priced. If the PRICING_ATTRIBUTE_CONTEXT is VOLUME the pricing attributes column stores the break unit attribute, e.g. item quantity and both the PRICING_ATTR_VALUE_FROM and PRICING_ATTR_VALUE_TO columns can be populated. The Product information is repeated for all pricing attributes. A record is always created for the VOLUME context which may or may not have an attribute defined.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PRICING_ATTRIBUTES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICING_ATTRIBUTE_ID
QP_PRICING_ATTRIBUTES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_ATTRIBUTE_CONTEXT
ColumnPRODUCT_ATTRIBUTE
ColumnPRODUCT_ATTR_VALUE
ColumnPRODUCT_UOM_CODE
ColumnPRICING_ATTRIBUTE_CONTEXT
ColumnPRICING_ATTRIBUTE
ColumnPRICING_ATTR_VALUE_FROM
QP_PRICING_ATTRIBUTES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnPRICING_ATTRIBUTE_CONTEXT
ColumnPRICING_ATTRIBUTE
ColumnSEARCH_IND
ColumnPATTERN_VALUE_FROM_NEGATIVE
ColumnPATTERN_VALUE_TO_NEGATIVE
ColumnLIST_LINE_ID
QP_PRICING_ATTRIBUTES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYS_HEADER_REF
ColumnORIG_SYS_LINE_REF
ColumnORIG_SYS_PRICING_ATTR_REF
QP_PRICING_ATTRIBUTES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_ATTRIBUTE_CONTEXT
ColumnPRODUCT_ATTRIBUTE
ColumnPRODUCT_ATTR_VALUE
ColumnORIG_SYS_HEADER_REF
ColumnORIG_SYS_LINE_REF
QP_PRICING_ATTRIBUTES_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnPRICING_PHASE_ID
ColumnEXCLUDER_FLAG
ColumnQUALIFICATION_IND
QP_PRICING_ATTRIBUTES_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnLIST_HEADER_ID
ColumnPRICING_ATTRIBUTE_CONTEXT
ColumnPRICING_ATTRIBUTE
QP_PRICING_ATTRIBUTES_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_ATTR_VALUE
ColumnPRODUCT_ATTRIBUTE
ColumnPRICING_PHASE_ID
QP_PRICING_ATTRIBUTES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_LINE_ID
ColumnEXCLUDER_FLAG
QP_PRICING_ATTRIBUTES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_LINE_ID
ColumnPRODUCT_ATTRIBUTE_CONTEXT
ColumnPRODUCT_ATTRIBUTE
ColumnPRODUCT_ATTR_VALUE
ColumnPRODUCT_UOM_CODE
QP_PRICING_ATTRIBUTES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICING_ATTRIBUTE_CONTEXT
ColumnPRICING_ATTRIBUTE
QP_PRICING_ATTRIBUTES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICING_PHASE_ID
ColumnQUALIFICATION_IND
ColumnPRODUCT_ATTRIBUTE_CONTEXT
ColumnPRODUCT_ATTRIBUTE
ColumnPRODUCT_ATTR_VALUE
ColumnEXCLUDER_FLAG
ColumnLIST_HEADER_ID
ColumnLIST_LINE_ID
QP_PRICING_ATTRIBUTES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnPRICING_ATTRIBUTE_CONTEXT
ColumnPRICING_ATTRIBUTE
ColumnCOMPARISON_OPERATOR_CODE
ColumnPRICING_ATTR_VALUE_FROM
ColumnPRICING_ATTR_VALUE_TO
QP_PRICING_ATTRIBUTES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnQUALIFICATION_IND
ColumnPRICING_PHASE_ID
ColumnLIST_LINE_ID
QP_PRICING_ATTRIBUTES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnPRICING_ATTRIBUTE_CONTEXT
ColumnPRICING_ATTRIBUTE
ColumnSEARCH_IND
ColumnPATTERN_VALUE_FROM_POSITIVE
ColumnPATTERN_VALUE_TO_POSITIVE
ColumnLIST_LINE_ID
QP_PRICING_ATTRIBUTES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYS_HEADER_REF
ColumnORIG_SYS_LINE_REF
ColumnLIST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
PRICING_ATTRIBUTE_ID NUMBER
Yes Pricing Attribute identifier.
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
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
LIST_LINE_ID NUMBER
Yes Identifies the List Line in QP_LIST_LINES.
EXCLUDER_FLAG VARCHAR2 (1) Yes This is used to exclude a product from a price or modifier which is defined at a higher level in the product hierarchy, i.e a higher segment than the INVENTORY_ITEM_ID attribute in the ITEM context in the Pricing Attribute Descriptive Flexfield.
ACCUMULATE_FLAG VARCHAR2 (1)
Not used.
PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2 (30)
The context of the product or segment in the item hierarchy, always ITEM.
PRODUCT_ATTRIBUTE VARCHAR2 (30)
The attribute in the ITEM context in the Pricing Attribute Descriptive Flexfield for which the price or modifier is defined.
PRODUCT_ATTR_VALUE VARCHAR2 (240)
The value for the attribute in the ITEM context, identifies the actual item, product group etc. for which the price or modifier is defined.
PRODUCT_UOM_CODE VARCHAR2 (3)
Unit of measure of the item, product group etc. for which the price or modifier is defined.
PRICING_ATTRIBUTE_CONTEXT VARCHAR2 (30)
Context in the Pricing Attribute Descriptive Flexfield
PRICING_ATTRIBUTE VARCHAR2 (30)
The attribute column in the Pricing Attribute Descriptive Flexfield
PRICING_ATTR_VALUE_FROM VARCHAR2 (240)
The value for the PRICING_ATTRIBUTE. Maybe the low value in a price break range if the PRICING_ATTRIBUTE_CONTEXT is VOLUME.
PRICING_ATTR_VALUE_TO VARCHAR2 (240)
The high value for the PRICING_ATTRIBUTE in a price break range if the PRICING_ATTRIBUTE_CONTEXT is VOLUME.
ATTRIBUTE_GROUPING_NO NUMBER
Yes Groups multiple pricing attributes together.
PRODUCT_ATTRIBUTE_DATATYPE VARCHAR2 (30)
Identifies the datatype of the PRODUCT_ATTRIBUTE_VALUE.
PRICING_ATTRIBUTE_DATATYPE VARCHAR2 (30)
Identifies the datatype of the PRODUCT_ATTRIBUTE_VALUE_FROM and PRODUCT_ATTRIBUTE_VALUE_TO
COMPARISON_OPERATOR_CODE VARCHAR2 (30)
The operator code used to define how the pricing engine should evaluate the pricing attributes, based on lookup type COMPARISON_OPERATOR.
CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure defining column
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
LIST_HEADER_ID NUMBER

Denormalized from QP_LIST_HEADERS_B.LIST_HEADER_ID
PRICING_PHASE_ID NUMBER

Denormalized from QP_LIST_LINES.PRICING_PHASE_ID
QUALIFICATION_IND NUMBER

Denormalized from QP_LIST_LINES.QUALIFICATION_IND
PRICING_ATTR_VALUE_FROM_NUMBER NUMBER

Contains the value of PRICING_ATTR_VALUE_FROM when PRICING_ATTRIUBUTE_DATATYPE='N' and COMPARISON_OPERATOR_CODE='BETWEEN'
PRICING_ATTR_VALUE_TO_NUMBER NUMBER

Contains the value of PRICING_ATTR_VALUE_TO when PRICING_ATTRIUBUTE_DATATYPE='N' and COMPARISON_OPERATOR_CODE='BETWEEN'
DISTINCT_ROW_COUNT NUMBER

Distinct_row_count stores the number of occurences of, ie count, of eachdistinct combination of pricing_attribute_context, pricing_attribute,pricing_attr_value_from, pricing_attr_value_to, comparison_operator_code and list_header_id. (Only pricing_attributes are considered in this count, not product attributes.)
SEARCH_IND NUMBER

For each list_line_id, the search_ind of the pricing_attribute record withthe least distinct_row_count is assigned the value 1. If multiple such records arefound one of it is assigned the search_ind value = 1, All the other records are assigned the search_ind value = 2. Every list_line_id with pricing_attributes musthave one and only one pricing attribute with search_ind = 1.
PATTERN_VALUE_FROM_POSITIVE VARCHAR2 (240)
If the pricing attribute's datatype is 'N', then this column stores the fixedlength canonical form of the number in pricing_attr_value_from_numbercolumn in the mask '00999999999999999999999.99999999999999999999999999999999999999'.If the pricing attribute datatype is 'X', 'Y' or 'C' then this column stores the value of the column pricing_attr_value_from.
PATTERN_VALUE_TO_POSITIVE VARCHAR2 (240)
If the pricing attribute's datatype is 'N', then this column stores the fixedlength canonical form of the number in pricing_attr_value_to_numbercolumn in the mask '00999999999999999999999.99999999999999999999999999999999999999'.If the pricing attribute datatype is 'X', 'Y' or 'C' then this column stores the value of the column pricing_attr_value_to.
PATTERN_VALUE_FROM_NEGATIVE VARCHAR2 (240)
If the pricing attribute's datatype is 'N', then this column stores the fixedlength canonical form of the number in pricing_attr_value_from_numbercolumn in the mask '00999999999999999999999.99999999999999999999999999999999999999'.If the pricing attribute datatype is 'X', 'Y' or 'C' then this column stores the value of the column pricing_attr_value_from.
PATTERN_VALUE_TO_NEGATIVE VARCHAR2 (240)
If the pricing attribute's datatype is 'N', then this column stores the fixedlength canonical form of the number in pricing_attr_value_to_numbercolumn in the mask '00999999999999999999999.99999999999999999999999999999999999999'.If the pricing attribute datatype is 'X', 'Y' or 'C' then this column stores the value of the column pricing_attr_value_to.
PRODUCT_SEGMENT_ID NUMBER

Identifier for the product context and attribute. Maps to qp_segments_b.segment_id.
PRICING_SEGMENT_ID NUMBER

Identifer for the pricing context and attribute. Maps to qp_segments_b.segment_id.
ORIG_SYS_LINE_REF VARCHAR2 (50)
The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded.
ORIG_SYS_PRICING_ATTR_REF VARCHAR2 (50)
The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded.
ORIG_SYS_HEADER_REF VARCHAR2 (50)
The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PRICING_ATTRIBUTE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_LINE_ID
,      EXCLUDER_FLAG
,      ACCUMULATE_FLAG
,      PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      ATTRIBUTE_GROUPING_NO
,      PRODUCT_ATTRIBUTE_DATATYPE
,      PRICING_ATTRIBUTE_DATATYPE
,      COMPARISON_OPERATOR_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LIST_HEADER_ID
,      PRICING_PHASE_ID
,      QUALIFICATION_IND
,      PRICING_ATTR_VALUE_FROM_NUMBER
,      PRICING_ATTR_VALUE_TO_NUMBER
,      DISTINCT_ROW_COUNT
,      SEARCH_IND
,      PATTERN_VALUE_FROM_POSITIVE
,      PATTERN_VALUE_TO_POSITIVE
,      PATTERN_VALUE_FROM_NEGATIVE
,      PATTERN_VALUE_TO_NEGATIVE
,      PRODUCT_SEGMENT_ID
,      PRICING_SEGMENT_ID
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_PRICING_ATTR_REF
,      ORIG_SYS_HEADER_REF
FROM QP.QP_PRICING_ATTRIBUTES;

Dependencies

[top of page]

QP.QP_PRICING_ATTRIBUTES does not reference any database object

QP.QP_PRICING_ATTRIBUTES is referenced by following:

SchemaQP
ViewQP_PRICING_ATTRIBUTES#