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_INTERFACE_PRICING_ATTRIBS

Object Details

Object Name:	QP_INTERFACE_PRICING_ATTRIBS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_INTERFACE_PRICING_ATTRIBS
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.
Scope: public
Product: QP
Display Name: Interface Pricing Attributes
Category: BUSINESS_ENTITY QP_PRICE_LIST

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_INTERFACE_PRCNG_ATTRIBS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID PROCESS_STATUS_FLAG ORIG_SYS_HEADER_REF PRODUCT_ATTR_VALUE PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE INTERFACE_ACTION_CODE ORIG_SYS_LINE_REF
QP_INTERFACE_PRCNG_ATTRIBS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYS_HEADER_REF ORIG_SYS_LINE_REF
QP_INTERFACE_PRCNG_ATTRIBS_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYS_PRICING_ATTR_REF
QP_INTERFACE_PRCNG_ATTRIBS_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYS_LINE_REF REQUEST_ID PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE PRODUCT_ATTR_VALUE PRODUCT_UOM_CODE
QP_INTERFACE_PRCNG_ATTRIBS_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYS_PRICING_ATTR_REF REQUEST_ID INTERFACE_ACTION_CODE

Columns

Name	Datatype	Length	Comments
PRICING_ATTRIBUTE_ID	NUMBER		Pricing Attribute identifier.
CREATION_DATE	DATE		Standard Who Column
CREATED_BY	NUMBER		Standard Who Column
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER		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		Identifies the List Line in QP_LIST_LINES.
EXCLUDER_FLAG	VARCHAR2	(1)	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		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.
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'
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
PROCESS_ID	NUMBER		Process Id for transaction
PROCESS_TYPE	VARCHAR2	(30)	Process type of Calling Application
INTERFACE_ACTION_CODE	VARCHAR2	(30)	Update/Insert/Delete code
LOCK_FLAG	VARCHAR2	(2)	Locking indicator for transaction
PROCESS_FLAG	VARCHAR2	(2)	Process flag for transaction
DELETE_FLAG	VARCHAR2	(2)	Delete flag for transaction
PROCESS_STATUS_FLAG	VARCHAR2	(2)	Process Status Flag for transaction
PRICE_LIST_LINE_INDEX	NUMBER		Price List Line Index
LIST_LINE_NO	VARCHAR2	(30)	List Line Number
PRODUCT_ATTR_CODE	VARCHAR2	(50)	Product attribute code
PRODUCT_ATTR_VAL_DISP	VARCHAR2	(50)	Product attribute display value.
PRICING_ATTR_CODE	VARCHAR2	(50)	Pricing attribute code
PRICING_ATTR_VALUE_FROM_DISP	VARCHAR2	(50)	Pricing attribute from value of a range.
PRICING_ATTR_VALUE_TO_DISP	VARCHAR2	(50)	Pricing attribute disply value of the to value in the range.
ATTRIBUTE_STATUS	VARCHAR2	(50)	Indicate the error in the attribute validation.
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
,      LIST_HEADER_ID
,      PRICING_PHASE_ID
,      QUALIFICATION_IND
,      PRICING_ATTR_VALUE_FROM_NUMBER
,      PRICING_ATTR_VALUE_TO_NUMBER
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROCESS_ID
,      PROCESS_TYPE
,      INTERFACE_ACTION_CODE
,      LOCK_FLAG
,      PROCESS_FLAG
,      DELETE_FLAG
,      PROCESS_STATUS_FLAG
,      PRICE_LIST_LINE_INDEX
,      LIST_LINE_NO
,      PRODUCT_ATTR_CODE
,      PRODUCT_ATTR_VAL_DISP
,      PRICING_ATTR_CODE
,      PRICING_ATTR_VALUE_FROM_DISP
,      PRICING_ATTR_VALUE_TO_DISP
,      ATTRIBUTE_STATUS
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_PRICING_ATTR_REF
,      ORIG_SYS_HEADER_REF
FROM QP.QP_INTERFACE_PRICING_ATTRIBS;

Dependencies

[top of page]

QP.QP_INTERFACE_PRICING_ATTRIBS does not reference any database object

QP.QP_INTERFACE_PRICING_ATTRIBS is referenced by following:

QP: QP_INTERFACE_PRICING_ATTRIBS#