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_PB_INPUT_HEADERS_B

Object Details

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

Header Record of Price Book Request Input Criteria with non-transalateable columns

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_PB_INPUT_HEADERS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PB_INPUT_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PB_INPUT_HEADER_ID	NUMBER		Yes	Primary Key of the table
CUSTOMER_CONTEXT	VARCHAR2	(30)	Yes	CUSTOMER
CUSTOMER_ATTRIBUTE	VARCHAR2	(30)	Yes	QUALIFIER_ATTRIBUTE2
CUSTOMER_ATTR_VALUE	VARCHAR2	(240)		Party Id of Customer
DLV_XML_SITE_ID	NUMBER			Party Site Id to which Sync Catalog is sent
CURRENCY_CODE	VARCHAR2	(30)		Currency of the Price Book
LIMIT_PRODUCTS_BY	VARCHAR2	(30)		Can be ITEM, ITEM_CATEGORY, PRICE_LIST or blank
PRODUCT_CONTEXT	VARCHAR2	(30)		Product Context
PRODUCT_ATTRIBUTE	VARCHAR2	(30)		PRICING_ATTRIBUTE1 for Item Number;PRICING_ATTRIBUTE2 for Item Category
PRODUCT_ATTR_VALUE	VARCHAR2	(240)		Inventory Item Id or Category Id depending on the PRODUCT_ATTRIBUTE column value
EFFECTIVE_DATE	DATE		Yes	Pricing Effective Date - Default is sysdate
ITEM_QUANTITY	NUMBER		Yes	Default is 1
PUB_TEMPLATE_CODE	VARCHAR2	(80)		Referenced from the XDO_TEMPLATES_B table
PUB_LANGUAGE	VARCHAR2	(6)		XML Publisher Template Language
PUB_TERRITORY	VARCHAR2	(6)		XML Publisher Template Territory
PUB_OUTPUT_DOCUMENT_TYPE	VARCHAR2	(30)		Indicates the type of output document
DLV_XML_FLAG	VARCHAR2	(1)		SYNC_CATALOG generated if this flag is 'Y'
DLV_EMAIL_FLAG	VARCHAR2	(1)		'Y' if Pricebook to be sent by email
DLV_EMAIL_ADDRESSES	VARCHAR2	(240)		Relevant if Email Delivery Method is 'Y'
DLV_PRINTER_FLAG	VARCHAR2	(1)		Pricebook is printed if 'Y'
DLV_PRINTER_NAME	VARCHAR2	(80)		Relevant if the Print Delivery method is 'Y'
GENERATION_TIME_CODE	VARCHAR2	(30)		Indicates when to generate the price book - 'IMMEDIATE' or 'SCHEDULE' - Default is 'IMMEDIATE'
GEN_SCHEDULE_DATE	DATE			Relevant if GENERATION_TIME_CODE is SCHEDULE
REQUEST_ID	NUMBER			Stores the concurrent request id that processes the input
ORG_ID	NUMBER			For Multi-Org Support.Corresponds to an Operating Unit
PRICE_BOOK_TYPE_CODE	VARCHAR2	(1)	Yes	F or D (Full/Delta)-Default=F
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)		Application short name of the consumer application
PUBLISH_EXISTING_PB_FLAG	VARCHAR2	(1)		If 'Y', an existing pricebook is published
OVERWRITE_EXISTING_PB_FLAG	VARCHAR2	(1)		If 'Y' if an existing Price Book can be overwritten
REQUEST_ORIGINATION_CODE	VARCHAR2	(3)		indicates where the input/request originated from. Valid values are 'XML', 'UI', 'API' (Default)
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Required by Pricing Engine. Derived
VALIDATION_ERROR_FLAG	VARCHAR2	(1)		'Y' indicates messages exists for this Input Header Id
CREATION_DATE	DATE		Yes	Std Who Column
CUST_ACCOUNT_ID	NUMBER			Customer account id
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 PB_INPUT_HEADER_ID
,      CUSTOMER_CONTEXT
,      CUSTOMER_ATTRIBUTE
,      CUSTOMER_ATTR_VALUE
,      DLV_XML_SITE_ID
,      CURRENCY_CODE
,      LIMIT_PRODUCTS_BY
,      PRODUCT_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      EFFECTIVE_DATE
,      ITEM_QUANTITY
,      PUB_TEMPLATE_CODE
,      PUB_LANGUAGE
,      PUB_TERRITORY
,      PUB_OUTPUT_DOCUMENT_TYPE
,      DLV_XML_FLAG
,      DLV_EMAIL_FLAG
,      DLV_EMAIL_ADDRESSES
,      DLV_PRINTER_FLAG
,      DLV_PRINTER_NAME
,      GENERATION_TIME_CODE
,      GEN_SCHEDULE_DATE
,      REQUEST_ID
,      ORG_ID
,      PRICE_BOOK_TYPE_CODE
,      PRICE_BASED_ON
,      PL_AGR_BSA_ID
,      PRICING_PERSPECTIVE_CODE
,      PUBLISH_EXISTING_PB_FLAG
,      OVERWRITE_EXISTING_PB_FLAG
,      REQUEST_ORIGINATION_CODE
,      REQUEST_TYPE_CODE
,      VALIDATION_ERROR_FLAG
,      CREATION_DATE
,      CUST_ACCOUNT_ID
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QP.QP_PB_INPUT_HEADERS_B;

Dependencies

[top of page]

QP.QP_PB_INPUT_HEADERS_B does not reference any database object

QP.QP_PB_INPUT_HEADERS_B is referenced by following:

APPS: QP_PB_INPUT_HEADERS_B