eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: QP.QP_PRICE_BOOK_HEADERS_ALL_B

Object Details

Object Name:	QP_PRICE_BOOK_HEADERS_ALL_B
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_PRICE_BOOK_HEADERS_ALL_B
Subobject Name:
Status:	VALID

Header Level Record of a Price Book containing non-translateable columns

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_PRICE_BOOK_HEADERS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_BOOK_HEADER_ID
QP_PRICE_BOOK_HEADERS_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_BOOK_HEADER_ID	NUMBER		Yes	Primary Key
PRICE_BOOK_TYPE_CODE	VARCHAR2	(1)	Yes	'FULL' or 'DELTA'
CURRENCY_CODE	VARCHAR2	(30)	Yes	Currency Of Price book
EFFECTIVE_DATE	DATE			Effective Date of Price Book
ORG_ID	NUMBER			Operating Unit
CUSTOMER_ID	NUMBER		Yes	Party_Id (Customer) on price book
PUB_STATUS_CODE	VARCHAR2	(30)		Used to poll for xml publisher
ITEM_CATEGORY	NUMBER			Category Id specified on Input
PRICE_BASED_ON	VARCHAR2	(30)		Can be PRICE_LIST, AGREEMENT, BSA or blank
PL_AGR_BSA_ID	NUMBER			Refers to a Price list Id, Agreement Id or BSA Id
PRICING_PERSPECTIVE_CODE	VARCHAR2	(30)	Yes	Application short name of the consumer application
ITEM_QUANTITY	NUMBER			Default is 1
REQUEST_ID	NUMBER			Concurrent Request Id
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Request Type Code; Required by Pricing Engine
PB_INPUT_HEADER_ID	NUMBER		Yes	Foreign Key to QP_PB_INPUT_HEADERS_B
CUST_ACCOUNT_ID	NUMBER			Customer account id
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
DOCUMENT_ID	NUMBER			Id of document stored in QP_DOCUMENTS

Query Text

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


SELECT PRICE_BOOK_HEADER_ID
,      PRICE_BOOK_TYPE_CODE
,      CURRENCY_CODE
,      EFFECTIVE_DATE
,      ORG_ID
,      CUSTOMER_ID
,      PUB_STATUS_CODE
,      ITEM_CATEGORY
,      PRICE_BASED_ON
,      PL_AGR_BSA_ID
,      PRICING_PERSPECTIVE_CODE
,      ITEM_QUANTITY
,      REQUEST_ID
,      REQUEST_TYPE_CODE
,      PB_INPUT_HEADER_ID
,      CUST_ACCOUNT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DOCUMENT_ID
FROM QP.QP_PRICE_BOOK_HEADERS_ALL_B;

Dependencies

[top of page]

QP.QP_PRICE_BOOK_HEADERS_ALL_B does not reference any database object

QP.QP_PRICE_BOOK_HEADERS_ALL_B is referenced by following:

QP: QP_PRICE_BOOK_HEADERS_ALL_B#