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

TABLE: QP.QP_PRICE_BOOK_BREAK_LINES

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


This table stores the price break child lines for PBH type of price list lines and modifiers in the generated Price Book.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PRICE_BOOK_BREAK_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_BOOK_BREAK_LINE_ID
QP_PRICE_BOOK_BREAK_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_BOOK_LINE_ID
ColumnPRICE_BOOK_LINE_DET_ID
QP_PRICE_BOOK_BREAK_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_BOOK_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
PRICE_BOOK_BREAK_LINE_ID NUMBER
Yes Primary Key
PRICE_BOOK_HEADER_ID NUMBER
Yes Foreign Key from QP_PRICE_BOOK_HEADERS_B
PRICE_BOOK_LINE_ID NUMBER
Yes Foreign Key from QP_PRICE_BOOK_LINES
PRICE_BOOK_LINE_DET_ID NUMBER
Yes Foreign Key from QP_PRICE_BOOK_LINE_DETAILS
PRICING_CONTEXT VARCHAR2 (30) Yes Always 'VOLUME'
PRICING_ATTRIBUTE VARCHAR2 (30) Yes Item Quantity, Item Amount, etc
PRICING_ATTR_VALUE_FROM VARCHAR2 (240)
Value From
PRICING_ATTR_VALUE_TO VARCHAR2 (240)
Value To
COMPARISON_OPERATOR_CODE VARCHAR2 (30)
'=' or 'BETWEEN'
PRICING_ATTRIBUTE_DATATYPE VARCHAR2 (30)
Data Type
OPERAND NUMBER

Price Break Value
APPLICATION_METHOD VARCHAR2 (30)
Application Method
RECURRING_VALUE NUMBER

Holds the recurring value in block price breaks
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
Query Text

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


SELECT PRICE_BOOK_BREAK_LINE_ID
,      PRICE_BOOK_HEADER_ID
,      PRICE_BOOK_LINE_ID
,      PRICE_BOOK_LINE_DET_ID
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      COMPARISON_OPERATOR_CODE
,      PRICING_ATTRIBUTE_DATATYPE
,      OPERAND
,      APPLICATION_METHOD
,      RECURRING_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QP.QP_PRICE_BOOK_BREAK_LINES;

Dependencies

[top of page]

QP.QP_PRICE_BOOK_BREAK_LINES does not reference any database object

QP.QP_PRICE_BOOK_BREAK_LINES is referenced by following:

SchemaQP
ViewQP_PRICE_BOOK_BREAK_LINES#