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

TABLE: QP.QP_PRICE_BOOK_LINES

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


Line Summary Level Record of a Price Book


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PRICE_BOOK_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_BOOK_LINE_ID
QP_PRICE_BOOK_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_BOOK_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
PRICE_BOOK_LINE_ID NUMBER
Yes Primary Key
PRICE_BOOK_HEADER_ID NUMBER
Yes Foreign Key from QP_PRICE_BOOK_HEADERS_B
ITEM_NUMBER NUMBER

Item Number
PRODUCT_UOM_CODE VARCHAR2 (3)
UOM
LIST_PRICE NUMBER

List Price
NET_PRICE NUMBER

Net Price
SYNC_ACTION_CODE VARCHAR2 (1)
'R' (Replace), 'A' (Add) or 'D' (Delete).
LINE_STATUS_CODE VARCHAR2 (1)
Indicates if price book line has any Errrors or Warnings
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_LINE_ID
,      PRICE_BOOK_HEADER_ID
,      ITEM_NUMBER
,      PRODUCT_UOM_CODE
,      LIST_PRICE
,      NET_PRICE
,      SYNC_ACTION_CODE
,      LINE_STATUS_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QP.QP_PRICE_BOOK_LINES;

Dependencies

[top of page]

QP.QP_PRICE_BOOK_LINES does not reference any database object

QP.QP_PRICE_BOOK_LINES is referenced by following:

SchemaQP
ViewQP_PRICE_BOOK_LINES#